| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
List with Duplicates to uniques list
Hi,
I have a large list of account codes in column C, i.e: 410500 410500 410500 443000 443700 etc What I'd like to do is next to it in column D have that same list, but without the duplicates or empty cells, (i.e. from small list above = 410500, 443000, 443700). What formula might achieve this? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Condensing a list with duplicates to a list with non-duplicates | Excel Worksheet Functions | |||
| Array Formulas - Unique List from List with Duplicates | Excel Discussion (Misc queries) | |||
| Count Uniques within a list based on value of cell... | Excel Discussion (Misc queries) | |||
| How to remove duplicates from a list and copy new list to new colu | Excel Worksheet Functions | |||
| Compare & create list of uniques across books/sheets | Excel Programming | |||
Threaded Mode
