Peter Davison
Board Regular
 Joined
 Jun 4, 2020
 Messages
 183
 Office Version

 365
 Platform

 Windows
Hi,
I have a column with sales figures (column F) and a column with list of stores stocking (Column Q). Even though there is sales in Column F against a product I want it to exclude form the ranking if Column Q has a 0 or a 1 in the cell (So less than 2).
I've tried an if formula 
IF(OR(Q12<2,F12=0),"",RANK(F12,F$12:F$1000,0))
whilst that empty's the ranked cell the number ranking isn't reranked, so it's still considered in the total ranked products.
I tried to use countifs but could not work out the correct formula.
Would you be able to guide me on what I need to do please?
Thanks for your help.
I have a column with sales figures (column F) and a column with list of stores stocking (Column Q). Even though there is sales in Column F against a product I want it to exclude form the ranking if Column Q has a 0 or a 1 in the cell (So less than 2).
I've tried an if formula 
IF(OR(Q12<2,F12=0),"",RANK(F12,F$12:F$1000,0))
whilst that empty's the ranked cell the number ranking isn't reranked, so it's still considered in the total ranked products.
I tried to use countifs but could not work out the correct formula.
Would you be able to guide me on what I need to do please?
Thanks for your help.