|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
04-06-2008, 12:23 AM
|
#1 |
|
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 |
|
|
|
04-06-2008, 12:38 AM
|
#2 |
|
President of Canada
Join Date: Sep 2003
Location: Leaving Hell, Entering Limbo
Posts: 23,141
|
 That's a challenge, for sure... I love playing with Excel but I have no idea how to do that.
__________________
Sleep well, and dream of large women. 
|
|
|
|
|
04-06-2008, 12:49 AM
|
#3 |
|
Confirmed User
Industry Role:
Join Date: Nov 2003
Location: Toronto
Posts: 4,001
|
hummmmmm, maybe it can be done in php first?
|
|
|
|
|
04-06-2008, 03:14 AM
|
#4 |
|
Confirmed User
Industry Role:
Join Date: Nov 2003
Location: Toronto
Posts: 4,001
|
bump bump
 |
|
|
|
|
04-06-2008, 04:07 AM
|
#5 |
|
Confirmed User
Join Date: Jan 2007
Location: Vienna, Austria
Posts: 374
|
Pivot Tables
|
|
|
|
|
04-06-2008, 04:35 AM
|
#6 |
|
Confirmed User
Join Date: Jul 2007
Posts: 7,687
|
I don't usually use excel on my work, don't have any idea on it!sorry
|
|
|
|
|
04-06-2008, 07:18 AM
|
#7 |
|
FOR HIRE: AFF Manager
Industry Role:
Join Date: May 2006
Location: EU
Posts: 10,959
|
left you a message on ICQ
|
|
|
|
|
04-06-2008, 07:58 AM
|
#8 |
|
Too lazy to set a custom title
Join Date: Dec 2006
Posts: 23,400
|
=COUNTIF(A:A,"[String your looking for here]")
__________________
i like waffles |
|
|
|
|
04-06-2008, 05:35 PM
|
#9 |
|
Confirmed User
Join Date: May 2006
Posts: 8,452
|
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.
__________________
 [Web Design | Development | Programming | Content Writing ]
ICQ: 238-890-469 |
|
|
|
|
04-06-2008, 10:31 PM
|
#10 | |
|
Confirmed User
Join Date: Sep 2005
Posts: 794
|
Quote:
=COUNTIF(A:A,A1) and copy it down may work easier. Not sure if sharphead was implying that or not |
|
|
|
|
