formula trouble

[ozygonzo]

I am having trouble with a formula that works than stops working than starts working;

this is the formular it works uu upto Feb 1981 draws then stops until Sept 1985 draws than starts working again
=INDEX($XEU$4:$XEU$3560,MATCH(MAX($XET$4:$XET$3560),$XET$4:$XET$3560,0))

the program is part of a lotto program I am writing for my wife

any ideas any help would be appreciated

 

[Robert Mika]

I am having trouble with a formula that works than stops working than starts working;

this is the formular it works uu upto Feb 1981 draws then stops until Sept 1985 draws than starts working again
=INDEX($XEU$4:$XEU$3560,MATCH(MAX($XET$4:$XET$3560),$XET$4:$XET$3560,0))

the program is part of a lotto program I am writing for my wife

any ideas any help would be appreciated

What's changes around that time(date)?
Coudl you post sample of your data?

 

[ozygonzo]

Hi Robert

I Looked at that after I posted and went of line and you were right something did change, the restarted the draws at 101 as they went from Six Balls and One supplementary ball to Six balls and Two supplementary ball therefore the date would not change until the draw went higher than 437 I fix this by shortening the date formula with =INDEX($XEU$4:$XEU$3560,1) and left evevery thing else as is
Draw Cell=INDEX($XET$3122:$XET$3561,MATCH(MAX($XEU$3122:$XEU$3561),$XEU$3122:$XEU$3561,0)) Date Cell is =INDEX($XEU$3122:$XEU$3561,1)
Numbers refer to Draw Cell

437	28/02/1981
28	37	18	39	12	31	8	0
Paul

<tbody>
</tbody><colgroup><col span="8"></colgroup>