Dear admins dear all I ask you to help me to realize a VBA macro that searches in column A on the duplicates that have the same values on column B the objective is to replace the duplicate values by zero as given in column C.
please find in attachments the details
thank you in advance
Hi,
This is clearly a much simplified example and probably doesn't represent the size of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.
Therefore upload your real workbook (or at least a cut down copy), and manually add the results you expect to see. Clearly identify which is original data and which are the results and in a note clearly explain how you have arrived at your results.
In this example it's not at all clear why C15:C16 are different to C3:C4. The y and k values are conceptually the same but the required results are different.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
thank you dear richard for your answer I just tried to simplify the data please find in attachments my exact data
thank you
Hi YOUSSEFam,
No need for VBA. Just a simple formula. If you add more items, change the formula to include the total number of rows.
Sorry, on the previous formula I wasn't taking into account the values on column A. Here's the corrected one.
thank you dear for your help it works well but i'm worth working this with a vba macro by clicking on a button if you have a solution to do it
thank you
Here's one that works using a macro. It still uses the formulas on the cell but they are triggered by double-clicking the word MACRO on the column's title.
Thanks dear it is work
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks