Thanks for the responses. Although counting the number of duplicate cells is helpful, I think I might be looking for something like this:
http://www.add-ins.com/duplicate_finder.htm
but i don't want to download/buy another program. I was hoping that excel had something itself that could find...
Hi:
I am trying to compare rows of data in excel and want to know if this is possible.
For example, let's say I have the following data below. I want to run a "search" and see if there any repeats. So A1,B1 and A5,B5 are "doubles" - I'd want to know that and delete one row...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.