USA Mega

Lottery Places

The time is now 11:34 pm

You last visited
April 18, 2024, 10:51 pm

All times shown are
Eastern Time (GMT-5:00)

Home › Blogs › MollyG's Blog › Formula for putting draws into series order

Formula for putting draws into series order

Published:

I keep a complete history of Texas Pick3:

Columns:  A - S

Date Drawn Order Drawn Series Order 1 Column 1 Column     PAIRS      
6 18 2005 2 6 6 2 6 6 266 266   2 6 2 6 6 6 14
6 20 2005 4 3 4 3 4 4 344 434   3 4 3 4 4 4 11


Type this in Columns G, H, I:

=IF(ISBLANK($D3:$F3),"",MIN($D3:$F3)) =IF(ISBLANK($D3:$F3),"",MEDIAN($D3:$F3)) =IF(ISBLANK($D3:$F3),"",MAX($D3:$F3))
=IF(ISBLANK($D4:$F4),"",MIN($D4:$F4)) =IF(ISBLANK($D4:$F4),"",MEDIAN($D4:$F4)) =IF(ISBLANK($D4:$F4),"",MAX($D4:$F4))


If the other formulas are need (to combine 3 Col into 1 Col, I can add them too.

Good luck

Entry #17

Comments

This Blog entry currently has no comments.

Post a Comment

Please Log In

To use this feature you must be logged into your Lottery Post account.

Not a member yet?

If you don't yet have a Lottery Post account, it's simple and free to create one! Just tap the Register button and after a quick process you'll be part of our lottery community.

Register

Guest