formula for removing duplicate repeatative entry

 

I have worksheets named WS1 and WS2. I need to compare Column C of WS1 with Column D of WS2. If both columns contain same values then I need to highlight both the cells of “Column C of WS1” and “Column D of WS2”.

Example:

Column C of WS1    

500,000.00

260,000.00

65,000.00

30,000.00

46,104.00

530,000.00

350,000.00

55,000.00

7,000.00

2,520.16

30,000.00

210,000.00

650,000.00

10,000.00

 

Column D of WS2

2520.16

500,000.00

260,000.00

65,000.00

30,000.00

46,104.00

530,000.00

350,000.00

55,000.00

7,000.00

30,000.00

1,827,099.63

210,000.00

650,000.00

10,000.00

If values of Column C = Value of Column D then the cell containing same values in both columns is highlighted. My data is not uniform. They may have repetitive values. I am doing it manually right now and it is time-consuming as I have a lot of data to work on. Can you please suggest me.

 I am looking for exact matches for currency amounts and also I want the amounts which has been already matched to be left out. The value in each cell should be matched with only one value of another cell. Leave out the next repeated value to match with next

By: aaisha

Leave a Reply

Your email address will not be published. Required fields are marked *