| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
List Unique Values from multiple columns
Is there a way to extract a list of unique values from multiple columns? I
have a file that I track which job an asset is on each day of the month. Example: A B C D Asset 6/01 6/02 6/03 Pump Job1 Job1 Job2 Pump2 Job1 Job3 Job3 Pump3 Job2 Job2 Job1 The exact would then list: Job1 Job2 Job3 This would be listed across with each unique job being listed in a cell. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a list of unique values from 2 columns of data | Excel Worksheet Functions | |||
| List unique Values from different columns: How to... | Excel Discussion (Misc queries) | |||
| Is it a way to get a unique list from multiple columns? | New Users to Excel | |||
| Compare multiple column of data and list out common and unique component in adj columns | Excel Worksheet Functions | |||
| create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
Hybrid Mode
