Excel Is Fun

Excel Magic Trick 1098

DESCRIPTION See how to compare two e-mail lists where one list has extra semi-colons: (00:28) Find and Replace feature to remove semi-colons (Ctrl + H). (01:32) Is in List: MATCH and ISNUMBER functions. (03:20) Is [Read More >>>]

Excel Is Fun

Excel Magic Trick 1091

DESCRIPTION See how to count the number of items entered into the row that corresponds to the first occurrence of each Group Number using: 1) INDEX, MATCH and COUNTA functions to “lookup a row” for [Read More >>>]

Excel Is Fun

Excel Magic Trick 1086

DESCRIPTION 3 Way Lookup Formula & Conditional Formatting, Date Criteria Mismatch & Merged Cell Trouble See how to:  (00:11 min) Create formula to lookup a value from a table with three criteria: INDEX and MATCH and [Read More >>>]