MrsFrankieH
Active Member
- Joined
- Mar 25, 2011
- Messages
- 323
- Office Version
- 365
- Platform
- Windows
Hello, first, I’m happy to be a new member of MrExcel. It's an honor to be here.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
<o></o>
For some reason, it's extremely difficult for me to understand Excel jargon.<o></o>
I know it will take time to learn it but for me, i learn much better from experience than reading up on it.<o></o>
With that said, can someone help me create a formula?<o></o>
<o></o>
I have a pick3 and pick4 lottery spreadsheet. I'm trying to do the following:<o></o>
<o></o>
1. From my draw history, i want to extract values and put the value of the cell into the "odds" column and "even" column category of cells. The numbers are in individual cells.<o></o>
For Example:<o></o>
Draw Odds Evens <o></o>
303 3 3 0<o></o>
123 1 3 2 <o></o>
420 4 2 0<o></o>
<o></o>
2. From the draw history, i want to extract repeating values into the "Repeat" column. <o></o>
For example:<o></o>
Draw Repeaters<o></o>
303 3<o></o>
123 2 3<o></o>
420 2<o></o>
<o></o>
3. From Draw history, i want to extract Leapfrog values into "Leapfrog" column. Leapfrog numbers are numbers that are sequential from one draw to another.<o></o>
For example:<o></o>
<o></o>
Draw Leapfrog<o></o>
303 3<o></o>
123 1 2 <o></o>
420 2<o></o>
<o></o>
4. From Draw history, i want to extract "Doubles" values and put them in the Doubles column.<o></o>
For example:<o></o>
<o></o>
<o></o>
Draw Doubles<o></o>
303 3 3<o></o>
123 <o></o>
420 <o></o>
<o></o>
5. From Draw history, i want to extract "Triples" values and put them in Triples column (like doubles).<o></o>
<o></o>
6. From Draw history, i want to substitute number values for another number value .<o></o>
For example:<o></o>
<o></o>
<o></o>
Draw VTRAC<o></o>
303 8 5 8<o></o>
123 6 7 8 <o></o>
420 9 7 5 <o></o>
<o></o>
7. From the Draw history, i want to put an "X" in the appropriate column that represents the value.<o></o>
<o></o>
For example:<o></o>
<o></o>
Draw 0 1 2 3 4 5 6 7 8 9<o></o>
303 X XX<o></o>
123 X X X<o></o>
420 X X X <o></o>
<o></o>
All values are in individual cells. It's my hope to be able to extract these values using a function, vlookup, etc. and place them in the target cells. I hope this doesn't scatter when i post this thread. I hope you can help.<o></o>
I tried to copy and paste the spreadsheet, but was unable to. <o></o>
Please help. Thank you very much everyone.<o></o>
<o></o>
Mrs. Frankie
<o></o>
fficeffice" /><o></o><o
></o>For some reason, it's extremely difficult for me to understand Excel jargon.<o
></o>I know it will take time to learn it but for me, i learn much better from experience than reading up on it.<o
></o>With that said, can someone help me create a formula?<o
></o><o
></o>I have a pick3 and pick4 lottery spreadsheet. I'm trying to do the following:<o
></o><o
></o>1. From my draw history, i want to extract values and put the value of the cell into the "odds" column and "even" column category of cells. The numbers are in individual cells.<o
></o>For Example:<o
></o>Draw Odds Evens <o
></o>303 3 3 0<o
></o>123 1 3 2 <o
></o>420 4 2 0<o
></o><o
></o>2. From the draw history, i want to extract repeating values into the "Repeat" column. <o
></o>For example:<o
></o>Draw Repeaters<o
></o>303 3<o
></o>123 2 3<o
></o>420 2<o
></o><o
></o>3. From Draw history, i want to extract Leapfrog values into "Leapfrog" column. Leapfrog numbers are numbers that are sequential from one draw to another.<o
></o>For example:<o
></o><o
></o>Draw Leapfrog<o
></o>303 3<o
></o>123 1 2 <o
></o>420 2<o
></o><o
></o>4. From Draw history, i want to extract "Doubles" values and put them in the Doubles column.<o
></o>For example:<o
></o><o
></o><o
></o>Draw Doubles<o
></o>303 3 3<o
></o>123 <o
></o>420 <o
></o><o
></o>5. From Draw history, i want to extract "Triples" values and put them in Triples column (like doubles).<o
></o><o
></o>6. From Draw history, i want to substitute number values for another number value .<o
></o>For example:<o
></o><o
></o><o
></o>Draw VTRAC<o
></o>303 8 5 8<o
></o>123 6 7 8 <o
></o>420 9 7 5 <o
></o><o
></o>7. From the Draw history, i want to put an "X" in the appropriate column that represents the value.<o
></o><o
></o>For example:<o
></o><o
></o>Draw 0 1 2 3 4 5 6 7 8 9<o
></o>303 X XX<o
></o>123 X X X<o
></o>420 X X X <o
></o><o
></o>All values are in individual cells. It's my hope to be able to extract these values using a function, vlookup, etc. and place them in the target cells. I hope this doesn't scatter when i post this thread. I hope you can help.<o
></o>I tried to copy and paste the spreadsheet, but was unable to. <o
></o>Please help. Thank you very much everyone.<o
></o><o
></o>Mrs. Frankie
<o></o>
