THIS IS THE BEST!!! thank you i finally can tidy my datas love u! :) (i tried a lot function but somehow they didn't work until i finally saw this video)
This video has helped me many times with all the duplicates I find when I do SEO keyword research! Thank you so much 😄 By the way, add the 0:00 time stamp so the chapters activate, they aren't working now. I hope it helps hehe
Thank you so very much. Your clear explanation of this instructional video has saved me so much time. May the law of action and reaction benefit you in many ways for helping complete strangers save time.
Ребята, спасибо огромное за видео! Всё супер! Преподаватель прекрасна, английский как у носителя! Всё по делу! Смотрю не отрываясь! Побольше бы такого качественного контента в сети! Но хотел бы вставить свои 5 копеек, основанные на опыте. 🤔 Тот метод, который показан в видео не совсем верен. Он работает только в том случае если у КАЖДОГО клиента свои уникальные значения и даты в столбцах G, H и I. Для того, чтобы проверить это достаточно просто скопировать значения из ячеек G6, H6, I6 в ячейки G5, H5, I5. Как только Вы их скопируете, то Ваш алгоритм найдет, что они дублируются. Но вот только дублироваться они будут не у Truva, а просто будут встречаться 1 раз у Truva, а второй раз у Softwarely. Ваш алгоритм поставит TRUE на дублирование строки 6, но она будет совпадать по полям "Users", "Payment Amount" и "Transaction Date" не со своими строками 16 и 17, а с чужой - 5-ой строкой! Прошу прощения за буквоедство, но я почитал каменты и увидел, что люди пользуются этим алгоритмом на практике... А это чревато ошибками и багами. 😉 Человек без практического опыта сразу не разберется. Сам на работе (в Экселе) делал просто и без затей: сцеплял все интересующие значения (тупо и в виде текста), а потом искал дубликаты. Дёшево и сердито! Работает безотказно даже на нескольких десятках тысячах строк! 😂 Ну и файлы у вас немного другие приложены. Не хватает строки 17. В обоих. 😉
Hey. This worked almost perfectly. I was just wondering if there was a way to make it to where the formula doesn’t count the space. I notice when I leave a space at the end of some it doesn’t highlight the duplicates. Thank you very much
Thanks! GSheets is not that smart yet, and it might miss some duplicates as in your case + if you use lower/upper case in other formulas. I suggest to use Data -> Trim whitespace on your dataset so that all extra spaces are removed at once.
Hi there! Try something like this: 1.) In conditional formatting choose the column you want to do the highlight in and set it as a range (without the headers row), for example E2:E 2.) Write a custom formula like =E2=LARGE($E$2:$E, 2) which will find and highlight the second highest value in column E. Let us know if it works for you!
The formula does not seem to work when I am trying to highlight the duplicates from only 2 columns, it does work when I have more than 2 columns though. Can you help?
Hello, could you, please, refer to the exact type of duplicate highlight you are trying to use? Also, did you try using formulas from our cheat sheet? docs.google.com/spreadsheets/d/1t81-xpIXyzq7OGBtQH6QH-lejGy2wi5CTCj6IwK3v0o/edit#gid=1078846374
Hi! Just import all of your data into the same file to compare. We have a tutorial on how you do so: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-VCcQfpUEtgI.html
Hang on...I don't think this works exactly. Isn't it checking each column independently? Meaning that if there was a match in Col A and in Col G and in Col H and in Col I, any match at all for each, then that row will be flagged as a duplicate. But each of those comparisons is not necessarily flagging the same duplicate value, right? So in your example, let's add one more entry. Maybe we can copy down Row 15 "DevDevils" into Row 18, but then change the date (Col I) to "01-10-2018" (the same date as for Row 2 "SmartTalk"). Now in your multiple comparison example Row 2 will also be highlighted whereas previously it was not, because now each of its compared cells has a match somewhere else, even though the TRUE comparisons are coming from different rows. Is that right, and is there any way to fix that issue? I'm asking because I have a similar situation with a large dataset. Each column has multiple duplicates, but what I really want is to compare row to row. Thanks!
The logic of the formulas has a problem. It is looking to see if the cell has a duplicate in any of the other rows, not rows that match all the other columns. If you take a cell in one of the duplicate columns and change to another value in another row (not on the real duplicate), it will still think the column is a duplicate because the value in that one column is a duplicate