Hey
I need help to find a good way, maybe in several steps to join several columns of data into one and return the name of the rows that are most to the left or right - depending on the data.
I have this data spread out over several columns and several of the columns have the same numbers.
I want to join them into only one column and return the row header for each.
When there are the same number in several of the rows the one furthest to the left or right will be the one that give me the row header.
example of the data and the right answer.
Bookmarks