selecting 20 closest values from a list of 200 values

  • Thread starter Thread starter michele
  • Start date Start date
M

michele

Hi there

I have a list of 200 schools in a list and each of them has a numeric value.
I want to be able to extract in groups of 20 the schools with the closest
values to every single school on the list.

Can anyone please help as it's driving me mad!!!
 
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.
 
Back
Top