Hello Everyone,
I am trying to analyze a list of last names. I would like to know how to set up a formula using 2 separate lists. The 1st list is the list of the total people by last name that have shown up to an event. The 2nd list is a list of Common Spanish Surnames. I want to know how many spanish surnames are contained on the 1st list. OF course the original list is much longer. Below is just a small sample. Please help
List 1. List 2-Spanish Surnames
A E
1. BARNETT 1. ABAD
2. BIELAMOWICZ 2. ABADIA
3. GIEGER 3. ABADIANO
4. GOLDEN 4. ABADIAS
5. LEISSNER 5. ABADILLA
6. LEISSNER 6. ABADIN
7. SAUNDERS 7. ABAIGAR
8. WEST HINSON 8. ABAJO
9. MURRAY 9. ABALLE
10. PEARCE 10. ABALO
Bookmarks