Formula To Determine Highest Number

[CONFUSED_AS_USUAL]

Hi,

Column B starts with 1 & increases by 1 everytime it encounters the same # in Column A.

For illustration purposes, Column C has been manually populated & has returned the highest (last number). This is what I am looking for.

What formula or macro can be made & used to perform this ? I have thousands of lines.

Thks

A	B	C
1	1	4
1	2	4
1	3	4
1	4	4
2	1	2
2	2	2
3	1	6
3	2	6
3	3	6
3	4	6
3	5	6
3	6	6

<colgroup><col width="64" span="2" style="width:48pt"> <col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[Dave Patton]

Try either of

Excel 2010
	A	B	C	D
1	1	1	4	4
2	1	2	4	4
3	1	3	4	4
4	1	4	4	4
5	2	1	2	2
6	2	2	2	2
7	3	1	6	6
8	3	2	6	6
9	3	3	6	6
10	3	4	6	6
11	3	5	6	6
12	3	6	6	6
13
4c

Cell Formulas
Range	Formula
D1	=AGGREGATE(14,6,$B$1:$B$12/($A$1:$A$12=A1),1)
C1	{=MAX(IF(A1:A12=A1,B1:B12))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[mopp1]

Countif would work on the example data. Something like:

=COUNTIF($A$2:$A$13,A2)

 

[CONFUSED_AS_USUAL]

Both work well & do the trick. Thanks guys !