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


[TABLE="width: 192"]
<colgroup><col width="64" span="2" style="width:48pt"> <col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl66, width: 64"]A[/TD]
[TD="class: xl66, width: 64"]B[/TD]
[TD="class: xl67, width: 64"]C[/TD]
[/TR]
[TR]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl67"]4[/TD]
[/TR]
[TR]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]2[/TD]
[TD="class: xl67"]4[/TD]
[/TR]
[TR]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]3[/TD]
[TD="class: xl67"]4[/TD]
[/TR]
[TR]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]4[/TD]
[TD="class: xl67"]4[/TD]
[/TR]
[TR]
[TD="class: xl66"]2[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl67"]2[/TD]
[/TR]
[TR]
[TD="class: xl66"]2[/TD]
[TD="class: xl66"]2[/TD]
[TD="class: xl67"]2[/TD]
[/TR]
[TR]
[TD="class: xl66"]3[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl67"]6[/TD]
[/TR]
[TR]
[TD="class: xl66"]3[/TD]
[TD="class: xl66"]2[/TD]
[TD="class: xl67"]6[/TD]
[/TR]
[TR]
[TD="class: xl66"]3[/TD]
[TD="class: xl66"]3[/TD]
[TD="class: xl67"]6[/TD]
[/TR]
[TR]
[TD="class: xl66"]3[/TD]
[TD="class: xl66"]4[/TD]
[TD="class: xl67"]6[/TD]
[/TR]
[TR]
[TD="class: xl66"]3[/TD]
[TD="class: xl66"]5[/TD]
[TD="class: xl67"]6[/TD]
[/TR]
[TR]
[TD="class: xl66"]3[/TD]
[TD="class: xl66"]6[/TD]
[TD="class: xl67"]6[/TD]
[/TR]
</tbody>[/TABLE]

 

[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 !