Please help with Excel

[MrsFrankieH]

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

 

[texasalynn]

duplicate
http://www.mrexcel.com/forum/showthread.php?t=538828

 

[Peter_SSs]

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per the Posting Rules (especially points 21-23).

Any bumps, clarifications, or follow-ups should be posted back to the linked thread.