Excel question

[Molly]

Hello. I am fairly new at Excel. I have made a spreadsheet with 500 entries
(4 fields each). I see there are some duplicates. Is these an easy way to
find duplicates, or remove duplicates?

Thanks
Molly

 

[Tyro]

You don't state what version of Excel you're using. That is very helpful
here. If you are using Excel 2007, then Data/Data Tools/Remove Duplicates
may help you.
I suggest that no matter what you do, you save a copy of your workbook just
in case.

Tyro

 

[Molly]

Thanks Tyro! I am using Excel 2007.

Much appreciated.

Molly