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 – Search and Redact Text Patterns Using Adobe Acrobat
This fast tip demonstrates how to search for email addresses, social security numbers, credit card numbers and dates within a PDF file and then redact any personal identifying information (PII). NOTE: The Search & Remove Text function can handle a maximum of 500 PDFs at a time. In another Fast Tip Friday tutorial, I demonstrated…
Fast Tip Friday – Find Large Emails in Gmail
This fast tip demonstrates how to use a free web tool to identify emails with large attachments if your Gmail Inbox is getting full.
Fast Tip Friday – Create ESI Report Using iConvert 2015
Typically, when ESI arrives, the attorney wants to know the volume of documents as quickly as possible. This fast tip demonstrates how to use the free iConvert 2015 software to generate an ESI report.
Fast Tip Friday – Duplicate Current Line Using Notepad++, UltraEdit and TextPad
This fast tip demonstrates how to duplicate the current line using Notepad++, UltraEdit and TextPad. Download Sample Files
Fast Tip Friday – Using Excel VLOOKUP to Compare Lists of Bates Numbers
This fast tip demonstrates how to use the VLOOKUP function in Excel to compare two lists of bates numbers and then a couple of ways to visually present the results. In a previous fast tip, I demonstrated an alternative way to use Excel to compare two lists. Download Sample Files
Fast Tip Friday – Creating a PDF Portfolio
This fast tip demonstrates the basics for creating a PDF Portfolio.
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.