Welcome Guest
You last visited January 20, 2017, 12:55 pm
All times shown are
Eastern Time (GMT-5:00)

Help In Excel

Topic closed. 5 replies. Last post 9 years ago by winsumloosesum.

 Page 1 of 1
Michigan
United States
Member #59
November 10, 2000
380 Posts
Offline
 Posted: April 26, 2008, 8:04 am - IP Logged

How does one find a 4 digit number in a group of numbers
that are listed in a row in excel????? What is the formula ????

Example find out how many times 1234 came out in the past
numbers????? Can one also get how manytimes the 4 digit
number came out in different ways like 4321 --  2314  ETC----

2 7 8 8
7 2 8 6
4 4 7 2
5 1 5 2
4 0 2 7
0 7 6 1
3 6 9 9
7 0 0 1
7 9 5 8
9 9 5 6
8 8 4 4
0 8 2 0
8 7 7 2
1 8 4 0
2 7 5 2
7 0 6 0
2 4 8 4
8 0 9 2
8 2 6 0
9 7 5 9
1 3 6 2
1 7 6 1
8 9 6 2
2 5 4 9
2 4 0 1
6 3 0 2
0 3 2 9
4 7 0 5
5 9 9 7
9 1 5 0
0 2 9 7
Learning excel myself-----Butt need help---
Also do the numbers listed have to be in separate rows or
Together in one row in excel ????? 1-2-3-4  or 1234  ??
Thank you for you time and helping out---
Bob

Pennsylvania
United States
Member #2218
September 1, 2003
5396 Posts
Offline
 Posted: April 26, 2008, 10:36 am - IP Logged

How does one find a 4 digit number in a group of numbers
that are listed in a row in excel????? What is the formula ????

Example find out how many times 1234 came out in the past
numbers????? Can one also get how manytimes the 4 digit
number came out in different ways like 4321 --  2314  ETC----

2 7 8 8
7 2 8 6
4 4 7 2
5 1 5 2
4 0 2 7
0 7 6 1
3 6 9 9
7 0 0 1
7 9 5 8
9 9 5 6
8 8 4 4
0 8 2 0
8 7 7 2
1 8 4 0
2 7 5 2
7 0 6 0
2 4 8 4
8 0 9 2
8 2 6 0
9 7 5 9
1 3 6 2
1 7 6 1
8 9 6 2
2 5 4 9
2 4 0 1
6 3 0 2
0 3 2 9
4 7 0 5
5 9 9 7
9 1 5 0
0 2 9 7
Learning excel myself-----Butt need help---
Also do the numbers listed have to be in separate rows or
Together in one row in excel ????? 1-2-3-4  or 1234  ??
Thank you for you time and helping out---
Bob

Bob,

What state drawings(s) are you interested in.

Michigan
United States
Member #59
November 10, 2000
380 Posts
Offline
 Posted: April 26, 2008, 1:28 pm - IP Logged

Forgot to put my state down-----

We are from Michigan

Bob

Pennsylvania
United States
Member #2218
September 1, 2003
5396 Posts
Offline
 Posted: April 26, 2008, 4:08 pm - IP Logged

Forgot to put my state down-----

We are from Michigan

Bob

Bob,

The data file contains Connecticut Midday Pick 4.

I can enter Michigan Pick 4 draws in a new Excel file.

Not sure if you separate Midday and Evening draws or combine them.

Let me know what you want.

If you have a complete Pick 4 draw file that you can send would be better.

Michigan
United States
Member #59
November 10, 2000
380 Posts
Offline
 Posted: April 26, 2008, 6:22 pm - IP Logged

Hi  Winsumloosesum---

Can I send you a file in your private e-mailbox????

Pennsylvania
United States
Member #2218
September 1, 2003
5396 Posts
Offline
 Posted: April 26, 2008, 9:13 pm - IP Logged

Bob,

Below is the link for Michigan Pick 4 Excel file: