Hi,
Attached is the sample sheet.
My input looks like a range of alphanumeric entries and each entry in Column B is grouped to a alphabet in F.
So C should return all the concurrent values concatenated based on group in column F.
sample output is shown in column R. Please help.
Please try
R1
=TEXTJOIN(",",TRUE,IF($F$1:$F$19=$Q1,$B$1:$B$19,""))
And press Ctrl-Shift-Enter for array formula.
Regards.
My English is very poor, so please be patient >_<"
My Dynamic Related Dropdown post:
https://www.excelforum.com/excel-for...ml#post5657376
https://www.excelforum.com/excel-for...ml#post5655711
https://www.excelforum.com/excel-for...ml#post5655762
thank you for the help, i tried this formula however, it return all the values i.e for A it also returns values of B
Apologies, it works fine, thank you
It also returns the duplicates as well.
For Eg B - G2,G3,G4,G5,F2,F3,7,Z3,7. 7 is being repeated 2 times. could you please advise how to eradicate duplicates?
Sorry, I didn't noticed that they are some duplicates in the data.
Please try again
M1
=IF(COUNTIFS(B$1:B1,B1,F$1:F1,F1)=1,B1,"")
and
R1
=TEXTJOIN(",",TRUE,IF($F$1:$F$19=$Q1,$M$1:$M$19,""))
Press Ctrl-Shift-Enter for array formula.
Regards.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks