Excel Help!!

Reply #13

lottaloot — Wed, 29 Jun 2005 04:24:15 GMT

It's me again. Looking for a formula that will return a result of how many days out a pair is.Pair's location start in (V2) and in in V46. Am I to use lookup? Any help is appreciated

Reply #12

MollyG — Mon, 20 Jun 2005 18:50:52 GMT

Check my Blog. I listed the formula IF the 3 numbers are in 3 columns. I guess there's more than one way to skin a cat .....

Reply #11

lottaloot — Mon, 20 Jun 2005 15:47:47 GMT

I like it!I like it

Reply #10

winsumloosesum — Mon, 20 Jun 2005 12:16:33 GMT

Thanks everyone for all your help.Someone recommended the following:1. Download all my past drawings.2. Text to columns.3. Use the next four columns and use =small(a1:d1,1) through =small(a1:d1,4)4. The next cell i1 =e1 f1 g1 h1 Thanks,wsls

Reply #9

SirMetro — Sat, 18 Jun 2005 18:03:05 GMT

My thanks go to Adolf BlueGrass.The Cash3 works like a charm. That cash4 needs some help, it works on just 3 of the 4 digits. This one will probably require a macro instead of a formula because the 4th digit simply makes it complex.The only other option I can think of that will retain it as a formula is to reflect ALL 24 ways the number can be reflected and do the MIN selection on it. Here is the revised formula for Cash 4=MIN((CONCATENATE($C6,$D6,$E6,$F6)),(CONCATENATE($C6,$D6,$F6,$E6)),(CONC... [ More ]

Reply #8

lottaloot — Sat, 18 Jun 2005 17:23:54 GMT

SirMetroYour formulas are always short to the point

Reply #7

lottaloot — Sat, 18 Jun 2005 17:20:50 GMT

Pick-3 4 in the Boxes Excel Formulas ---thanks go to Adolf6166 =MIN(LEFT(A1),MID(A1,2,1),RIGHT(A1))=MEDIAN(LEFT(A1),MID(A1,2,1),RIGHT(A1)) =MAX(LEFT(A1),MID(A1,2,1),RIGHT(A1)) =MAX(LEFT(A1),MID(A1,2,1),RIGHT(A1),MID(A1,3,1)) =CONCATENATE(B1,C1,D1,E1)----------------------------------------123 =MIN(LEFT(A1),MID(A1,2,1),RIGHT(A1)) =MEDIAN(LEFT(A1),MID(A1,2,1),RIGHT(A1)) =MAX(LEFT(A1),MID(A1,2,1),RIGHT(A1)) =CONCATENATE(B1,C1,D1)Good Luck!!Adolf

Reply #6

SirMetro — Sat, 18 Jun 2005 16:54:17 GMT

That setup worked great. Only modification I did was to combine it into a single formula. I have no clue why I never thought of that. Guess that's what happens when I try to make things to damn complex.=CONCATENATE((MIN(LEFT($C2),MID($C2,2,1),RIGHT($C2))),(MEDIAN(LEFT($C2),MID($C2,2,1),RIGHT($C2))),(MAX(LEFT($C2),MID($C2,2,1),RIGHT($C2))))Change $C2 to reflect whatever cell you want it to reflect

Reply #5

Bluegrass — Sat, 18 Jun 2005 08:37:41 GMT

This might help you with the Pick-3, I have not experimented with the Pick-4 number, but perhaps this will point you in the right direction:Best to utilize a few more cells, assuming the number to be base sorted is in Cell A1, use Cells B1, C1, D1to sort and separate the individual numbers, then Concatenate the final results into another Cell (E1 in this instance)B1=MIN(LEFT(A1),MID(A1,2,1),RIGHT(A1))C1=MEDIAN(LEFT(A1),MID(A1,2,1),RIGHT(A1))D1=MAX(LEFT(A1),MID(A1,2,1),RIGHT(A1))E1=CONCATENATE(B1... [ More ]

Reply #4

lottaloot — Sat, 18 Jun 2005 07:04:31 GMT

Can anyone tell me what the function offset does? In layman's terms. I get easily

Reply #3

LANTERN — Sat, 18 Jun 2005 03:07:28 GMT

Can you all read minds?I have been needing to do that to a list (single vertical column) of pick 3 numbers (combos) for a long long time and with no software to do it with (among other things that I have also been needing to do, but can't remember what they are just now, because I gave up on being able to do them time ago

Reply #2

SirMetro — Sat, 18 Jun 2005 02:41:48 GMT

Grrrr....I have been avoiding doing that one for a bit...guess I had better think bout it for a bit cause I could use it as well.Sir Metro

Reply #1

lottaloot — Sat, 18 Jun 2005 02:29:44 GMT

I am going to give this a whirl until SirMetro to the rescue. Example:Pick 3 Cell A1 748 Formula to change it to: 478 in cell B1If the draw results wereB1=7C1=4D1=8E1 =CONCATENATE(C1,B1,D1) Results would be 478Still trying to get the change to occur within the next cell by using the =SUM( LT) =SUM (MID) functions

Excel Help!!

winsumloosesum — Fri, 17 Jun 2005 22:31:06 GMT

Excel professionals.I am trying to find a formula for taking a Pick 3 and Pick 4 from its drawn combination and formulate it to the ascending order.Example:Pick 3 Cell A1 748 Formula to change it to: 478 in cell B1 Pick 4 Cell A1 7482Formula to change it to: 2478 in cell B1 Thanks in advance!!wsls