Link sheet name to cell value
VBA Snippets | 144 views | Tags: cell, change, link, name, sheet, value
SUMIF Multiple Conditions
Excel Formulas | 85 views | Tags: columns, conditions, multiple, sum, sumif
Show most / least used text in a range
Excel Formulas | 184 views | Tags: least, most, range, show, text, used, value
Creating a list of unique values
Excel Formulas | 426 views | Tags: array, create, formula, list, unique, values
Use SUMIF on a column defined by MATCH
Excel Formulas | 509 views | Tags: changing, columns, find, header, indirect, match, sumif, variable
Identify formulas using Conditional Formatting
Excel Tips & Tricks | 372 views | Tags: conditional, containing, format, formula, formulas, highlight
