Welcome Guest
( Log In | Register )
The time is now 8:23 am
You last visited January 16, 2017, 7:51 am
All times shown are
Eastern Time (GMT-5:00)

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.

You must be a Lottery Post member to post comments to a Blog.

Register for a FREE membership, or if you're already a member please Log In.