| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Create a list of unique entries based on several columns
https://www.dropbox.com/s/2k218jhud69lpsn/Book1.xlsx
In that file, you can see there is a list of somewhat similar data across 5 columns. Some of the entries are duplicates, some are different by only one character. What I want to be able to do is generate a list of all the unique rows of data, taking into account the data from ALL 5 columns. The list can be on another sheet or simply just further down on the same sheet, that doesn't matter too much. I could do it if it were just one column of data, but struggling trying to do it with several columns. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create List of Unique Values from several columns | Excel Discussion (Misc queries) | |||
| How do I create a list of unique values from 2 columns of data | Excel Worksheet Functions | |||
| Create list of unique entries for use in validation | Excel Worksheet Functions | |||
| Need to create unique list from list of multiple entries | Excel Programming | |||
| Excel funtion to create a unique list of entries ? | Excel Programming | |||
Threaded Mode
