Thread: Excel question
View Single Post
Old 04-06-2008, 12:23 AM  
mkx
Confirmed User
 
Industry Role:
Join Date: Nov 2003
Location: Toronto
Posts: 4,001
Excel question

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
mkx is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote