filter 400 names from list 1 from list 2 with 4000 names
I have two lists, one with 400 names and one with 4000 names. I want to find
out how many of the 400names are on the list of 4000. Please help. |
See replies to your multiple posts.
Biff "Ed" wrote in message ... I have two lists, one with 400 names and one with 4000 names. I want to find out how many of the 400names are on the list of 4000. Please help. |
Enter this formula in column B.
=SUM(IF(A1=$C$1:$C$4000,1)) enter this formula and than press Ctrl+Shift+Enter together. In column A should be 400 name list. In column C - 4000 name list. Copy down this formula for all 400 names in column A. |
All times are GMT +1. The time now is 10:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com