Any Excel geniuses?

Shikkaka

Shikkaka

Shikkaka

Soldato
Joined
10 Jun 2003
Posts
2,881
Location
Nottingham
Hi guys n gals,

At work we have this Excel speradsheet for the bonus ball lotto. We pick 3 numbers and the spreadsheet works out who has won and how much. This works by inputting the winning bonus ball number and the spreadsheet then looks at who has paid for that week then puts in R/O (Roll over) or the winners name.

I have just decided to join this lotto game and have inputted my name and my numbers and put an X that I have paid for this week. However when I input my number as the winning number (to test of course) it shows as R/O.

I've had a look myself but just cannot figure it out.

I would be grateful if anyone could look at this spreadsheet and try and figure it out.

I will send the spreadsheet to any volunteers e-mail addresses.

Cheers everyone.
 
I'll have a look....


wibsbot @ googlemail.com (without the spaces.) If you send it to me soon, I'll get it back to you today.
 
WIBSBOT said:
It might take a little while to look into - slightly more complicated than I imagined.
Click to expand...

The guy who created it is complicated lol.

There is no rush at all for it. My boss just asked me to have a look when I got chance.

Thanks
 
should be sorted - simple 'speeling' ;) mistake in the formula.

that guy must have had a whole load too much time on his hands.
 
You must log in or register to reply here.
Back
Top Bottom