Cracked it ! I went to http://www.cpearson.com/excel/deleting.htm and found
just what i was after, thanks anyway, ive included the macro for those of
you who may need it too.
Suppose you have two columns of data -- column A containing some names, and
column B containing some dates. If the data is grouped (not necessarily
sorted) by column A (but not necessarily by column B), this code will delete
the duplicates rows, but retaining the latest entry (by column B) of each
name in column A.
Dim RowNdx As Long
For RowNdx = Range("A1").End(xlDown).Row To 2 Step -1
If Cells(RowNdx, "A").Value = Cells(RowNdx - 1, "A").Value Then
If Cells(RowNdx, "B").Value <= Cells(RowNdx - 1, "B").Value Then
Rows(RowNdx - 1).Delete
> Hope someone can help, What I would like to do is get rid of any
> in "name1" column but get excel to check the date in the "date" column and
> remove the newest row, if this is not possible can i copy unique records
> applied to the "name1" column and take the whole row to another sheet or
> area of the same sheet, ive had it working for 1 column at a time but
> take the entire line aswell !!!!
> name1 data2 data3 data4 date
> example1 x x x 12/12/03
> example2 x x x 12/01/03
> example1 x x x 13/12/03