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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 09:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com