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.
Similar Posts
Fast Tip Friday – Identify Unsearchable PDFs Within Folders
This fast tip demonstrates how to use a free tool called Count Anything to identify which PDF files are unsearchable. Sean O’Shea shared this tip in his article entitled Where Are My Unsearchable PDFs. Source: Sean O’Shea
Fast Tip Friday – The Art of Rubber Banding
This fast tip demonstrates how to use an efficient mouse selection technique. Download Sample Files
Fast Tip Friday – Cool Visuals in Excel
This fast tip demonstrates how to easily spot patterns using more than simply adding color to a cell. Download Sample Files
Fast Tip Friday – Keep With Next and Keep Lines Together Using MS Word
This fast tip demonstrates how to apply paragraph formatting in MS Word to avoid widows and orphans, as well as controlling whether a paragraph is allowed to break across two pages.
Fast Tip Friday – Edit Bates Numbers Using Excel Substitute Formula
This fast tip demonstrates how to use the SUBSTITUTE formula in Excel. NOTE: While I realize that we could simply replace JONES_ with JONES- in this example, I wanted to keep things simple and leave it up to your imagination to see how useful this formula could be one day in your future. 🙂 Download…
Fast Tip Friday – Convert Word Form to PDF Form
This fast tip demonstrates how easy it is to convert an existing form in MS Word format to a PDF form. Download Sample Files
This is an awesome tip, Amy! Thank you!
You’re welcome, Chassidy!
Another awesome tip! Thank you. I needed this one about 2 weeks ago.
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.
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.