I roam around watching videos for hours and you just helped in seconds❤ Awesome tip, grateful🙌🏽
@midsommar997 Жыл бұрын
Finally! The answer of list comparison with conditional formatting. I never liked an extra column full of Yes and No 🙅♀️
@rschaefe12 жыл бұрын
Great little tip - short and sweet!! Thanks Andy, I don’t use that trick but it will be very helpful and a good reminder.
@lisanishimoto110 Жыл бұрын
Thank you this is exactly what I was looking for! 😁
@bennhenderson78986 ай бұрын
thanks so much, this helped me out so much at work today!
@amulyaammu881810 ай бұрын
Just what I was looking for 😭😭. Thankyou
@butterfly.2020 Жыл бұрын
Thank you sooooo much for this 🙏🏾✨️
@muthukrishnank7492 күн бұрын
Thank you so much🎉
@slipperr52512 ай бұрын
Thank you so much🥹🙏
@amritsingh7574 Жыл бұрын
This is really helpful...thanks
@j3ah0o Жыл бұрын
Thanks! I spent far too much time trying to get a conditional by formula to work. 3 steps and I had it done...
@AndyPark365 Жыл бұрын
Glad you found this tip helpful!
@isongeojoseph3830 Жыл бұрын
Me too❤
@vasanthakumari33879 ай бұрын
Very Simple.. Thanku😊
@pushyarareddy74846 ай бұрын
Very useful, thanks!
@ripansarkar47886 ай бұрын
Excellent❤
@anks181190 Жыл бұрын
Great tip. How about when these lists are in two different sheets?
@akashjain Жыл бұрын
Same here
@omikunletaiwo6375 Жыл бұрын
Hold control button. Select the first list the go to the next sheet (keep holding on the control button) then select the second list. Select conditional formatting then select duplicate or unique values
@ChandiniRG11 ай бұрын
Very helpful thank you so much
@cbgh4637Ай бұрын
What if the list are a set of numbers like SKU numbers?
@clairepunzalan42228 күн бұрын
How do I delete the highlighted/duplicate values? Kindly help me please
@poojas7503 Жыл бұрын
Thanks a lot... Could you please tell how to remove duplicates from multiple columns in excel.. I have a huge list to remove duplicates from. But the list is beyond the excel row limit. Do I have pasted my records in 4-5 columns. I want to remove duplicates from those. Could you please help giving a solution.
@j3ah0o Жыл бұрын
It's under the DATA section, next to "text to columns". There's a button specifically for it.
@totalhyper727 ай бұрын
Great
@justdoc93 Жыл бұрын
대박~ 와. 이런게 있는줄 몰랐어요.
@allaboutferrets Жыл бұрын
Thank you!
@jimmyjims3245 Жыл бұрын
How do you unhighlight them?
@Kuruli.Bharat8 ай бұрын
Thank you 👍
@manthankohad1837 Жыл бұрын
Thanks for saving me😅
@yogeshprajapati2952 Жыл бұрын
filter function not working Only filterxml working
@MadMike789 ай бұрын
How can you copy just the highlighted ones?
@janer8056 ай бұрын
Filter by color. Highlight the column, Click on sort & filter, then filter by color (the highlighted color will be there automatically for you to select) then select all and copy.