Could someone write me a simple XL program?

[TwoCatSam]

If you do, I will somehow pay you back.

As some of you know, I believe certain numbers cause others to hit. (Voodoo Roulette)  This will test that theory.

What I need is this:

I insert a number in col A.....say 32

I need it to appear also in column b    32  32....when I hit enter.
Now my next number is 1.  It appears in col a a 32 folllowed by 1

32
1

However in col b, they are in numerical order

1
32

It must do this for up to 38 numbers

If I use the "delete" function to delete a number from col a, and move the cells upwards, it must also delete it from col b and arrange the numbers numerically.

I wish I could do it, but this is one stump I can't jump.

Sam

Mods:  If I put this thread in the wrong place, please move it.

[MattyMattz]

Sam,
if you can give me till Wednesday this week I'll get 'er gone, no probs.

MM

[TwoCatSam]

Listen, Wednesday, Thursday, Whenever........

I'm happy!

Thanks!

Sam

[MattyMattz]

Samster,

I have the worksheet completed.  Did you want it posted here or should I email you it? 
Everything you asked for should work:

Enter spins in Column A
Every time you hit the enter key (so after you enter a spin, click enter) it'll sort the spins in order and enter those results in Column B. 
It will sort up to 38 numbers (no more though, just an FYI... this can be changed of course).

One thing i noticed that might want to change (if possible).  After hitting Enter and all the data gets sorted, the highlighted cell always returns to cell A1... lemme know if you need that changed after testing this out.

MM

[TwoCatSam]

Mail it to TwoCatSam@cox.net

Thank you so much.

You must find some way I can repay you.

Sam

[MattyMattz]

Will do - on both accounts

MM

[Robeenhuut]

If you do, I will somehow pay you back.

As some of you know, I believe certain numbers cause others to hit. (Voodoo Roulette)  This will test that theory.

What I need is this:

I insert a number in col A.....say 32

I need it to appear also in column b    32  32....when I hit enter.
Now my next number is 1.  It appears in col a a 32 folllowed by 1

32
1

However in col b, they are in numerical order

1
32

It must do this for up to 38 numbers

If I use the "delete" function to delete a number from col a, and move the cells upwards, it must also delete it from col b and arrange the numbers numerically.

I wish I could do it, but this is one stump I can't jump.

Sam

Mods:  If I put this thread in the wrong place, please move it.

Hello Sam

Do you still play this numbers system?  1,2,12,21  2,3,23,32  etc.  In 2 days on SML i saw 0,10,20,30 group hit 16 times in a row within 9 spins.  The other day 12 times.  It was Ulysses thread.

Regards

[TwoCatSam]

Rob

I try to play it at Riverwind.  They have Roulette Revolution.  90% of the time you cannot get a bet down on a number.  It lands on a split, a quad or on the wrong number.  Then you can't move it.  It really, really sucks wind.

All we can really play are dozens.  The square for them is big enough to punch and have the bet land right.

Sam

[TwoCatSam]

-