Wednesday, September 26, 2012

yogi_Count Unique Products In A List And Present Results Sorted By Count In Descending Order In Another Sheet

Yogi Anand, D.Eng, P.E.      Google Spreadsheet   Post  #779  Sep 26, 2012    www.energyefficientbuild.com.

user Hoopsnl said: (http://productforums.google.com/forum/?zx=63d4ber84sra#!category-topic/docs/spreadsheets/DCAr1YxtwjQ
Count unique, sort and filter
Hi,
Hopefully someone can help me with this.
On the tab "LIST_1" in row A4:A I have put all kind of products, now I want to do some statistics in tab "STATS".
I would like to know (COUNT) how many times a product name appears in A4:A and the product counted most should appear on top;
[tab "LIST_1"]
Column A
Product X
Product X
Product X
Product X
Product A
Product A
Product B
The outcome should be:
[tab "STATS"]
Column A        Column B
Product X          4                    
Product A         2
Product B         1
Hopefully someone can help me with this..
Thx!

---------------------------------------------------------------------------------------
following is a solution to the broblem