| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
searching for and deleting duplicates
Hi , thanks for reading, Im having trouble with duplicates in spreadsheets. I need to search in one column for cells that are exactly the same as the cell directly above. In these cases I then need to delete the entire row. Hopefully this is possible! Many thanks for any help, Shandy -- Shandy720 ------------------------------------------------------------------------ Shandy720's Profile: http://www.excelforum.com/member.php...o&userid=26230 View this thread: http://www.excelforum.com/showthread...hreadid=565929 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
searching for and deleting duplicates
Shandy
What I usually do is put an indicator of the duplicates in a new column like this. Assuming the column you are testing is A then in B2 I put the formula =if(A2=A1,"*","") Fill that down for as far as you want to test. Then I filter on the * in column B and delete the lines. Not very pretty but quite effective. Martin "Shandy720" wrote: Hi , thanks for reading, Im having trouble with duplicates in spreadsheets. I need to search in one column for cells that are exactly the same as the cell directly above. In these cases I then need to delete the entire row. Hopefully this is possible! Many thanks for any help, Shandy -- Shandy720 ------------------------------------------------------------------------ Shandy720's Profile: http://www.excelforum.com/member.php...o&userid=26230 View this thread: http://www.excelforum.com/showthread...hreadid=565929 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
searching for and deleting duplicates
great cheers martin, that does the treat!!! -- Shandy720 ------------------------------------------------------------------------ Shandy720's Profile: http://www.excelforum.com/member.php...o&userid=26230 View this thread: http://www.excelforum.com/showthread...hreadid=565929 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Instructions on searching workbook for duplicates in Excel | Excel Discussion (Misc queries) | |||
| Deleting Duplicates | Excel Worksheet Functions | |||
| Searching for Duplicates across columns and print to new column | Excel Programming | |||
| Deleting duplicates | Excel Programming | |||
| Deleting Duplicates | Excel Programming | |||
![Shandy720[_11_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
