(Solved) – How can I make a new Excel sheet containing unique individual ID and credentials based on multiple sheet records?

  • by
(solved)-–-how-can-i-make-a-new-excel-sheet-containing-unique-individual-id-and-credentials-based-on-multiple-sheet-records?

The computer in my office uses Windows 7 and Microsoft Office 2003(Excel 2003)

Say for example I have the table below in a sheet named JANUARY

JANUARY

and another named FEBRUARY.

FEBRUARY

How can I make a “database” of these people?
Something like this

result

What I have tried was the Data – > Filter – > Advanced Filter method to copy only the the unique ones into another sheet but it doesn’t even seem to work even on a simple test data

Leave a Reply

Your email address will not be published. Required fields are marked *