I have a column of repeating ID numbers and a column of corresponding school subjects. How do I structure a formula so that there is a single row with a unique ID number and a cell that combines all of the values of the school subjects? See attached for example.
Hello Abhishek ,
go to the Post 4 of the thread https://www.excelforum.com/tips-and-...geravatar.html
copy the code go to developer tab then click visual basic and click insert and insert , insert a module and then paste the code
now you can use this user defined function (UDF) in your sheet.
then In H2 copy paste below
Formula:
Please Login or Register to view this content.
You can also go for VBA code otherwise.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
ARRAY formulas are used
In E2 then copy down
=IFERROR(INDEX($A$2:$A$11,SMALL(IF(COUNTIF($E$1:E1,$A$2:$A$11)=0,ROW($A$2:$A$11),""),1)-ROW($A$2)+1),"")
In F2 then copy across
=IFERROR(INDEX($B$2:$B$11,SMALL(IF($A$2:$A$11=$E2,ROW($B$2:$B$11),""),COLUMNS($E2:E2))-ROW($A$2)+1),"")
ARRAY formula is used
To enter ARRAY formula
Paste the formula
Press F2
Press Ctrl+Shift+Enter keys together.
formula will be covered with{} brackets by excel.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Thanks - I'm getting #NAME in the cell - what am I doing wrong?
To whom you are responding !
Responding to hemesh
Check the attachment!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks