Hi,
I have a list of item numbers and the state they are going to, I am looking for a script that can pull a list of unique values and to the left list all unique states they go to separated by a comma. Any help would be greatly appreciated.
Hi,
I have a list of item numbers and the state they are going to, I am looking for a script that can pull a list of unique values and to the left list all unique states they go to separated by a comma. Any help would be greatly appreciated.
One way...
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
How about
In K2
=UNIQUE(FILTER(C2:C20,C2:C20<>""))
In J2 copied down
=IF(K2="","",TEXTJOIN(", ",,FILTER($B$2:$B$20,$C$2:$C$20=K2)))
Please try
Please Login or Register to view this content.
Worked well Bo_Ry, Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks