Search

Excel help Please!
I am using this formula to make a pick 3 number straight. For example: 413 now becomes 134.=IF(OR($A3= Ns ,$A3= Nd ), ,CONCATENATE((MIN(LEFT(R3),MID(R3,2,1),RIGHT(R3))),(MEDIAN(LEFT(R3),MID(R3,2,1),RIGHT(R3))),(MAX(LEFT(R3),MID(R3,2,1),RIGHT(R3))))) How can I change this to make a Pick 4 number straight? Thank you for your helpMickie
Jan 11, 2006, 7:05 pm - Mickie - Lottery Systems Forum

off topic, for excel people
I need to have a formula that converts time. What I mean is, change it to decimals.so for instance I put in 15:30 (hour, min)I want the formula to divide the minutes by 60 and display the decimal version of that.So it would give me 15.5 anyone know? I have been looking, but can't find the answer.
Jan 11, 2006, 4:16 pm - hareless - Lottery Discussion Forum

excel formula help
I am looking for a formula that will highlight all the double digit combos that have listed below. 066336227557508734116735284879486389622139981094909371683244250134015317912093870790 Don't know if I would need a vlookup here or if it has to be set up in another format.Any help is appreciated
Jan 7, 2006, 11:32 pm - lottaloot - Lottery Systems Forum

SoniQ BOOM, a new P3/P4 system (Excel)Reply
same here zoozie. not excel train.regular numbers guy.hope it is in basic for us not into excel hypersoniq.thanks from all of here at lp
Jan 6, 2006, 7:57 am - moreno1966 - Lottery Systems Forum

SoniQ BOOM, a new P3/P4 system (Excel)Reply
Hypersoniq - Great Job! I do hope the new version of your program includes basic set up/use for the non-excel folks like me. Seeing all of you put your heads together on this project ROCKS!I would help Hypersoniq... but excel is not my cup of tea. Looking forward to your new update.
Jan 6, 2006, 7:34 am - Zoozie - Lottery Systems Forum

Wheels using excel ?? Why Not!
Found a great VBA that allows you to create wheels or permutations as they are called. Here's what you do. Place C in A1 3 in A2And the numbers that you want in A3: down to whateverRun the code in order to see that wheels...There will be another sheet added to your workbook.
Jan 3, 2006, 8:54 pm - lottaloot - Lottery Discussion Forum

The combinatorics of a permutationReply
hypersoniq,That would be great if I was restricting myself to Excel.However, I needed a mathematical expression that could also work outside Excel for some other projects.Thank you for the suggestion.
Jan 3, 2006, 1:21 am - JADELottery - Mathematics Forum

Visual Basic Applications in ExcelReply
DIM is Dimension. Used for a variable as an array. Would assume the same applies to Excel. I don't program Excel, so I'll let the experts provide more details.
Dec 31, 2005, 12:59 pm - truecritic - Lottery Discussion Forum

Why would my excel formulas
keep changing when I insert copied cells from 1 spreadsheet to another??I have placed made my formulas absolute as well as relative??Maybe I am confused again they should be relative. I don't know..
Dec 30, 2005, 8:30 pm - lottaloot - Lottery Discussion Forum

The combinatorics of a permutationReply
Any of you finding this topic useful?Any questions about the spreadsheets, besided how to use Excel?(I'd like to avoid turning this into an Introduction to Excel Seminar.)
Dec 23, 2005, 4:21 pm - JADELottery - Mathematics Forum