check against a lottery database
 

Hello all .. I am new to forums , So please bear with me.
I have a reasonable knowledge EXCEL , and cell fomulas, and respectfully
request help with a personal project,,,,,.I have tried all sorts of cell
fomulas but with no luck at all
------------------------------------------------------------------------------
--------------------------------------------------
I am trying to check a single row of my 6 set numbers ...[ NOTE .. its only 6
cells wide ] , against my database to discover any prizes that may have been
won in the whole of the lottery history. ... Thats ...6 balls, 5 plus bonus,
5 balls, 4 balls, 3 balls prizes only.

I have made up an XL database of approx 1450 rows of past draw results.... {
NOTE ..7 cells in width since the bonus ball is also drawn.} ... These
results are are in rows D33 to D1488 in the database.

The line that I need to check is in row D6 : I6 ,, and I would like the cell
fomula to acheive my aim , to put in say cell L33. I obviously could then
copy & paste the formula down to the last row of the database.
------------------------------------------------------------------------------
-------------------------------------------------------------
Is it possible to diplay only the winning results in column L ,( below cell
L33 , or is that asking too much ???

Thanks in anticipation of a reply or two.

PAUL

check against a lottery database
 

Even if I didn't follow you to the bottom of the issue - the attached
suggestion can be a good start:
http://img30.imageshack.us/img30/2369/nonameh.png
Micky


"PAULGOR" wrote:

Hello all .. I am new to forums , So please bear with me.
I have a reasonable knowledge EXCEL , and cell fomulas, and respectfully
request help with a personal project,,,,,.I have tried all sorts of cell
fomulas but with no luck at all
------------------------------------------------------------------------------
--------------------------------------------------
I am trying to check a single row of my 6 set numbers ...[ NOTE .. its only 6
cells wide ] , against my database to discover any prizes that may have been
won in the whole of the lottery history. ... Thats ...6 balls, 5 plus bonus,
5 balls, 4 balls, 3 balls prizes only.

I have made up an XL database of approx 1450 rows of past draw results.... {
NOTE ..7 cells in width since the bonus ball is also drawn.} ... These
results are are in rows D33 to D1488 in the database.

The line that I need to check is in row D6 : I6 ,, and I would like the cell
fomula to acheive my aim , to put in say cell L33. I obviously could then
copy & paste the formula down to the last row of the database.
------------------------------------------------------------------------------
-------------------------------------------------------------
Is it possible to diplay only the winning results in column L ,( below cell
L33 , or is that asking too much ???

Thanks in anticipation of a reply or two.

PAUL

.

check against a lottery database
 

Please note:
the formula is an "Array-Formula" to be set with CTRL+SHIFT+ENTER
Micky


"PAULGOR" wrote:

Hello all .. I am new to forums , So please bear with me.
I have a reasonable knowledge EXCEL , and cell fomulas, and respectfully
request help with a personal project,,,,,.I have tried all sorts of cell
fomulas but with no luck at all
------------------------------------------------------------------------------
--------------------------------------------------
I am trying to check a single row of my 6 set numbers ...[ NOTE .. its only 6
cells wide ] , against my database to discover any prizes that may have been
won in the whole of the lottery history. ... Thats ...6 balls, 5 plus bonus,
5 balls, 4 balls, 3 balls prizes only.

I have made up an XL database of approx 1450 rows of past draw results.... {
NOTE ..7 cells in width since the bonus ball is also drawn.} ... These
results are are in rows D33 to D1488 in the database.

The line that I need to check is in row D6 : I6 ,, and I would like the cell
fomula to acheive my aim , to put in say cell L33. I obviously could then
copy & paste the formula down to the last row of the database.
------------------------------------------------------------------------------
-------------------------------------------------------------
Is it possible to diplay only the winning results in column L ,( below cell
L33 , or is that asking too much ???

Thanks in anticipation of a reply or two.

PAUL

.

check against a lottery database
 

מיכאל (מיקי) אבידן wrote:
Even if I didn't follow you to the bottom of the issue - the attached
suggestion can be a good start:
http://img30.imageshack.us/img30/2369/nonameh.png
Micky

Hello all .. I am new to forums , So please bear with me.
I have a reasonable knowledge EXCEL , and cell fomulas, and respectfully
[quoted text clipped - 24 lines]

.
Thanks Micky ... Looks interesting ... will give it a try....PAUL

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200912/1

check against a lottery database
 

מיכאל (מיקי) אבידן wrote:
Even if I didn't follow you to the bottom of the issue - the attached
suggestion can be a good start:
http://img30.imageshack.us/img30/2369/nonameh.png
Micky

Hello all .. I am new to forums , So please bear with me.
I have a reasonable knowledge EXCEL , and cell fomulas, and respectfully
[quoted text clipped - 24 lines]

.

Hi Micky .. I have tried to modify the formula in that image ... NO GOOD
since I have worked out that it is to do with the American powerball system ..
. totally diifferent to UK Lotto...Thanks for trying ... but I still need the
exact cell formula as requested in my post.

--
Message posted via http://www.officekb.com

check against a lottery database
 

PAULGOR wrote:
Even if I didn't follow you to the bottom of the issue - the attached
suggestion can be a good start:
[quoted text clipped - 6 lines]

.
Thanks Micky ... Looks interesting ... will give it a try....PAUL

HI Micky,
Was it you that also posted QUOTE..."Please note:
the formula is an "Array-Formula" to be set with CTRL+SHIFT+ENTER
Micky"

If "yes" ... could you possibly provide the formula???

Thanks

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200912/1

check against a lottery database
 

Don Guillett wrote:
Sorry that I don't have time to re-create your file for testing. I wish you
well.

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
[quoted text clipped - 34 lines]

PAUL

Never mind DON ... Thanks anyhow... my thread is just about solved on another
forum site
MERRY XMAS
PAUL

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200912/1