QUOTE (cndblank @ Oct 14 2009, 12:07 PM)
Either open office or Excel 97.
Perhaps having a numbered column at the top so you can count off however many you need and having the five and sixes bolded.
And Thank you very much.
Try this little excel sheet out.
http://www.mediafire.com/file/zd4tmz4mmlz/rolld6_test1.zipIf you get ?NAME errors, try the following steps in Excel:
1. On the Tools menu, click Add-Ins.
2. In the Add-Ins available list, select the Analysis ToolPak box, and then click OK.
3. If necessary, follow the instructions in the setup program.
According to excel.tips.net the RANDBETWEEN function should work with excel 97.A note on calculation refreshing in excel:
A refresh happens Automatically/Manually/Before Save based on your settings in Tools->Options->Calculation
If it is set to Manually, you have to tell the sheet when the recalculate. If it is automatic, EVERY TIME you enter any data, all cells will refreshed. This means if you are entering in numbers and see a result you want to keep, the instant you enter in a new number all of the RANDBETWEEN functions will recalculate all all results will change.
See this alternate version, with Calculation refresh set to Manual. In excel 2003 you press F9 to manually refresh.