Mens Excel
Time Left:
From GROUPON in Los Angeles
Time Left:
From GROUPON in Los Angeles
Time Left:
From GROUPON in Los Angeles
Time Left:
From GROUPON in Los Angeles
Time Left:
From GROUPON in Los Angeles
Time Left:
From GROUPON in Los Angeles
Time Left:
From GROUPON in Los Angeles
Time Left:
From GROUPON in Los Angeles
Time Left:
From GROUPON in Los Angeles
Time Left:
From GROUPON in Los Angeles
Mens Excel
Complicated Excel Formula?
The idea is to return the most used value in column B only when Column A = accessories.
So Example:
A———————– B
1 Accessories Trash
2 Accessories Trash
3 Accessories Trash
4 Mens Fitting Room
5 Mens Fitting Room
6 Mens Fitting Room
7 Accessories Fixture
8 Womens Fitting room
The idea would be the return of TRASH since TRASH is the most common value in column B when Column A = Accessories.
Does this make sense?
In C1 enter =IF(A1=$F$1,COUNTIF(B:B,B1),0) Copy down list.
In E1 enter =INDEX(B:B,MATCH(MAX(C:C),C:C,0))
In F1 enter Accessories ( or other value you wish to find the most used value of)