Finding the top five numbers in a column that has 2 seperate ranges of numbers/data sets

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.

Moo,

That is exactly what I needed! Thank you! I know there is a way to make the field populate with a "0" until data is actually written into cells in array to keep the error from showing up. I will look farther to see if I can figure this one out. I also want to understand your formula a little better. =LARGE(Array,X) I saw that function but never knew we could do with it what you did. I understand the range, but not sure how you incorporated the rows + IFCOUNT to get the value of x. Going to look at it some more. I will finish up the code you gave me as I have 6 different weeks I need to apply this too and then I will need to also figure out how to pull a name from another cell and carry that into the number so I know "Who" Lost this much weight. will attach the sheet and follow up with that info shortly

Moo,

Thank you for the explanation. I had figured out the ROWS increment and thought that was pretty slick for copying down and it worked flawlessly as that is exactly what I did, however the countif and the > had me a little confused. I think I understand that now after your detail explanation. Again thank you!

You are correct on the Name Value. The Name value would run into issues as we commonly have duplicate losses for the same week. I just may have to do without that. I also have the issues where I need "0" or empty cell to show up in a cell that has a formula that comes up with XXXX, #NUM! or the div/0 error while it is waiting on data to be entered into a cell. This really is my first spreadsheet that I have used any functions or formulas other than autosum, so it has been a challenge. I would like to attach it here and let you look it over and give me some pointers. It's mostly finished, with the only thing left to do is find the top 10 overall losers. If you don't have time, I completely understand and appreciate greatly what you have helped me with so far.

Richard