View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bala[_2_] Bala[_2_] is offline
external usenet poster
 
Posts: 6
Default Get Top X,Middle Y,Bottom Z percent Records

Hi,
can anyone has answer for the following scenario.

How will I get Top 20(say for example 20), middle 20, bottom 20
records in an excel sheet supposing there are 60 records.
Any idea for generalized one? (i.e) If I specify top x % records then
it should return the top x % records and as the same way
if I specify bottom y % then it should return the bottom y % of the
total records.

Thanks in Advance,
Bala