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.