FORMULAS

Split Text

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

Convert Decimal to Feet & Inches

http://www.ozgrid.com/forum/showpost.php?p=311731&postcount=19

Find Nos. In Strings

http://www.ozgrid.com/forum/showpost.php?p=312542&postcount=3

Copy Unique Lists

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

Convert Date with Dot Separated

http://www.ozgrid.com/forum/showpost.php?p=311790&postcount=10

Take Value to Left of Max Value in a Column

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

Highlight Array Formulas in Range

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

Lookup on Multiple Sheets

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

Phone Number Splitting

http://www.ozgrid.com/forum/showpost.php?p=313634&postcount=6

Lookup Transposed Table

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

Count Numbers In Sequence

http://www.ozgrid.com/forum/showpost.php?p=316909&postcount=8

Return Value After Matching Two Variables

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

Show Nth Day of Month

http://www.ozgrid.com/forum/showpost.php?p=317454&postcount=4

Date Formula Based on Other Dates

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

http://www.ozgrid.com/forum/showpost.php?p=319433&postcount=14

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

Sort By Lookup & Ranking

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

Sum Range Using 1 Column of Named Range as Criteria

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

Adding Cell Names

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

Return Row No. of Top 3 Values

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

Counting No. of Different Instances

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



VBA

Delete Rows Meeting Criteria or Condition

http://www.ozgrid.com/forum/showpost.php?p=312532&postcount=5

Retain Leading Zero in Custom Format

http://www.ozgrid.com/forum/showpost.php?p=313474&postcount=4

Add X Rows Between Each List Item

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

List All Worksheet Names

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

Match Cells And Sum

http://www.ozgrid.com/forum/showpost.php?p=319433&postcount=14

Scanning Schedule

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

Unmerge and Fill Blank Cells

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