Forum Discussion
How can I check to see if the 900 people appear in an Excel sheet that contains 16000 different rows
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 (f...
=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.