MAX AND MIN

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I am using the MAX formula, =MAX(F2:F5783) I am trying to weed out the numbers in the top 5% in this range and then get the MAX

And the same using the MIN formula, =MIN(F2:F5783) but I want to weed out the numbers in the bottom 5%

Can this be done

Lance
 
Hi
try
=LARGE(F1:F5783,INT(5782*0.05))
and
=SMALL(F1:F5783,INT(5782*0.05))

--
Regards
Frank Kabel
Frankfurt, Germany

Lance said:
Hello, I am using the MAX formula, =MAX(F2:F5783) I am trying to weed
Click to expand...
out the numbers in the top 5% in this range and then get the MAX.
And the same using the MIN formula, =MIN(F2:F5783) but I want to weed
Click to expand...
out the numbers in the bottom 5%.
 
Back
Top