Forum Discussion
Solved
Look up and removing duplicates
Hi, hopefully someone can help me with this, I'm fairly new to excel and can't figure out how to make this work. Thank you!
Let's say the table is called DemoTbl.
You could use this:
=BYROW(DemoTbl[[AAL]:[LPA]],LAMBDA(each_row,TEXTJOIN(",",1,UNIQUE(each_row,1))))
Let's say the table is called DemoTbl.
You could use this:
=BYROW(DemoTbl[[AAL]:[LPA]],LAMBDA(each_row,TEXTJOIN(",",1,UNIQUE(each_row,1))))
This worked really well for me, thank you so much!