Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need find cell b3 value on another worksheet!
you are the best!!! respect, you really helped me very much, i like this forum:) Frank Kabel Wrote: 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 -- 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
thanks for your feedback :-) "StarGazer" wrote: you are the best!!! respect, you really helped me very much, i like this forum:) Frank Kabel Wrote: 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 -- StarGazer ------------------------------------------------------------------------ StarGazer's Profile: http://www.excelforum.com/member.php...fo&userid=9403 View this thread: http://www.excelforum.com/showthread...hreadid=273075 |
#3
|
|||
|
|||
Hi Chris here
I have a similar problem. but I want to find the duplicate number, which could be within 12 worksheets within the same workbook, but then return a value from the worksheets it's found in? Chris "StarGazer" wrote: you are the best!!! respect, you really helped me very much, i like this forum:) Frank Kabel Wrote: 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 -- StarGazer ------------------------------------------------------------------------ StarGazer's Profile: http://www.excelforum.com/member.php...fo&userid=9403 View this thread: http://www.excelforum.com/showthread...hreadid=273075 |
#4
|
|||
|
|||
Chris again
The 12 worksheets are Jan .. Dec. So what I'm after is for the worksheet name to be posted back to a cell. Just wanted to be clear Cheers "Chris" wrote: Hi Chris here I have a similar problem. but I want to find the duplicate number, which could be within 12 worksheets within the same workbook, but then return a value from the worksheets it's found in? Chris "StarGazer" wrote: you are the best!!! respect, you really helped me very much, i like this forum:) Frank Kabel Wrote: 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 -- 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 | |||
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 | |||
Need find cell b3 value on another worksheet! | Excel Worksheet Functions |