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 – Version Control in Notepad++
This fast tip demonstrates how to configure Notepad++ to create backup copies in case there is a need to revert back to a previous version.
Fast Tip Friday – View Two Portions of Same PDF
This fast tip demonstrates how to view different parts of one PDF file at the same time.
Fast Tip Friday – Search and Highlight Across Multiple PDFs
This fast tip demonstrates how to use an Adobe Acrobat action to import a search term list, perform searches across multiple PDF files, and highlight all of the terms. The highlight colors available to use in the javascript are listed below: color.transparent color.black color.white color.dkGray color.gray color.ltGray color.red color.green color.blue color.cyan color.magenta color.yellow If you…
Fast Tip Friday – Delete First Page of Every PDF File in a Folder
In litigation matters, we deal with a lot of scenarios related to preparing documents for different stages of the discovery process. Many of these documents are in PDF format. There are scenarios where the lead attorney has a justified reason and may instruct a paralegal or litigation support to remove one or more pages from…
Fast Tip Friday – Uninstall Software Without Leaving Leftover Files on Your PC
This fast tip demonstrates how to use Revo Uninstaller to do a much more thorough software uninstall process. Most default uninstallers provided by the software creator will leave orphan files on your computer.
Fast Tip Friday – Bulk Edit Acrobat Redactions
Once redactions have been added to a PDF file, if someone has a different preference for how the redactions should be formatted, this fast tip demonstrates how to bulk edit the redaction properties. 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.