Formula - Biggest Area# in a Region

[fzhou]

Greetings,

We have 500+ stores nationwide, divided into 5 regions. Each region has several areas. Each store is assigned to a specific area (see below column A & B). I wonder if it's possible to calculate the maximum area# for each region in column C.

Store# || Reg/Area || Max A#
1 || R1A1 || 3
2 || R1A1 || 3
3 || R1A2 || 3
4 || R1A2 || 3
5 || R1A2 || 3
6 || R1A3 || 3
7 || R1A3 || 3
8 || R1A3 || 3
9 || R1A3 || 3
10 || R2A1 || 4
11 || R2A2 || 4
12 || R2A3 || 4
13 || R2A4 || 4

Any help will be appreciated.

Regards,
Frank

 

[fzhou]

I got it.

Thanks.