I am sure there is a way to do this but it is well beyond my skill set….. How would you construct a formula in excel to count the number of different items is a column which are grouped against the items in another column. Poorly explained, so best that I give an example.
In the “team” column, team “A” and team “B”, if the column named “order number” contained the below, excel would return a result of 3 against team “A” and a result of 4 against team “B” ie the number of different order numbers grouped against each team?
Team order number
A…….. 123
A…….. 234
A…….. 345
A…….. 345
A…….. 345
B…….. 345
B…….. 456
B…….. 456
B…….. 567
B…….. 678
(i’ve just used the…’s to space things out to make it more readable)
No idea where to start, maybe the collective hive (or just stoner!) could help! Cheers all