Formula Help: Result if column matches criteria

[Fanwood]

My last resort! I hope someone can help.

I am working on a formula but I just can’t quite get what I need!
So far here is where I am at:
=IF(MEDIAN(G:G)>G2*0.8,"Yes","No")
What I need it to do:
IF C:C has MULTIPLE of the same Text then it will calculate the Median of the numbers in G:G, (and only the G cells if the C cells Match each other) and Return the result of “Yes” if G2*.8 is less than the total Median!
I have not been successful with the introduction of this running only if C:C has the text of BRADFORD!
Confused? Me too!

 

[Fanwood]

I may have just figured it out:

=IF(MEDIAN(IF($C$2:C7=$C$2,$G$2:$G$15))>G2*0.8,"YES","NO")

But anyone wants to chime in and correct me or has something better I am all ears!!!