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