cross referancing
if I have two columns on numbers how can I see if any numbers in column a
matches the number in column b preferably in the quickest possible way. I already have been using the find option now Im looking for a quicker way. please help!! |
Hi
=IF(COUNTIF(B:B,A1),"Match","no match") -- Regards Frank Kabel Frankfurt, Germany Chris the man form socail services wrote: if I have two columns on numbers how can I see if any numbers in column a matches the number in column b preferably in the quickest possible way. I already have been using the find option now Im looking for a quicker way. please help!! |
All times are GMT +1. The time now is 02:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com