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