How to remove Duplicate date in Excel

Lot of data base work done by accountant is done by using Excel , in last decade Excel in one of the most powerful tools used by accountant it helps them analyzing the huge data with single clicks or few basic formulas. Today I am going to tell you how to remove duplicates while analyzing, this facility was not resent in 2003 but in 2007 and onward this is one of the basic future
To remove duplicate date in your Excel sheet is go to DATA tab

And sect removes duplicate

A new window will open which ask you on which criteria you want to remove duplicate or you want to expand your selection chose according to your need and you will get the result
Remember one thing it changes the original date so take backup of file first