| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
selecting 20 closest values from a list of 200 values
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!!! -- Michele |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting values... | Excel Discussion (Misc queries) | |||
| create a list of single values from multiple values | Excel Worksheet Functions | |||
| Count unique values and create list based on these values | Excel Worksheet Functions | |||
| create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
| Selecting data from a list based on entered values | Excel Discussion (Misc queries) | |||
Linear Mode
