Max date from loop

[Forestq]

Hi,

In column A I have "reported period" and in column C I have "account name". Each month I have new series data contains reported period and account name, and now I want to select MAX date for looking account.

Example:

Reported Period (column A)	Account Name (column C)
12/09/2014	Audi
12/09/2014	BMW
12/09/2014	VW
09/10/2014	Audi
09/10/2014	BMW
09/10/2014	FORD

<tbody>
</tbody>

Max date for Audi, BWM is 09/10/2014, but for VW is 12/09/2014.

RP_SET = "01/01/2010"

 For g = 2 To rowdata_lr
        If wsRD_M.Range("C" & g).Value = looking_cust Then
                
                RP = wsRD_M.Range("A" & g).Value
                                
                     If RP_SET < RP Then
                        
                        NEW_RP = RP
        
                    End If
        
        End If
    Next g

but something is wrong....

 

[onlyadrafter]

Hello,

could you provide all of the VB code.

Isn't the Max date for Audi & BMW 12/09/2014?

 

[Forestq]

that my all code

date has format: dd/mm/yyyy