View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
DDAI Consult[_2_] DDAI Consult[_2_] is offline
external usenet poster
 
Posts: 1
Default Excel 2007 - need to mark, not remove, duplicate records.

And there it is....

Thank you so much. Have a wonderful and productive day!!!

~~ / happy dance! / ~~

"iliace" wrote:

Home - Styles - Conditional Formatting - Highlight Cell Rules -
Duplicates

On Aug 21, 7:28 pm, DDAI Consult <DDAI
wrote:
Excel has a quick and easy way to remove duplicate records, but I need to
mark them and then remove them one at a time from a very large spreadsheet.

Is there a quick and easy to just to flag duplicate records?

Thanks for the help.