Fast Tip Friday – Using Excel to Compare Two Lists


All roles within a legal team have had the need to compare two lists of bates numbers. This fast tip will share one easy way to do that using Excel.

Download Sample Files

    I am very passionate about helping legal professionals succeed. I even quit my day job to devote more time to mentoring! I want to encourage you to subscribe and join the LitSuppGuru community. I share humorous, informative, and time-sensitive emails above and beyond what appears on this site.

    Please note: I reserve the right to delete comments that are salesy, offensive or off-topic.

    • Chassidy King

      This is an awesome tip, Amy! Thank you!

    • Joanna Liller Gauthier

      Another awesome tip! Thank you. I needed this one about 2 weeks ago.

    • mgolab

      Interesting Amy. One of my team uses conditional formatting all the time whereas I prefer to use a VLOOKUP – I guess looking at your example, the conditional formatting is going to be easier and less intrusive, as with VLOOKUP, I would apply this to each corresponding cell in the next available column (C) and would be doing something like =VLOOKUP(A2,SECONDLIST,1,FALSE) which would return the corrpesponding value if there is one, or have an error message (of sorts) if there isn’t. This is a bit cumbersome and I suspect there is a lot of eye rolling when I try and force people to do it.

    • Karen Castillo

      This is great for paralegals who are not in lit support. Something we can do by ourselves without having to wait for someone to do it for us.
      Thank you.

      • Thanks. My thoughts exactly, Karen. I am a firm believer in sharing knowledge so other members of the legal team so they can be self-sufficient.