To whom it may concern,
Can anyone tell me is there a way to have excel automatically find and flag duplicate data? I get a report of about five hundred rows of orders, there should not be any duplicate but if I ask excel to remove duplicate it does. The problem is I don't know what was removed so I can't see what needs fixing.
Thanks in advance
Can anyone tell me is there a way to have excel automatically find and flag duplicate data? I get a report of about five hundred rows of orders, there should not be any duplicate but if I ask excel to remove duplicate it does. The problem is I don't know what was removed so I can't see what needs fixing.
Thanks in advance