Thanks!
works almost perfectly for what i need, just a slight adjustment, not sure if it it can be done or not but hopeful it is. using your formula jhen
=IF(AND(I2>=99.99%,I2<=103%),RANK(I2,$I$2:$I$12,0),"")
I have 1 person at 103.8% ( blank cell is returned as hoped for) however seems to still, be counting them as 1 in the ranking system because the next nearest and within target of 102.7% is ranking 2
to give more insight i have an index and match formula elsewhere in my sheet to tell me who is ranked 1st , 2nd and 3rd
Bookmarks