Returning consolidated values from indexing.
Dear Gurus,
I would like to seek your advise on how to auto conlidate the data below into a summary sheet? I have data in column A and B. data in column a is repeated a few times. How am I able to consolidate the data into the results table? In the results section, "tb" will be manually keyed in and john and sarah will be the return values. Please help!! Thank you!
tb john
tb john
tb sarah
as ben
as ben
as jean
as jean
as jean
Results
tb john
sarah
as ben
jean
|