delete data by latest date

Hi there,

Can i i write a VBA to delete the other row data but only keep the latest date

Pls see example attached file. (to keep the yellow data rows)

Perhaps something like this might work. It adds a =MAX() formula to column D to check if the corresponding value for that row in column C matches the maximum date in column C. It then filters the data to only those that don't match the maximum date and deletes those rows.

Please Login or Register  to view this content.

BSB

AdvancedFilter

Please Login or Register  to view this content.