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
ffice
ffice" /><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
>




<o


For some reason, it's extremely difficult for me to understand Excel jargon.<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


With that said, can someone help me create a formula?<o


<o


I have a pick3 and pick4 lottery spreadsheet. I'm trying to do the following:<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


For Example:<o


Draw Odds Evens <o


303 3 3 0<o


123 1 3 2 <o


420 4 2 0<o


<o


2. From the draw history, i want to extract repeating values into the "Repeat" column. <o


For example:<o


Draw Repeaters<o


303 3<o


123 2 3<o


420 2<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


For example:<o


<o


Draw Leapfrog<o


303 3<o


123 1 2 <o


420 2<o


<o


4. From Draw history, i want to extract "Doubles" values and put them in the Doubles column.<o


For example:<o


<o


<o


Draw Doubles<o


303 3 3<o


123 <o


420 <o


<o


5. From Draw history, i want to extract "Triples" values and put them in Triples column (like doubles).<o


<o


6. From Draw history, i want to substitute number values for another number value .<o


For example:<o


<o


<o


Draw VTRAC<o


303 8 5 8<o


123 6 7 8 <o


420 9 7 5 <o


<o


7. From the Draw history, i want to put an "X" in the appropriate column that represents the value.<o


<o


For example:<o


<o


Draw 0 1 2 3 4 5 6 7 8 9<o


303 X XX<o


123 X X X<o


420 X X X <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


I tried to copy and paste the spreadsheet, but was unable to. <o


Please help. Thank you very much everyone.<o


<o


Mrs. Frankie


