Excel Function
 

I have a list of numbers (1,2,4,5,2,1,2,3,4,) in a column and i would like a
function to list them out as a total (1 = x, 2 = x, 3=x, 4=x) i did this one
time long ago and i can not remember how. Could someone assist me.

I also need one for words listed as the request above.

Excel Function
 

=countif(a:a,1)
will count the 1's

=countif(a:a,6)
will count the 6's

=countif(a:a,"somewordhere")
will count the somewordhere's

James Odom wrote:

I have a list of numbers (1,2,4,5,2,1,2,3,4,) in a column and i would like a
function to list them out as a total (1 = x, 2 = x, 3=x, 4=x) i did this one
time long ago and i can not remember how. Could someone assist me.

I also need one for words listed as the request above.

--

Dave Peterson

Excel Function
 

Do you mean:

=COUNTIF(A1:A9,1)

=COUNTIF(A1:A9,2)

etc.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"James Odom" wrote in message
...
I have a list of numbers (1,2,4,5,2,1,2,3,4,) in a column and i would like
a
function to list them out as a total (1 = x, 2 = x, 3=x, 4=x) i did this
one
time long ago and i can not remember how. Could someone assist me.

I also need one for words listed as the request above.

Excel Function
 

Another thought, put this in a cell and drag down

=COUNTIF(A:A,ROW(A1))&" "&ROW(A1)&" s"

Mike

"James Odom" wrote:

I have a list of numbers (1,2,4,5,2,1,2,3,4,) in a column and i would like a
function to list them out as a total (1 = x, 2 = x, 3=x, 4=x) i did this one
time long ago and i can not remember how. Could someone assist me.

I also need one for words listed as the request above.