Excel Duplicate records

[jma]

I have a spreadsheet of numbers...I need to look for duplicates in two columns of the 10 that i have...

So - I have two lines that indicate mr. jones paid for his widget order on acct number 123456 in the amount of 505.00
so my line looks like:
jones widget 123456 500.00

I have thousands of these entries, I want to know if excel can search the list and tell me if it finds two entries on that account number for that amount of money?

Thanks very much, Michelle

 

[SkipVought]

Have you checked our FAQs and searched. Lots of advice on this one.

Skip,
[sub]
[red]Be advised:[/red]
Alcohol and Calculus do not mix!
If you drink, don't derive! [/sub]

 

[jma]

ok, now i have and no i didn't see this issue answered...got close a couple times but when i clicked on link it said page was no longer avail...

I have a new issue now as well but i'll do a new post for that..