Rank Sales Values If it is a retail store

[ajw5173]

Hi All,

I am trying to rank stores based on their sales. I have my stores in column C and their sales in D. The problem is I have their distrct totals also in column D and their District names also in column C.

Can someone provide a formula that will rank sales from a column unless the name in column C is a specific name like "Web" or "Flagship"?

Thanks!

 

[iliace]

You can use a helper column.

In my example, I have Stores in C4:C11, and Sales in D4:D11.

I created a helper column E, with this formula: =IF(AND(ISERROR(FIND("Web", C4)), ISERROR(FIND("Flagship", C4))), D4)

In column F, I have my new Rank formula: =IFERROR(RANK(E4, $E$4:$E$11), "")

The result is, you have blanks in any row where store name contains "Web" or "Flagship", and the ranks if it does not.