Very Basic Help

Lisamariex · Mar 25th, 2002, 10:22 PM

I’m a total beginner at Excel and I know this is trivial to you Excelologists, but I want to analyze keno #s for my grandma. I have winning #s in a spreadsheet. (20 #s per game (in columns) and 1000+ games (in rows). What I want to find out is how many times a number shows up with another number. What do I do?
Thanks in advance...

Yogi Anand · Mar 25th, 2002, 10:31 PM

Quote:

On 2002-03-25 21:22, Lisamariex wrote:
I’m a total beginner at Excel and I know this is trivial to you Excelologists, but I want to analyze keno #s for my grandma. I have winning #s in a spreadsheet. (20 #s per game (in columns) and 1000+ games (in rows). What I want to find out is how many times a number shows up with another number. What do I do?
Thanks in advance...

Hi Lisamariex:
Welcome to the Board, and how about that 'Excologists'!
It will help if you can post some sample data about the games and the winning numbers. I am not familiar with the keno game but I am sure others who traverse this board are -- but posting some sample data will help!

Brian from Maui · Mar 25th, 2002, 10:49 PM

Yogi,

Keno is a game where there are ping pong balls numbered 1 - 80. 20 balls are drawn for each game. A wager is placed and payoffs are determined by the number of correct balls drawn from the 20.

Yogi Anand · Mar 25th, 2002, 11:00 PM

Quote:

On 2002-03-25 21:49, Brian from Maui wrote:
Yogi,

Keno is a game where there are ping pong balls numbered 1 - 80. 20 balls are drawn for each game. A wager is placed and payoffs are determined by the number of correct balls drawn from the 20.

Hello there Brian:
Thanks for the info -- it still does not mean that I understand the game -- well I guess because I am not into games!

Dave Hawley · Mar 25th, 2002, 11:56 PM

Hello Lisamariex

Let's say you have your number in Column A, in B1 put:

=Countif($A$:$A$5000,A1)

Then just copy this down.

BTW, if this helps you win the "BIG one" my contact details can be found on my Web site

)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 25th, 2002, 10:22 PM	#1
Lisamariex New Member Join Date: Mar 2002 Location: Texas Posts: 1	I’m a total beginner at Excel and I know this is trivial to you Excelologists, but I want to analyze keno #s for my grandma. I have winning #s in a spreadsheet. (20 #s per game (in columns) and 1000+ games (in rows). What I want to find out is how many times a number shows up with another number. What do I do? Thanks in advance...

Mar 25th, 2002, 10:49 PM	#3
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Yogi, Keno is a game where there are ping pong balls numbered 1 - 80. 20 balls are drawn for each game. A wager is placed and payoffs are determined by the number of correct balls drawn from the 20.

Mar 25th, 2002, 11:56 PM	#5
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hello Lisamariex Let's say you have your number in Column A, in B1 put: =Countif($A$:$A$5000,A1) Then just copy this down. BTW, if this helps you win the "BIG one" my contact details can be found on my Web site )