Excel Help--Low Middle High

Reply #4

Fibonacci — Tue, 09 Mar 2010 14:57:54 GMT

Putz thanks again. I did run tinto some problem with the Trunc function ---when the last digit was a zero in some instances it put 10 in the cell--when it split a number--e.g. 120 to become 1 2 0 it did 1 2 10.

Anyway I did get some additional help.

Reply #3

tiggs95 — Tue, 09 Mar 2010 03:52:48 GMT

I read some of these post's and I feel so stupid..I have no idea what this means and really don't care..Picking numbers should be easy and fun and to me this isen't..Good luck anyway..

Reply #2

Fibonacci — Tue, 09 Mar 2010 02:08:51 GMT

i HAVE SEEN A NUMBER OF WAYS TO BREAK UP A THREE DIGIT NUMBER INTO COLUMNS., including MID, yours is one ofn the most efficient and leading zeros are no problem. Thanks. I am testing it out.

Reply #1

ACPutz — Mon, 08 Mar 2010 23:38:24 GMT

I'm sure there's probably and easier way, but this is what I'd do:

First break the number down to three different columns

ex:

cell A1 is your number 369

column b formula is =trunc(a1*.01) gets 3

Column c formula is =trunc((a1-(b1*100))*.1) gets 6

Column d formula is =a1-(b1*100)-(c1*10) gets 9

now that you've separated the number into 3 columns, you just need to check if it's LMH:

column e is first number

=if(b1=large(b1:d1,1), H ,if(b1=large(b1:d1,2), M... [ More ]

Excel Help--Low Middle High

Fibonacci — Mon, 08 Mar 2010 18:04:08 GMT

Need an Excel function/formula to do the following:

Take a 3 digit number in one column and report its LMH form, where L is the lowest digit, M=Median digit (in value) and H =highest digit.

It doesn't matter their position. Their value is what is important.

Eg

123 = LMH

132 = LHM

213 = MLH

231= LHM

312 = HLM

321 =HML