I used to think I was good at Excel until this stumped me.

I have a column with a variety of text in each cell.

Example:

A1
bob
bob
ted
ted
ted
charley
charley
charley
charley, etc.

Is there a formula or way I can take the whole column of data and have
it come back with something similar to:
bob = 2
ted=3
charley=4
etc.

for all the variables in the column?

Please help, I am dying over here.


--
prom4x
------------------------------------------------------------------------
prom4x's Profile: http://www.excelforum.com/member.php...o&userid=29010
View this thread: http://www.excelforum.com/showthread...hreadid=487412