Thread: selecting 20 closest values from a list of 200 values
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default selecting 20 closest values from a list of 200 values
Just sort the list by scores. This will put schools with similar scores
"close together".

Then the top 20 will be the first group, the next 20 will be the second
group, etc.
--
Gary''s Student - gsnu200799
Reply With QuoteReply With Quote