Forum Discussion

Tiller610's avatar
Tiller610
Copper Contributor
Jan 25, 2023

need a little help

So im pretty new and quite stumped. so here in the Top Sales column I need and IF function to determine which two locations had the highest sales. this seems like it should be fairly easy but ...
excel
Tiller610's avatar
Tiller610
Copper Contributor
Jan 25, 2023
sorry brother , my instructions are to use an IF function in column H that will output "Top" in the corresponding h row for the 2 highest earning locations (south park , West spring mall). but i will give the conditional formatting a look. thanks
Shiming's avatar
Shiming
Copper Contributor
Jan 25, 2023
Oh I get what you mean now. Here is the formula
=IF(OR(LARGE($G$7:$G$13,1)=E2,LARGE($G$7:$G$13,2)=E2),"Top","")

BTW the average column doesn't look alright.
  • Tiller610's avatar
    Tiller610
    Copper Contributor
    Jan 26, 2023

    Shiming thank you ill try this, and yea i noticed the average column was off.