Forum Discussion
Need guidance regarding VBA
I have one excel file where I have to arrange the data based upon the unique ID. Here you can each unique ID has separate role and I need to make it align in a single cell(like down).
Can you please suggest how to proceed with it.
1 Reply
You don't need VBA for this, a simple formula will doe:
=TEXTJOIN(", ", TRUE, FILTER(Role_Range, ID_Range=Specific_ID, ""))
