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!
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!