Finding the MAX value depending on another value using VB!!

[stakar]

I have the following sources

A--B
1--00
2--00
4--00
14-00
25-00
50-00
8---10
12--10
19--10
28--10
5---02
45--02
1---28
3---28
8---28
15--28
16--28
--------------------------------------------------
I have the following result
(they are the unique values of previous column B)

C
00
02
28
10
--------------------------------------------------------
I want a D column with the max values next to each value on column C. The source will be the column A from the previous table

** I want to use vb code because is a part of a routine and i dont want cell formula to get the following result

C----D
00-- 50
02-- 45
28-- 16
10-- 28

Thanks in advance

 

[bat17]

is this in Access or Excel?

Peter

 

[stakar]

My mistake

is this in Access or Excel?

Peter

Peter, Yes its in excel
My mistake this topic being here.
I have already created a new thread to the excel question msg board!

So if u have an answer please go to the excel question msg board!

Thanks