Hi all,
Happy Friday! Another good day to solve a puzzle haha...
I have a super complex spreadsheet that I sadly cannot change in terms of format (so please don't suggest that ).
- In range A4:A13, I have repeating values (e.g. value1, value2, value1, value3, value1 etc.)
- In range B3:G2 I have the output value I want to essentially get to
- the range B4:G13 contains 3 different values (X, Y, Z)
- I want to create a (vertical) list for each of the values in range A4:A13
- Each list should show the output in range B3:G2, based on if the index match cell contains X, Y or Z
- The output values should be unique, e.g. if there are several X, Y or Z against value3, it should only list the output once
I've attached the example file. Hope this all makes sense? Makes my head explode!
Appreciate any help!
Bookmarks