In a column of values (Trash Tonnages), which we evaluate every 4 to 6 months. We need to retrieve the 5, 6 or more middle values in order to re-evaluate our routes. Is there a method to do this in excel,
We have tried the MID() function but cant figure out how to obtain the 5 or 6 middle values (in their own cells.
The data which we are using isn't sorted. we want to avoid sorting and have excel retrieve the middle values we need.
Bookmarks