ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   List Unique Values from multiple columns (https://www.excelbanter.com/excel-discussion-misc-queries/191927-list-unique-values-multiple-columns.html)

Chance224

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



All times are GMT +1. The time now is 08:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com