Forum Discussion
cdg786
Jan 19, 2022Copper Contributor
List/Data/Summary question
Goal is to have a summary sheet of which vendors were chosen throughout a purchasing project.
Sheet 1 is a matrix of all items to be purchased, listed by vendor (pulling from a linked master sheet).
Sheet 2 is a summary of vendors being used. I need to summarize which vendors were chosen but do not want duplicates.
For instance: If I have vendor A listed 4 times for 4 different items, I only want vendor A listed once on a summary sheet, instead of four times. How do I do this? Ideally the summary sheet auto-populates as vendors are listed in the product matrix.
Advice welcome.
2 Replies
- Benny_1857Brass Contributorif your summary sheet is sheet 2 and data is in sheet1. ColumnA A2 to A20 =UNIQUE(Sheet1!A2:A20)
- Benny_1857Brass Contributor=Unique(A2:A20)