Forum Discussion
Reference Question
I am trying to figure out how to use the Lookup formulas in Excel to get what I need. I have a 2x100 table of values. The left column, "A", has a series of unique numbers. The right column. "B"...
L1
=UNIQUE(Source!B1:B100)
M1
=TRANSPOSE(SORT(FILTER(Source!$A$1:$A$100,(Source!$B$1:$B$100=L1))))