Hi guys - I've tried to play around with this with little success on a pivot table. I realise this is probably kindergarten level Excel and I'll feel pretty daft when shown.
I've got a list of customers on one side, and a list of values on another. What's the simplest way I can display this so that it counts the number of different values used?
Example:
Customer Value
ANDERSON AAAA
ANDERSON AAAA
ANDERSON AAAA
ANDERSON AAAA
BENNETT EEEEE
COLLINS AAAA
DENNIS AAAA
DENNIS BBBB
DENNIS CCCC
DENNIS CCCC
To create
ANDERSON 1
BENNETT 1
COLLINS 1
DENNIS 3
Bookmarks