Compare Two Excel Worksheets & Find Duplicates Using Formula or Conditional Formatting

แชร์
ฝัง
  • เผยแพร่เมื่อ 24 พ.ย. 2024

ความคิดเห็น • 16

  • @joanlopez18
    @joanlopez18 9 หลายเดือนก่อน +2

    This was the best version I've seen on how to do this! THANK YOU!!!

  • @cheezeandcrackers
    @cheezeandcrackers 9 หลายเดือนก่อน

    been looking all over for something like this! Finally found it. THANK YOU!

  • @IvanCortinas_ES
    @IvanCortinas_ES ปีที่แล้ว

    The final part that you mention about not having to use ">0" inside COUNT.IF seems very interesting to me. Thank you Chester.

  • @ron200388
    @ron200388 หลายเดือนก่อน

    Thank you, nice and simple achieving exactly what was required.

  • @patriciabarbeau6069
    @patriciabarbeau6069 2 หลายเดือนก่อน

    Thank you, your instructions were very clear and helpful. I really appreciate the tutorial.

  • @katiehardgrave4495
    @katiehardgrave4495 2 หลายเดือนก่อน

    Thank you so much! I've been looking for hours.

  • @taraacc4733
    @taraacc4733 11 หลายเดือนก่อน

    Thank you Sir! Use me a lot and be successful.

  • @jimmykhoury2001
    @jimmykhoury2001 10 หลายเดือนก่อน

    Thanks man, I needed this !

  • @lochadith6200
    @lochadith6200 ปีที่แล้ว

    Thank you Sir! 😍😍😍❤❤❤😘😘😘

  • @digitalzombie42
    @digitalzombie42 5 หลายเดือนก่อน

    This was super helpful! Thank you!

  • @SuperKransom
    @SuperKransom ปีที่แล้ว

    Thank you so much!

  • @Juncti
    @Juncti 9 หลายเดือนก่อน

    Outside of the main topic, I had no idea about some of the shortcuts used. F4 and double clicking that bottom right corner. I need a crash course on handy excel shortcuts as I'm clearly missing out.

  • @Jojosmith342
    @Jojosmith342 ปีที่แล้ว +1

    Hi Chester, I always thumbs up for your hard work and valuable tutorials. I have a large excel sheet with more than 10,000 records which is a mixed data of Family and Singles. Ex: the family x9 people is considered as 1 job and a single individual is count as 1 also. Family x2 (Smith, Jessica & Smith, Bobby) = 1 or Family x6 people are still count as 1 task. Is there any way to create a formula to count and sum these tasks ? Thank you so much for your time and help.

  • @nagakshr
    @nagakshr ปีที่แล้ว

    Hi Chester
    Is there a way where we can convert heading and paragrah in word to Excel where heading should be Row 1 and paragraph goes to Column 1. The same has to be applied for multiple headings and paragraphs

  • @karimmimoun2482
    @karimmimoun2482 3 หลายเดือนก่อน

    Hello do you know how I can fix this problem How can I link two sheets so that I don't have a duplicate ID number when I create a new record with the user form? Thank you

  • @kevinrogala5577
    @kevinrogala5577 6 หลายเดือนก่อน +1

    I cant get anything to work, i hate excel and want to die