duplicate data in range clear contents

B

baha17

Hi All,
I have a range which V12:V18, data consistantly changes and there
might be some duplications. I would like to find the duplicated data
and just clear the duplications without deleting any row. Because
those rows effecting other formulas.Is that possible?
Thanks
\\

Baha
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting duplicated rows based on data in two columns 5
Deleting Duplicate Rows 12
How to append data from different sheet and different workbook? 2
Deleting near-duplicate records that differ only by blanks 3
Removing duplicates 7
Delete duplicate rows of data 2
Sort Range and Sum/Delete Duplicate Rows 9
Deleting/Clearing duplicate range of cells 4

Top