Tag Archives: Formulas

Tracking Duplicates with MATCH, INDEX, and COUNTIF

Posted on June 14, 2015 by excelesquire

Today’s post is about a powerful Excel formula for tracking duplicates in a large set of email metadata.  This routine is not for the faint of heart, but if you are managing a document production, supervising a redaction project, or creating … Continue reading →

Posted in eDiscovery, formulas, Lit Support, Privilege Logs | Tagged , , , , , , | 2 Comments

April CLE Courses Now Enrolling in NYC!

Posted on March 10, 2015 by excelesquire

Tools of the Trade: Excel Skills Every Litigator Should Know carries 3.0 New York CLE credits, and April classes are now enrolling in New York City. The first CLE course of its kind, Tools of the Trade takes you step by … Continue reading →

Posted in CLE, eDiscovery, Lit Support, Practice Management, Privilege Logs | Tagged , , , , , , , , , , , | Leave a comment

Excel Esquire CLE Courses Now Enrolling in NYC!

Posted on November 25, 2014 by excelesquire

Tools of the Trade: Excel Skills Every Litigator Should Know is now approved for 3.0 New York CLE credits, and December classes are now enrolling in New York City. The first CLE course of its kind, Tools of the Trade takes you … Continue reading →

Posted in CLE, eDiscovery, Lit Support, Practice Management, Privilege Logs | Tagged , , , , , , , , , , , | Leave a comment

5 Killer Formatting Tricks

Posted on October 14, 2014 by excelesquire

1.  Scroll-free Fonts Scrolling through all the available fonts to find the one you want can be a pain.  If you know the name of it, you can simply click into the box containing the active font and begin typing the name … Continue reading →

Posted in eDiscovery, Everybody, formulas | Tagged , , , | Leave a comment

Do I Need to Dedupe?

Posted on October 3, 2014 by excelesquire

Let’s say I’ve got a set of 6,000 emails that might—or might not—have some duplicates in it.  Before I go crazy with deduping, I’d like a quick way to figure out whether this is an issue or not.  My strategy … Continue reading →

Posted in eDiscovery | Tagged , , , | Leave a comment