• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Duplicate problem in excel

sorry , i dont know what you need - begin finish, image 2 ?????

what version of excel are you using

other members may know and answer
 
... hmm?
You've added D-column in E-column formula ...
... then E-column will be different than L-column which has written manually
Do You have an idea that those should be same?
Is that Your 'like'?
 
vletm said:
... hmm?
You've added D-column in E-column formula ...
... then E-column will be different than L-column which has written manually
Do You have an idea that those should be same?
Is that Your 'like'?
Click to expand...
column D is the product heat code column and the symbol when the four columns A, B, C, D overlap, just take the first information and remove the duplicates,,, get the symbol of the connection of the three columns A, B, C. Because I want to use a formula, I have to create an extra column, which is what I don't want.
 
Did You answer to my question ... Do You have an idea that those should be same?
... E- and L- columns.
What is the first information?
Even E-column has now only unique data.
With the last sentence - You wrote which is what I don't want.
Instead that - You should able to explain and show - what do You want?
 
vletm said:
Did You answer to my question ... Do You have an idea that those should be same?
... E- and L- columns.
the first information?
Even E-column has now only unique data.
With the last sentence - You wrote which is what I don't want.
Instead that - You should able to explain and show - what do You want?
Click to expand...
I do not use native English, I ask https://translate.google.com/
the semantic part may not convey the meaning I explain, I hope you understand. The formula is correct with 3 columns ABC, Add column D
the result is similar to image 2.
 
Your explain is something like
(A & B & C) & | & D should be same as A & B & C
... for me those are different.
I can see same difference in image too.
 
You must log in or register to reply here.
Back
Top