Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel: Find repeated items and be able to delete quickly, option.
There should be an option or formula that you can run on excel to find all
duplicated line items for example: Line 1 has John Doe Line 2 has John Doe Line 3 has Jane Doe Line 4 has Jane Doe Each line and column has the same date for each person. It would be easier, especially if there are over 1400 rows to use an option to find and select all duplicated lines and delete them without have to go through the whole document which takes up to much time. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel: Find repeated items and be able to delete quickly, opti
Thank you.
"Peo Sjoblom" wrote: You can already do this, use dataadvanced filter, select unique records only. -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Faith Shirley" <Faith wrote in message ... There should be an option or formula that you can run on excel to find all duplicated line items for example: Line 1 has John Doe Line 2 has John Doe Line 3 has Jane Doe Line 4 has Jane Doe Each line and column has the same date for each person. It would be easier, especially if there are over 1400 rows to use an option to find and select all duplicated lines and delete them without have to go through the whole document which takes up to much time. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I find items common to two columns in Excel? | Excel Discussion (Misc queries) | |||
How do I find items common to two columns in Excel? | Excel Discussion (Misc queries) | |||
updated Excel sheet from my sent items and cannot find | New Users to Excel | |||
Can't group pivot table items by month in Excel | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) |