Welcome Guest
Log In | Register )
You last visited December 7, 2016, 7:02 pm
All times shown are
Eastern Time (GMT-5:00)

Gap Theory

Topic closed. 15 replies. Last post 9 years ago by budward.

Page 2 of 2
51
PrintE-mailLink
Avatar

United States
Member #33295
February 19, 2006
699 Posts
Offline
Posted: July 29, 2007, 7:17 pm - IP Logged

Welcome to LP cosmocos,

You will probably get an answer to your Excel question if you post it in the Mathematics forum. 

 Welcome to LP cosmocos,

I agree with LottoChica. Try posting anymore questions in the Math Forum.

Here is what I would do.

Put these formulas in to separate the # 5513 into separate cells and then drag formulas down entire list of numbers.

    A      B             C                             D                               E                          F

 

5513 =INT(A1/1000)=INT((A1-(C1*1000))/100)=INT((A1-((C1*1000)+( D1*100)))/10)=INT((A1-((C1*1000)+(D1*100)+(E1*10)/1)))

 

This will give you the following

 

ABCDEF
5513          551     3

 

Then use these formulas IN cells H1,I1,J1,K1 AND drag down entire list of numbers

          H                  I                    J                    K

 

=SMALL(C1:F1,1)=SMALL(C1:F1,2)=SMALL(C1:F1,3)=SMALL(C1:F1,4)

 

This will give you the following,

 

 H  I  J  K
1355

 

Then if you want all 4 #'s back together in 1 cell, use this formula in Cell M1 and drag down list of numbers.

=CONCATENATE(H1,I1,J1,K1)

This will give you

                                                     
  M

1355

You can then highlight Columns C,D,E,F,H,I,J,K and drag them off to the right side of the sheet out of the way and drag Column M over to Column C or  move or leave the Columns as you see fit to do.

Hope this is helpful...Bud                             

Sorry, the Column letters don't quite line up in the post.

                                     

Isabel, you are going to feel very silly when this turns out to be make-believe.