Welcome Guest
( Log In | Register )
The time is now 1:39 am
You last visited January 20, 2017, 12:40 am
All times shown are
Eastern Time (GMT-5:00)

Excel Formula - Boxed Pairs

Published:

This is a handy formla for creating a boxed pair

For example:

In cell P21 you have the pair 76 and you wanted the boxed pair 67 in cell Q21 below is the formula.

 

=CONCATENATE((MIN(LEFT(P21),RIGHT(P21))),,(MAX(LEFT(P21),RIGHT(P21))))

Entry #120

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.