| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Need find cell b3 value on another worksheet!
explanation: for axample: Cell b3 value is: 10030002452: also this value is on another worksheet. So i need find it is true or not! P.S. need get formule becouse i want find in all colum dublicates. -- StarGazer ------------------------------------------------------------------------ StarGazer's Profile: http://www.excelforum.com/member.php...fo&userid=9403 View this thread: http://www.excelforum.com/showthread...hreadid=273075 |
|
#2
|
|||
|
|||
|
Hi
try something like =IF(COUNTIF('other_sheet'!B3:B100,10030002452)0," Duplicate","No match found") "StarGazer" wrote: explanation: for axample: Cell b3 value is: 10030002452: also this value is on another worksheet. So i need find it is true or not! P.S. need get formule becouse i want find in all colum dublicates. -- StarGazer ------------------------------------------------------------------------ StarGazer's Profile: http://www.excelforum.com/member.php...fo&userid=9403 View this thread: http://www.excelforum.com/showthread...hreadid=273075 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why am I unable to link a cell in one worksheet to a cell in anot. | Excel Discussion (Misc queries) | |||
| Can I link a cell to reflect a worksheet name? | Excel Discussion (Misc queries) | |||
| Need formule which would find cell (exmp b3) value on another worksheet! please help! | Excel Worksheet Functions | |||
| Need find cell b3 value on another worksheet! | Excel Worksheet Functions | |||
| Need find cell b3 value on another worksheet! | Excel Worksheet Functions | |||
Linear Mode
