delete duplicate rows - looking at specific cells

Attachment - please use.

I need to be able to delete one of each set of duplicate rows.

I'm not familiar with writing code.

Please use attachment to help with my understanding

Thanks

Originally Posted by wheelscpa

Attachment - please use.

I need to be able to delete one of each set of duplicate rows.

I'm not familiar with writing code.

Please use attachment to help with my understanding

Thanks

Hi,

You don't necessarily need code. Use a helper column, say column I, and enter the following in I2:

Please Login or Register  to view this content.

Now copy this down I2:I33 - or further if your there is more data. This will leave the word 'Keep' against the last occurrence of each duplicate value in column B. You can now sort all the data with column I as the key, and then delete all the rows marked 'Delete' which have sorted together.

HTH