Highlight highest value in a range based on change in a different range

[mck02e]

Hi,

I hope I am describing what I need correctly. I have a list of store numbers in column A. In column B, I have various employee pay rates that correspond to each store. Is there a way I can tell excel that I want to find the highest pay rate at each change in store number? In other words, highlight the highest pay rate for each store ? To put it into perspective, I have about 530 stores and 2700 employees that I am working with.

I am also open to options other than highlighting..perhaps if I have to use some sort of formula that will have to pull the data I want into another column, that will work as well.

Store	Pay rate
100	10.00
100	10.50
100	7.25
200	8.00
200	8.25
300	10.00
300	10.00
300	10.25
300	11.00
300	7.25

<tbody>
</tbody>

 

[MARZIOTULLIO]

	A​	B​	C​	E​	F​
1​	Store	Pay rate		Store	max Pay rate
2​	100​	10​		100​	10.5​
3​	100​	10.5​		200​	8.25​
4​	100​	7.25​		300​	11​
5​	200​	8​
6​	200​	8.25​
7​	300​	10​
8​	300​	10​
9​	300​	10.25​
10​	300​	11​
11​	300​	7.25​

<tbody>
</tbody>

f2=MAX(IF($A$2:$A$11=E2,$B$2:$B$11)) control +shift +enter copy down

 

[mck02e]

Aha! Worked like a charm. That was super easy...just couldn't seem to focus; I knew it could be done. Thank You!