How-To Geek on MSN

How to use the FORMULATEXT function in Excel

The simplest use of the FORMULATEXT function is straightforward formula auditing.
How-To Geek on MSN

How to use the LET function in Microsoft Excel

If you're tired of repeated calculations, hard-to-read formulas, and sluggish Excel worksheets, the LET function is your ...
JournalofAccountancy

How to use Excel’s UNIQUE Function

Q. Could you explain how the UNIQUE function works in Excel? A. Excel’s UNIQUE is a dynamic array function that can be an essential tool for data analysts and accountants. This function allows users ...
CCM

Repeat rows in Excel: based on cell value, VBA

Rows in an Excel worksheet can be repeated a specified number of times with user-defined functions. The Selection.insert command can be used to insert rows in an Excel sheet and there is no need to ...