I have a column that has totals and losses in the same column. I need to find the top 5 losses in the column which are between .5 and 75. The totals are all over 90 in the same column. I also need to pull a name to go with the number that is in different row and column and then put the results in a column that spans 5 rows down. I know I can use the max function to get the top/highest number, but not sure how to get the next 4 and then make them appear in a column starting on for ex: row 23 and the next 4 appear down 24, 25, 26, 27. I am extremely new to excel fucntions and have exhausted my searches of forums trying to find exactly what I need. Any help is appreciated.
Bookmarks