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 – Create Excel Pivot Table to Count Values in a Column
This fast tip demonstrates how to create a simple pivot table that will count the unique values in a column. Download Sample Files
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 – Create Folders From List in Excel
When we collect and process electronic data from a number of custodians, we usually create a folder for each custodian to store their data. This fast tip will share a shortcut for creating those folders that can save us a bunch of time. In another Fast Tip Friday, I demonstrated how to create subfolders using an Excel…
Fast Tip Friday – Format Painter in MS Word
One of my favorite features in MS Word is Format Painter. This fast tip demonstrates how to use it in two ways. Download Sample Files
Fast Tip Friday – Using a Non Breaking Space in Microsoft Word
This fast tip demonstrates a few examples where the non-breaking space in Microsoft Word comes in handy. Download Sample Files
Fast Tip Friday – Using DOS to Create File Listing
This fast tip will demonstrate how to use DOS commands to create a file listing. In another Fast Tip Friday, I demonstrated how to get a list of all files in a folder using an Excel macro. 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.