Excel-Tips

The INDEX MATCH[1] Formula is the combination of two functions in Excel: INDEX[2] and MATCH[3]. =INDEX() returns the value of a cell in a table based on the column and row number. =MATCH() returns the position of a cell in a row or column.

Viewing the Formula in Another Cell in Excel

FormulaText function will show the formula, while the original value stays put, making it easier to understand the formula and its working, while having the value displayed directly.

=FORMULATEXT(cell_reference to a cell containing a formula)

How to convert date to text month?

Use the COUNTBLANK function, one of the Statistical functions, to count the number of empty cells in a range of cells.