Graham C1600
Board Regular
- Joined
- Feb 17, 2018
- Messages
- 96
- Office Version
- 365
All,
I have a spreadsheet with 10 lists on all displaying the top 10 numbers/users from a master list based on various criteria.
What I need to do Is search on all of the lists and see if any users appear in more than 1 list.
So in this example for instance in Cell J1 I want the first name that appears in all 3 lists. J2 the next and so on. Then in cell K1 I want the totals of all 3 lists for the name in J1.
Hope this makes sense and thanks in advance.
I have a spreadsheet with 10 lists on all displaying the top 10 numbers/users from a master list based on various criteria.
What I need to do Is search on all of the lists and see if any users appear in more than 1 list.
So in this example for instance in Cell J1 I want the first name that appears in all 3 lists. J2 the next and so on. Then in cell K1 I want the totals of all 3 lists for the name in J1.
Hope this makes sense and thanks in advance.