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

FORMULAS

Sum Alphanumerics

http://www.ozgrid.com/forum/showthread.php?t=60111

Match Multiple Criteria

http://www.ozgrid.com/forum/showthread.php?t=60019

Extract Digits From Text

http://www.ozgrid.com/forum/showthread.php?t=60076

Dynamic Range Formula

http://www.ozgrid.com/forum/showthread.php?t=59919

Sum Values based on Text

http://www.ozgrid.com/forum/showthread.php?t=59855

Calculate Financial Year

http://www.ozgrid.com/forum/showthread.php?t=59901

Return Lowest Based on Text

http://www.ozgrid.com/forum/showthread.php?t=59818

Find Last Values and Sum

http://www.ozgrid.com/forum/showthread.php?t=59744

Delete Duplicates Except Last

http://www.ozgrid.com/forum/showthread.php?t=59705

Lookup on Multiple Sheets

http://www.ozgrid.com/forum/showthread.php?t=59341

Last Name, First Name

http://www.ozgrid.com/forum/showthread.php?t=59127

Bring Sum into a Single Digit

http://www.ozgrid.com/forum/showthread.php?t=58770

Transpose Columns Data into Single Column

http://www.ozgrid.com/forum/showthread.php?t=58549

Convert yyyymmdd to dd-mm-yyyy

http://www.ozgrid.com/forum/showthread.php?t=58317

Yearly Calendar

http://www.ozgrid.com/forum/showthread.php?t=58028

VBAs

Autofilter By Color

http://www.ozgrid.com/forum/showthread.php?t=59611

Move Data from 1 to Multiple Columns

http://www.ozgrid.com/forum/showthread.php?t=59106

List Sheet Names

http://www.ozgrid.com/forum/showthread.php?t=58897

Splitting Address to Multiple Cells

http://www.ozgrid.com/forum/showthread.php?t=58851

Match Data and Split

http://www.ozgrid.com/forum/showthread.php?t=58393

Dynamic Chart

http://www.ozgrid.com/forum/showthread.php?t=58206