how to replace duplicate values with zero

**YOUSSEFam** · 01-07-2021, 03:58 PM

dear admin dear all
I ask you to help me to have a solution to automatically replace duplicate values by zero as is represented in attachments
best regardsAttachments.PNG

**Carim** · 01-07-2021, 05:03 PM

Hello,

You can use =IF(A2&B2=A1&B1,0,B2)

see your test file ...

**YOUSSEFam** · 01-07-2021, 05:46 PM

thank you for the answer the function also be counted by the first column if there is doubling in the first column and we will always have the same values it assigns zero to these doubling
thanks

how to replace duplicate values with zero

LinkBack

Thread Tools

Rate This Thread

Display

how to replace duplicate values with zero

Re: how to replace duplicate values with zero

Re: how to replace duplicate values with zero

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to replace the duplicate values in column using the unique values of another column

trying to identify duplicate values in excel tables and replace a column in the row.

[SOLVED] Find and Replace Loop + a Loop to remove Duplicate values

VBA To Replace Consecutive Duplicate Values

[SOLVED] How to lookup duplicate values between sheets and replace with value from another column

find duplicate and replace by the content of the cell to the duplicate

Seach two ranges for a duplicate values and replace

Bookmarks

Bookmarks

Posting Permissions