# formula trouble

#### ozygonzo

##### New Member
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

### Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
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?

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>

Replies
5
Views
69
Replies
2
Views
138
Replies
5
Views
254
Replies
1
Views
562
Replies
14
Views
1K

1,203,096
Messages
6,053,512
Members
444,669
Latest member
Renarian

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back