Forum Discussion

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

Shiming

Copper Contributor

Jan 25, 2023

Your description is not clear. Do you want the top two locations with the highest sales for each month? If you want to have an output in H column, I assume you are only comparing the data within the same row, which doesn't give you anything.
If you want the top 2 locations of each month, simply use the conditional formatting function under Home - Style, and select Top/Botton rules - more rules. Just configure what you want.

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
  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
    Copper Contributor
    Jan 26, 2023
    Shiming thank you ill try this, and yea i noticed the average column was off.