title: Percentile If Statement Excel
body: <p>I have a table that has two columns and looks like the one below. My goal is to create a third column wherein the output is the percentile ranking of that line's growth rate segmented by group. That is, I want the formula to only look at the growth rates of 'Black" groups and give me the percentile ranking for the growth rate 10%.</p>
  
  <p>Can't figure this out for the life of me.</p>
  
  <pre><code>Group        Growth
  Black         10%
  Black         -1%
  Blue           0%
  Blue           5%
  Blue           5%
  Red            2%
  Green          2%
  Green          9%
  </code></pre>