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