Excel question

[mkx]

I have a big excel file with words and phrases line by line in cell A, a lot of them have multiple repeats. In cell B, i would like to put the number of times the phrase has repeated. Example

Cell A Cell B
Job Fair 2
Job Fair 2
Crayons 1
Keyboards Rule 1
GFY 3
GFY 3
GFY 3


Hope someone can help

[Dagwolf]

That's a challenge, for sure... I love playing with Excel but I have no idea how to do that.

[mkx]

hummmmmm, maybe it can be done in php first?

[mkx]

bump bump

[donborno]

Pivot Tables

[raven1083]

I don't usually use excel on my work, don't have any idea on it!sorry

[blonda80]

left you a message on ICQ

[Iron Fist]

=COUNTIF(A:A,"[String your looking for here]")

[shekinah]

Type the first word eg. GFY 3 on a cell, then click the lowest line on the bottom right. There you'll see a cross mark,click mouse down without removing your finger.

[bonkerz2007]

=COUNTIF(A:A,"[String your looking for here]")

=COUNTIF(A:A,A1) and copy it down may work easier. Not sure if sharphead was implying that or not