GoFuckYourself.com - Adult Webmaster Forum

GoFuckYourself.com - Adult Webmaster Forum (https://gfy.com/index.php)

- Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)

- - Excel question (https://gfy.com/showthread.php?t=820094)

mkx	04-06-2008 12:23 AM

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

Dagwolf

04-06-2008 12:38 AM

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

mkx	04-06-2008 12:49 AM

hummmmmm, maybe it can be done in php first?

mkx	04-06-2008 03:14 AM

bump bump :(

donborno

04-06-2008 04:07 AM

Pivot Tables

raven1083

04-06-2008 04:35 AM

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

blonda80

04-06-2008 07:18 AM

left you a message on ICQ :)

Iron Fist

04-06-2008 07:58 AM

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

shekinah

04-06-2008 05:35 PM

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

04-06-2008 10:31 PM

Quote:

Originally Posted by sharphead (Post 14034041)

=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

All times are GMT -7. The time now is 05:57 AM.