It will be hard sometimes to find the duplicates in a spreadsheet. There is no easy way to do it. Expert have designed many macros but not everyone can buy it.
You can use formula to find that out. This is very helpful when you want to eliminate the duplicates from an email listing and also many things similar to this.
I have searched and found that Microsoft Support center has the explanation.
Visit the page below
http://support.microsoft.com/kb/213367
This works with MS Excel 2003 and MS Excel 2007
Your suggestions and questions help me bring better information to you.
[ad#post-link]
Read more tips from our website