selecting 20 closest values from a list of 200 values

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!!!
 
G

Gary''s Student

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Space at end of multi page list to accommodate new entries 1
Calculate the median value before a specified list 0
Insert name and adress from a list in a word document 1
No option to create a list in SharePoint Site 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Drop down list control value in vba 2
Mail Merge - List multiple items then page break on unique data 1
Frequency of Unique Values in a cloumn 2

Top