Tuesday, September 5, 2017

yogi_Pull Multiple Results For Specified Entities And Present As A Table

Google Spreadsheet   Post  #2237

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Sep-05-2017
question by: marklawler.za

Looking for help with a Sheets formula


I'm a real novice at Google Sheets formulas and always find myself needing one that's way beyond what I know so I'm hoping someone can help me with this ...

I have 2 columns where column B has numbers that repeat randomly and column C that has random numbers that occur only once.

I want to transpose a list of column C's numbers against column B's numbers which, in the "answer array" are listed only once each.

I'm suspecting the solution will include a combination of "vlookup" and "transpose" but I haven't been able to find a solution online yet or work it out myself.

You can look at an example of what I'm trying to do HERE.

Thanks in advance ...

M a r k