MrExcel Publishing
Your One Stop for Excel Tips & Solutions

VLOOKUP or SORT unique ???

Posted by GLITZ on December 29, 2000 8:35 AM

I have a workbook with 6 tabs. In the A and B column of the first 5 tabs are (A) employee numbers and (B) employee names.

What I want is a list on the 6th tab that only has one of each employee number and name no matter if they are on all five tabs or just one.

Any input?

Posted by cpod on December 29, 2000 8:44 AM

Well, you could copy all the names and numbers on the 5 sheets to a new sheet and use the advanced filter to create a unique list.