Excel Tip: Identify Duplicates In Data Lists

Today I was working with two reasonably long lists of data and I needed to quickly see whether data contained in List1 was also contained in List2. Excel® can help with this. Assume two simple lists of data, below: A B C 1 List 1 List 2 2 Jeff Mike 3 Larry Sam 4 Jill […]

Excel Tip: How to Create Simple Macros

Ever find yourself working with an Excel® spreadsheet, continually repeating the same set of keystrokes over and over again? For instance, you might be analyzing a few hundred rows of client data and deleting rows that, for whatever reason, you don’t need. Repeatedly you use the drop down menu to plod through the sequence: “Edit […]