Filter on a helper col. Assuming scores/marks are listed within D2:D200,
place in say E2:
=IF(D2="","",IF(OR(PERCENTRANK($D$2:$D$200,D2)<=2. 5%,PERCENTRANK($D$2:$D$200,D2)=97.5%),"","Y"))
Copy E2 down to E200, then apply autofilter on E1, filter out: "Y". The
filtered rows will be your required list, viz. all except the top and bottom
2.5%.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"PClantonBailey" wrote:
The AutoFilter will not allow me to enter a non-integer (2.5) in the percent
field. I need to filter a list to show all except the top and bottom 2.5%.
I've been looking for over an hour and can't find anything that remotely
addresses this issue. Can anyone help?? (My boss is waiting 8-) )
--
PClantonBailey