I have a list of Customers in Column A , their Revenues in Column B, Month Over MonthGrowth in Column C. Is there a way in Column D to Rank the Customers in terms of their Month over Month Growth, but exclude bottom 10 % in terms of Revenues from the ranking?<o></o>
I know that I can rank with a formula” =COUNTIF(C:C,">="&C1)”And I can get a TRUE/FALSE answer whether the Customers is top 90% with “D1=>PERCENTILE(B:B,0.9) , but I don’tknow how to rank Month over Month growth excluding bottom 10% Revenues? Thankyou!<o></o>
I know that I can rank with a formula” =COUNTIF(C:C,">="&C1)”And I can get a TRUE/FALSE answer whether the Customers is top 90% with “D1=>PERCENTILE(B:B,0.9) , but I don’tknow how to rank Month over Month growth excluding bottom 10% Revenues? Thankyou!<o></o>