Man your explanation is crisp to the max. Thanks for keeping it concise and to the point. I will come back to this channel in the future again for sure.
3:24 This procedure is not general! If there were two numbers in a row, then the unique string might not be unique, for example: "12" & "21" = "1221" vs "1" & "221" = "1221" ... Different default dates but same the resulting string... This can also happen when merging texts. For example, have two columns "class" and "group": "a" & "ba" = "aba" vs "ab" & "a" = "aba" ... Again different input data, but the same the resulting string. When creating a unique string, you need to insert the separators (I use the "|" pipe or "~" tilde because they are practically not used in the common text.), for example: "12" & "|" & "21" = "12|21" vs. "1" & "|" & "221" = "1|221" or "a" & "|" & "ba" = "a|ba" vs "ab" & "|" & "a" = "ab|a"
Super video. Question- I have data in 6 column and data are same in all columns (data like- B200089NT67) when I select data range and apply condition formatting duplicate then all duplicate highlights but when go to duplicate remove option and apply then I find error "No duplicate find value" so how to solve it. I had also checked all data extra space using Trim and also checked cell value is correct. Example- Column1 Colum2 Column 3 DR000257DT TR56884QR ASG489901 DR000257DT
Good explanation, tahnk you. I just have a question: Is there a conditional deduplication depending on date condition? I mean, if I need to remove duplicates with date difference less than 12 months and keep those with date difference more than 12 months.
Q. Need to remove duplicate contacts in a table and keep a single one. I.E I want to keep just “abc ltd” but list contains: abc ltd, ABC Limited, abc-ltd and abc_Ltd with same/similar addresses. Best method please?
Man your explanation is crisp to the max. Thanks for keeping it concise and to the point. I will come back to this channel in the future again for sure.
This just saved me tons of time trying to identify duplicates in my spreadsheet manually! Thanks
Very clever dude! I liked the part of concatenating and Conditional Formatting explained for row identification using a formula 👌
Superb way of explaining
God bless you
3:24
This procedure is not general!
If there were two numbers in a row, then the unique string might not be unique, for example:
"12" & "21" = "1221" vs "1" & "221" = "1221" ... Different default dates but same the resulting string...
This can also happen when merging texts. For example, have two columns "class" and "group":
"a" & "ba" = "aba" vs "ab" & "a" = "aba" ... Again different input data, but the same the resulting string.
When creating a unique string, you need to insert the separators (I use the "|" pipe or "~" tilde because they are practically not used in the common text.), for example:
"12" & "|" & "21" = "12|21" vs. "1" & "|" & "221" = "1|221"
or
"a" & "|" & "ba" = "a|ba" vs "ab" & "|" & "a" = "ab|a"
Thank you! You wrote the right things!
Also not case sensitive - watch for that if it matters
Please make a video on how to replace series of Duplicate Values with Blanks / Zeros while retaining the first occurrence or last occurrence
Thank you! This is very very useful!
Very useful tricks, helped me a lot. Thanks for sharing
YES! UA-cam is new google. This did help me in work dramativcally and my customer will enjoy less payment.
Super video.
Question- I have data in 6 column and data are same in all columns (data like- B200089NT67) when I select data range and apply condition formatting duplicate then all duplicate highlights but when go to duplicate remove option and apply then I find error "No duplicate find value" so how to solve it.
I had also checked all data extra space using Trim and also checked cell value is correct.
Example-
Column1 Colum2 Column 3
DR000257DT TR56884QR ASG489901 DR000257DT
Good explanation, tahnk you. I just have a question: Is there a conditional deduplication depending on date condition? I mean, if I need to remove duplicates with date difference less than 12 months and keep those with date difference more than 12 months.
Very well explained with easy examples..
GREAT VIDEO BRO
Q. Need to remove duplicate contacts in a table and keep a single one. I.E I want to keep just “abc ltd” but list contains: abc ltd, ABC Limited, abc-ltd and abc_Ltd with same/similar addresses. Best method please?
Sir plz provide us every UA-cam video for practice
what about the three column data? why you skipped that? cause i need to remove those kind of duplictes
Thanks Sir
very helpful,
thanks mate
There is no download links in your videod
excellent