joshallen78
New Member
I have a column of information that contains a list of information, sometimes the same info will be repeated and sometimes it's only in once.
I'm trying to make a formula that when drug down will list each unique piece of information one time so I can do a sumif on it in the columns to the right. It is similar to a pivot table but a bit different, so that is why I'm trying to use a formula.
Any help would be much appreciated.
I'm trying to make a formula that when drug down will list each unique piece of information one time so I can do a sumif on it in the columns to the right. It is similar to a pivot table but a bit different, so that is why I'm trying to use a formula.
Any help would be much appreciated.