Lookup Help
I have two tabs in a worksheet. Both have last and first names in column A
and B respectively. How do I search the names in the recent list to see which ones are not in the original list? |
Lookup Help
You can use something like
=SUMPRODUCT(--(Sheet3!$A$1:$A$300&Sheet3!$B$1:$B$300=A1&B1))=1 assuming both lists starts in A1 with last and B1 with first and there are no other characters in the cells but the names, in an adjacent cell in one sheet copy down, those with FALSE adjacent -are not in the other list -- Regards, Peo Sjoblom http://nwexcelsolutions.com "mike" wrote in message ... I have two tabs in a worksheet. Both have last and first names in column A and B respectively. How do I search the names in the recent list to see which ones are not in the original list? |
All times are GMT +1. The time now is 07:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com