Hi all,
I was wondering is there a way of deleting rows where there is a duplicate.
i.e.
1 a a a
2 a a a
3 b b b
4 b b b
I would like it to delete rows 2 and 4 leaving just 1 row in that has the data in.
Thanks
Martin
I was wondering is there a way of deleting rows where there is a duplicate.
i.e.
1 a a a
2 a a a
3 b b b
4 b b b
I would like it to delete rows 2 and 4 leaving just 1 row in that has the data in.
Thanks
Martin