hi,
I have a dataset which is populated with names address etc.
I have a column (column G in this instance), which has an alphanumeric reference......
The question i have is, is it possible to highlight the row (or even the cell) where it has duplicates in column G.
For example, if cell G123 and G124 has H6757 then this would be highlighted. If cell G125 is H6758 and is unique, then please delete.....
Many thanks
Jay
I have a dataset which is populated with names address etc.
I have a column (column G in this instance), which has an alphanumeric reference......
The question i have is, is it possible to highlight the row (or even the cell) where it has duplicates in column G.
For example, if cell G123 and G124 has H6757 then this would be highlighted. If cell G125 is H6758 and is unique, then please delete.....
Many thanks
Jay