-
-
Recent Posts
- Microsoft Excel for Lawyers on PLI 1/10/23
- Create a Signed pdf/a Without Scanning the Entire Document
- Amazing 3D Map Charts in Excel 2016
- September Event with PLTG – New Charts in Excel 2016
- “Very Hidden” Worksheets in Excel – Another eDiscovery Challenge
- Upcoming CLE Event for Chicago Bar Association – Advanced Excel for Litigators
- Pseudo-Scientific Notation, or The Mysterious Case of the Middle E
- Finding and Reviewing Comment Boxes in Excel Files
- Avoiding Inadvertent Productions and Other Excel Blunders: New CLE via Wolters Kluwer/myLawCLE
- Digital Detectives Podcast Interview with Excel Esquire’s Ben Kusmin – Spreadsheets as Evidence
- Scared Straight? Reviewing Excel Files in the Wake of Wells Fargo
- Excel Filters and the Duty of Technology Competence
- Upcoming CLE Event in Houston, TX (with livestream)
- Spelling Bee Fundraiser for Harlem Hospital CCHP
- Nassau County Bar Association CLE Event – March 8
Categories
Tag Archives: VLOOKUP
Tracking Duplicates with MATCH, INDEX, and COUNTIF
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 eDiscovery, eDiscovery analytics, electronic discovery, Formulas, Litigation support, metadata, VLOOKUP
|
2 Comments
Excel Esquire 