Hey all,
I am hoping someone can help with this issue. I have 2 tabs. Info where the raw data is housed. Retrieval where the formula should go.
I have a list of Labels: 100, 200, 300, 400, & 500 in row 2 of the retrieval tab and under each column i would like to show a list of the corresponding Names.
I have attached the spreadsheet. Hopefully it will be something simple.
Thanks !
Dean
Enter this formula in C3 and pull it across and then down
=IFERROR(INDEX(info!$B$2:$B$21,AGGREGATE(15,6,ROW(info!$A$2:$A$21)-1/((info!$A$2:$A$21=C$2)),ROWS(C$3:C3))),"")
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
solved! thank you so much, works a charm. Have a wonderful day!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks