Lookup/index/match function

[Mparekh]

I see lot of excel guru's in here and am sure someone would be able t
help me. Here's how my data looks like:

Column A Column B
1 2%
2 2.1%
3 3%
1 3.5%
1 3.6%
1 3.7%
2 4% so on and so forth...

What I need to do is, for all the 1's in column A, replace value i
correspoding cell in column B with highest value. So for all 1's i
column A, Column B should have 3.7%. Same way for all 2's in column A
column B should change to 4%...How do I do that with a formula and no
macros? Struggled a lot with index and match but still not gettin
anywhere.

Thank you all in advance.

Parek

 

[NH]

AGAINST EACH VALUE TYPE THIS IN COL C AND ARRAY ENTER THEM
(CTRL+SHIFT+ENTER)
=MAX(IF($A$2:$A$8=A2,$B$2:$B$8))