Want to replace data if new data found later in the list

[silverface]

Hello all,

I am struggling to work out a problem I hope you can help with.

I have an Excel spreadsheet with 10 columns of data and 1000+rows. The first x number of rows are called "Group 1" identified by the word "Group 1" in column A of each row. The next x number of rows are identified in the same way as "Group 2" and so on. The number of rows in each group can vary from 4 to 40.

Later in the list another batch of rows may also be identified as "Group 1". In fact there may be several batches of rows tagged as Group 1. Although they are tagged as Group 1, they may have a different number of rows than a previous Group 1.

What I need to do is:

Wherever a group is repeated in my list, I need to KEEP only the last occurrence of the group and delete the rows from all earlier occurrences of that group.

I have made reference to Group 1, but, similarly, any of the groups can be repeated and I will only want to retain the last occurrence on the list.

All help will be much appreciated x