In the range C3:C300 , I have a list of numbers resultant from formulas.
I'd like in D3:D300 to rank the top 5 numbers in C by 1st , 2nd , 3rd, 4th and 5th. Other numbers in C outside this ranking , or at zero can show blank in D.
Can someone suggest a formula for column D to satisfy this?
Grateful for any advice.
![]()
Bookmarks