check against a lottery database

[PAULGOR]

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

 

[מיכ×ל (מיקי) ×בידן]

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

 

[מיכ×ל (מיקי) ×בידן]

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

 

[PAULGOR via OfficeKB.com]

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

 

[PAULGOR via OfficeKB.com]

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.

 

[PAULGOR via OfficeKB.com]

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

 

[Don Guillett]

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
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

 

[PAULGOR via OfficeKB.com]

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
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

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 - 28 lines]

PAUL

Sorry Don ..... too much there for a newbie like me to understand ...
Think my original thread explains fully what I am looking for ...
RE-QUOTE. FOR YOUR ATTENTION
-----------------------------------------------------------------------------
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

 

[Don Guillett]

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

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
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

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 - 28 lines]

PAUL

Sorry Don ..... too much there for a newbie like me to understand ...
Think my original thread explains fully what I am looking for ...
RE-QUOTE. FOR YOUR ATTENTION
-----------------------------------------------------------------------------
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
----------------------------------------------------------------------------

Muchas

PAUL

 

[PAULGOR via OfficeKB.com]

Sorry that I don't have time to re-create your file for testing. I wish you
well.
[quoted text clipped - 34 lines]

PAUL

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