I need to write a formula to rank rows of data with some of them having zero values that I want the rank to completely ignore. The formula needs to reference data in a different worksheet as well. Currently the formula for one row reads:
=RANK(RANK_MILES!B3,RANK_MILES!$B$3:$J$3)
There are nine vendors in this case with the values identified in columns B3 through J3. However, some of them did not submit any values. In this case, I do not want those without any values to even be considered in the ranking.
Bookmarks