Competition time!! Diskeeper 2011!!!

1. Jon von der Heyden
2. chuckchuckit
3. Peter_SSs
4. JamesW
5. SuperFerret
6. MrKowz
7. AlanSidman
8. atroxell
9. Cindy Ellis
10. schielrn
11. justme
12. meldoc
13. Sandeep Warrier
14. sailepaty
15. diddi
16. tweedle
17. Nalani
18. RobMatthews
19. YCJ
20. JazzSP8
21. mitchsherwin
22. delaneyjm
23. toddscott
24. Krishnakumar
25. Darren Bartrup
26. ntellers
27. Pedie
28. Avatars
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
1. Jon von der Heyden
2. chuckchuckit
3. Peter_SSs
4. JamesW
5. SuperFerret
6. MrKowz
7. AlanSidman
8. atroxell
9. Cindy Ellis
10. schielrn
11. justme
12. meldoc
13. Sandeep Warrier
14. sailepaty
15. diddi
16. tweedle
17. Nalani
18. RobMatthews
19. YCJ
20. JazzSP8
21. mitchsherwin
22. delaneyjm
23. toddscott
24. Krishnakumar
25. Darren Bartrup
26. ntellers
27. Pedie
28. Avatars
29. Btadams
 
Results!!!

Col B was generated by RAND() a few times and then I copy+pastespecial>values and sorted on the RANK() in col C. The top 5 are highlighted in Green. If these people could contact me with your full names and a valid email address I will pass on your details to my contact at Diskeeper.

Congratulations winners!

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5" /><col /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="background-color: #00B050;;">17. Nalani</td><td style="text-align: right;background-color: #00B050;;">0.992774</td><td style="text-align: right;background-color: #00B050;;">1</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="background-color: #00B050;;">18. RobMatthews</td><td style="text-align: right;background-color: #00B050;;">0.935178</td><td style="text-align: right;background-color: #00B050;;">2</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="background-color: #00B050;;">15. diddi</td><td style="text-align: right;background-color: #00B050;;">0.930403</td><td style="text-align: right;background-color: #00B050;;">3</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="background-color: #00B050;;">13. Sandeep Warrier </td><td style="text-align: right;background-color: #00B050;;">0.872472</td><td style="text-align: right;background-color: #00B050;;">4</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="background-color: #00B050;;">4. JamesW</td><td style="text-align: right;background-color: #00B050;;">0.869692</td><td style="text-align: right;background-color: #00B050;;">5</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5;color: #161120">Sheet1</p><br /><br />
 
It was fixed all along! :biggrin:

Congratulations chaps. :)

Just as well I didn't win. As it is I owe Richard big time (payment in lobster, so he says).
 
Last edited:
Aww so close.. XD

Congratulations anyway! This just proves that I ain't have that much luck in draws. :biggrin:

Cheers,
CJ
 
Congrats winners! :)

And I was SO close too! I really should stop stuff like this I'm always one of on lottery numbers as well :rofl:
 

Forum statistics

Threads
1,222,626
Messages
6,167,157
Members
452,099
Latest member
Auroraaa

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top