Hi
I would like to delete the corresponding duplicate records but keeping the first value in the column. In column B I have a list of colours that can be duplicates.
Column C has the values for each colour. For example if red appears more than once then in Column C the first value remains but the rest are deleted. Please see attached spread sheet for clarification showing expected results.
Thanks for any help you can offer
Hoss
Bookmarks