Thread: Percentage of values in list
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default Percentage of values in list
To get percentage change C1 to =COUNTIF(......)/COUNTA(A1:A25) and format as
%
cheers
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

wrote in message
...
Hi Guys,

I am a excel n00b so, please be gentle!!

I have a caolumn with a list of values of cars like:

Ford
Chrysler
Ford
Toyota
Mazda
Toyota
Ford
Ford

I want to create a new sheet that lists all possible values and for
each value the number of times it appears in the list.

In this case it would be:

Ford 4
Toyota 2
Chrysler 1

etc etc etc

Could someone please help on how to do it?

The cell range is about C4-C26000 and has about 100 different possible
values so its quite large.

Thanks in advance,

-Al


Reply With QuoteReply With Quote