Sep 20 2022 01:02 AM
Hi can someone please help?
I have two tabs of data, tab one contains 16000 rows of data and tab two contains 900 rows of data that contains the names of 900 different people from my organisation (first name and surname). I quickly need to be able to see if any of the 900 peoples names appear on tab one (the 16000 rows of data), how can I do this please?
I am an Excel novice and have tried to search for the answer but to no avail.
thanks in advance
Scott
Sep 20 2022 01:18 AM
Sep 20 2022 01:21 AM
Sep 20 2022 02:11 AM
=COUNT(SEARCH(A1,sheet1!$A$1:$A$26))
An alternative could be this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021. The range of the formula (sheet1!$A$1:$A$26) can be adapted as required.
Result 1 means that first name x surname x is found on sheet1. Result 0 means that first name x surname x isn't found on sheet1.