• 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
 
write the formula for column K2, because the information is taken from other columns. Thanks for listening. Office 2024
 
... 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