Please help with Excel

Status
Not open for further replies.

MrsFrankieH

Active Member
Joined
Mar 25, 2011
Messages
268
Office Version
  1. 365
Platform
  1. 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:eek:ffice:eek:ffice" /><o:p></o:p>
<o:p></o:p>
For some reason, it's extremely difficult for me to understand Excel jargon.<o:p></o:p>
I know it will take time to learn it but for me, i learn much better from experience than reading up on it.<o:p></o:p>
With that said, can someone help me create a formula?<o:p></o:p>
<o:p></o:p>
I have a pick3 and pick4 lottery spreadsheet. I'm trying to do the following:<o:p></o:p>
<o:p></o:p>
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:p></o:p>
For Example:<o:p></o:p>
Draw Odds Evens <o:p></o:p>
303 3 3 0<o:p></o:p>
123 1 3 2 <o:p></o:p>
420 4 2 0<o:p></o:p>
<o:p></o:p>
2. From the draw history, i want to extract repeating values into the "Repeat" column. <o:p></o:p>
For example:<o:p></o:p>
Draw Repeaters<o:p></o:p>
303 3<o:p></o:p>
123 2 3<o:p></o:p>
420 2<o:p></o:p>
<o:p></o:p>
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:p></o:p>
For example:<o:p></o:p>
<o:p></o:p>
Draw Leapfrog<o:p></o:p>
303 3<o:p></o:p>
123 1 2 <o:p></o:p>
420 2<o:p></o:p>
<o:p></o:p>
4. From Draw history, i want to extract "Doubles" values and put them in the Doubles column.<o:p></o:p>
For example:<o:p></o:p>
<o:p></o:p>
<o:p></o:p>
Draw Doubles<o:p></o:p>
303 3 3<o:p></o:p>
123 <o:p></o:p>
420 <o:p></o:p>
<o:p></o:p>
5. From Draw history, i want to extract "Triples" values and put them in Triples column (like doubles).<o:p></o:p>
<o:p></o:p>
6. From Draw history, i want to substitute number values for another number value .<o:p></o:p>
For example:<o:p></o:p>
<o:p></o:p>
<o:p></o:p>
Draw VTRAC<o:p></o:p>
303 8 5 8<o:p></o:p>
123 6 7 8 <o:p></o:p>
420 9 7 5 <o:p></o:p>
<o:p></o:p>
7. From the Draw history, i want to put an "X" in the appropriate column that represents the value.<o:p></o:p>
<o:p></o:p>
For example:<o:p></o:p>
<o:p></o:p>
Draw 0 1 2 3 4 5 6 7 8 9<o:p></o:p>
303 X XX<o:p></o:p>
123 X X X<o:p></o:p>
420 X X X <o:p></o:p>
<o:p></o:p>
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:p></o:p>
I tried to copy and paste the spreadsheet, but was unable to. <o:p></o:p>
Please help. Thank you very much everyone.<o:p></o:p>
<o:p></o:p>
Mrs. Frankie :)<o:p></o:p>
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
48,400
Office Version
  1. 365
Platform
  1. Windows
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.
 
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,127,936
Messages
5,627,714
Members
416,268
Latest member
zRGZgDNnmaPhepwviEou

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top