Hello, I am a beginner with excel. I have a big list (vertical list) of product numbers. The numbers are not in a database and i want a function which counts all the different product numbers in that list and all the matches in the list with the same product number. Is this possible?
example
product number
ABC-01
ABC-02
ABC-03
ABC-01
The outcome need to be
3 different product numbers:
ABC-01
ABC-02
ABC-03
Matches:
2x ABC-01
1x ABC-02
1x ABC-03
Thanks a lot for helping me!
Bookmarks