# Largest and Smallest value

• I want to find the largest and smallest value for a number
for Eg.

68734 the largest value is 87643 and the smallest value is 34678

39823 the largest value is 98332 and the smallest value is 23389

43089 the largest value is 98430 and the smallest value is 3489

• Re: Largest and Smallest value

Try next functions

## Files

Triumph without peril brings no glory: Just try

• Re: Largest and Smallest value

Certainly you noticed there was some miss: When exist twice the same digit
Here a remake

Triumph without peril brings no glory: Just try

• Re: Largest and Smallest value

With formulas *assuming 5 digit numbes...

=(LARGE(MID(A1,{1,2,3,4,5},1)+0,1)&LARGE(MID(A1,{1,2,3,4,5},1)+0,2)&LARGE(MID(A1,{1,2,3,4,5},1)+0,3)&LARGE(MID(A1,{1,2,3,4,5},1)+0,4)&LARGE(MID(A1,{1,2,3,4,5},1)+0,5))+0

and

=(SMALL(MID(A1,{1,2,3,4,5},1)+0,1)&SMALL(MID(A1,{1,2,3,4,5},1)+0,2)&SMALL(MID(A1,{1,2,3,4,5},1)+0,3)&SMALL(MID(A1,{1,2,3,4,5},1)+0,4)&SMALL(MID(A1,{1,2,3,4,5},1)+0,5))+0

copied down.

Where there is a will there are many ways. Finding one that works for you is the challenge!

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!