|
Not logged in [Login - Register] |
You Are Not Registered Or Not Logged In |
Corsa Sport » Message Board » Off Day » Geek Day » Excel sheet needed, can anyone help? » Post Reply
|
Brett |
posted on 17th Jun 12 at 23:39 |
quote: Seems to do just about everything you'd need. Let us know how you get on :) | |
Gaz |
posted on 17th Jun 12 at 11:23 |
I wanted to set up a section where it could tell you the winnings but as the EURO's have a flexible (non-set) amount when you win it would have to be integrated into their website which I cannot build :-( | |
Fro |
posted on 17th Jun 12 at 00:03 |
quote: Nice one Brett, going to have a play with that when I'm back to work and see what the functionality is like. | |
pow |
posted on 16th Jun 12 at 23:57 |
Dan I can help, talk to me on Monday. | |
Matt L |
posted on 16th Jun 12 at 16:45 |
Ill give this a go in a bit if you still need it and arent using the link above? | |
Brett |
posted on 16th Jun 12 at 15:51 |
http://download.cnet.com/Lottery-Syndicate-Manager-Complete-LSMC/3000-2647_4-10203644.html | |
Baskey |
posted on 16th Jun 12 at 15:36 |
I'm not sure what your sheet looks like mate. | |
Dan |
posted on 16th Jun 12 at 11:36 |
If you could make something better like you suggest Gaz, id really appreciate it, i just dont have the skillzz needed nor time, hence not overly fussed about going any further myself | |
Dan |
posted on 16th Jun 12 at 11:35 |
Im happy with just looking through to be honest. | |
Gaz |
posted on 16th Jun 12 at 11:29 |
quote: Conditional formatting will work as shown but you have an eliminate still of manually looking to see if someone won a tenner.... thats were formulating it will help you even more... you can take t a step further and have a summery box at the bottom which can tell you if money has been won(I.E, how many numbers on a line match) and then if you really wanted to, have a jackpot input box which calculates a rough winning amount in £. | |
Gaz |
posted on 16th Jun 12 at 11:26 |
you just need a fancy lookup if I remember rightly, can you host your document somewhere so we can download the peoples numbers and then have a go at it for you? | |
Dan |
posted on 16th Jun 12 at 11:26 |
Proper simple.... | |
Marc |
posted on 16th Jun 12 at 11:15 |
I reckon its doable if you list 1-49 at the side of everyones name and forulate it that way? | |
Dan |
posted on 16th Jun 12 at 11:13 |
Really? | |
Marc |
posted on 16th Jun 12 at 11:08 |
I know what you are saying, and I am by no means an expert on Excel. I'm not sure what you want is possible, as surely the forula needed for each candidates number would need a lot of code? | |
Dan |
posted on 16th Jun 12 at 11:00 |
As you have probably seen im running the euromillions syndicate, and i need to make my life easier. |