FORMULAS

Formatting Phone Numbers

http://www.mrexcel.com/board2/viewtopic.php?t=242707

Find Last Non-zero Value

http://www.mrexcel.com/board2/viewtopic.php?t=241778

Scroll Area Limit

http://www.mrexcel.com/board2/viewtopic.php?t=240865

Count Words with All Caps

http://www.mrexcel.com/board2/viewtopic.php?t=237290

Extract Data from String

http://www.mrexcel.com/board2/viewtopic.php?t=236351



VBAs

Filter by Background Color

http://www.mrexcel.com/board2/viewtopic.php?t=240068

Insert Rows

http://www.mrexcel.com/board2/viewtopic.php?t=238604

Transpose Data from Columns to Rows

http://www.mrexcel.com/board2/viewtopic.php?t=238917

Consolidate Data from Many Files to Single File

http://www.mrexcel.com/board2/viewtopic.php?t=235229