Hello everyone,
I have copied and pasted in piece meals a large chart and realized that there many rows that are duplicated. Would like to know how to delete with a function rather than one by one manually. In the chart column A is the date ie2/2/2015)
Thank You
Josh
Last edited by Josh1759; 05-13-2016 at 12:04 AM.
hi josh, when you say chart , do you mean table?
Just to be sure i understand, are you saying that, In col a, if 2/2/2015 appears more than once, you want ALL duplicates removed?
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
say for eg that you column heading is called date, add this code to this workbook and run
Please Login or Register to view this content.
Correct. I also know that there are 19 rows that are duplicated. I know this from that row count in the excel sheet 879 and on the website it shows 860 results.
Thank you
josh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks