Category Archives: formulas

Find & Redact Social Security Numbers in Excel Files

A raft of state and federal laws require the redaction of social security numbers from publicly available documents.  For attorneys, this usually means that documents produced in litigation must be scrubbed of SSN’s.   In my experience, many parties resort to … Continue reading

Posted in CLE, eDiscovery, Everybody, formulas, Lit Support, Native File Review | Tagged , , , , , , , | Leave a comment

Create Automated Hyperlinks to NY Court Records in SCROLL

If you litigate in the New York courts, then you’re familiar with SCROLL–the court-maintained web site where you can enter a case’s index number and pull up the docket for that case.  Now wouldn’t it be nice if you could … Continue reading

Posted in eDiscovery, Everybody, formulas, Lit Support, Practice Management | Tagged , , , , | 2 Comments

Pain-Free Way to Add Up Billable Hours

Juggling multiple matters means adding up many time increments to come up with the correct number of billable hours for each matter, each day.  Here’s an easy way to add up all the time on a given matter automatically. Set … Continue reading

Posted in Everybody, formulas, Practice Management | Tagged , | 3 Comments

Use Excel to Count the Number of Emails in Each Email Chain

Courts and litigants have long struggled with the question of how to describe email chains on a privilege log.  Should you log only the most recent email, or log every email in the chain–or something in between?  New York has … Continue reading

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

5 Killer Formatting Tricks

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