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

  • by

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


and another named FEBRUARY.


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


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 *