Ask Mac Questions and Get Answers from Experts ASAP
Yes there are several ways to do that depending on the data layout and where you want the results to be placed
Do you have the file available that you could send me, or would you like to describe the data layout (which columns, etc) so I can prepare a sample file
Ok, go to www.wikisend.com and upload the file there (no need to sign up). You will then get a page that has the download link and File ID. Copy the download link or the File ID and come back here and paste it in your reply.
If the file has sensitive information let me know before you upload it
Don't forget to send me the download link or file ID so I can access the file
Got it, thanks.
Ok you are looking for duplicates in column A irrespective of the data in the other columns, correct?. And do you want to mark the duplicate rows or delete them?
Ok Celeste here you go
I did it with formulas so you can use this method yourself on other files. The formulas are in column S (yellow cells). They return an X in the rows where the item in column A are duplicates. If you need assistance with deleting these rows please let me know
Hope this is ok. Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the solution