| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
delete duplicate values - leaving unique records only i.e. recordspresent once only
hiya,
i see lots of posts resolving the following:- a a b c d d e to a b c d e however what i want to do is take a column and turn a a b c d d e into b c e i.e showing me data that is present once only... any ideas how i do this? excel 2007 many thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I delete redundant records in Excel without then leaving b | Excel Discussion (Misc queries) | |||
| Display only duplicate values and delete UNIQUE Items | Excel Discussion (Misc queries) | |||
| delete a duplicate in column while leaving other duplicates | Excel Worksheet Functions | |||
| How to delete values in each row leaving only last value ? | Excel Discussion (Misc queries) | |||
| In column A I have duplicate records. How do I tag an unique reco. | Excel Discussion (Misc queries) | |||
Threaded Mode
