Merge Shift Timesheet Files Into Monthly Reports
http://www.ozgrid.com/forum/showthread.php?t=109949
Copy/Special Paste Data Within A Range To Next Empty Cell Then Mark the Copied Area
http://www.ozgrid.com/forum/showthread.php?t=103752
Calculate Weighted Median
http://www.ozgrid.com/forum/showthread.php?t=102065
Pull Each Each Digit From Number Into Single Cells
http://www.ozgrid.com/forum/showthread.php?t=101909
X Condition Lookup
http://www.ozgrid.com/forum/showthread.php?t=101800
Auto-Extending Graph/Chart Range
http://www.ozgrid.com/forum/showthread.php?t=101710
Lookup & Return All Occurences
http://www.ozgrid.com/forum/showthread.php?t=100061
Remove All But 1st Of Duplicate Rows
http://www.ozgrid.com/forum/showthread.php?t=99030
Create A New Worksheet With Specific Cell
http://www.ozgrid.com/forum/showthread.php?t=98949
Reference Cell In Macro Using Row & Column Numbers From Cell
http://www.ozgrid.com/forum/showthread.php?t=98948
Concatenate Each Row To Cells In Column
http://www.ozgrid.com/forum/showthread.php?t=98718
Colour Cells Conditionally From Formula
http://www.ozgrid.com/forum/showthread.php?t=98631
Add Missing Leading Zeros To Text
http://www.ozgrid.com/forum/showthread.php?t=98627
Filter Named Range To Userform ListBox
http://www.ozgrid.com/forum/showthread.php?t=98624
Conditional Percentage Calculation
http://www.ozgrid.com/forum/showthread.php?t=98459
Concatenating Many Columns To One
http://www.ozgrid.com/forum/showthread.php?t=98406
Quartile Function In VBA
http://www.ozgrid.com/forum/showthread.php?t=98152
Sum Range Defined By Reference Cell
http://www.ozgrid.com/forum/showthread.php?t=98147
Sum If With Multiple Criteria
http://www.ozgrid.com/forum/showthread.php?t=98140
Return All Results Corresponding To Lookup Value
http://www.ozgrid.com/forum/showthread.php?t=90243
Lookup Value Across Multiple Worksheets
http://www.ozgrid.com/forum/showthread.php?t=89679
Subtotal Filtered Column By Criteria
http://www.ozgrid.com/forum/showthread.php?t=89215
Lookup & Return Adjacent Value From Left
http://www.ozgrid.com/forum/showthread.php?t=87509
Separate Comma Delimited Cells To New Rows
http://www.ozgrid.com/forum/showthread.php?t=87390
Lookup Two Values In A List And Return Multiple Corresponding Values
http://www.ozgrid.com/forum/showthread.php?t=87166
Compare Ranges And Delete Duplicates
http://www.ozgrid.com/forum/showthread.php?t=87414
2 Criteria Lookup Without #N/A
http://www.ozgrid.com/forum/showthread.php?t=87381

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

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

Formulas...


DSUM
http://www.ozgrid.com/forum/showthread.php?t=57491
Extract Text Between Characters
http://www.ozgrid.com/forum/showthread.php?t=57416
SUMIF on Badly Laid out Data
http://www.ozgrid.com/forum/showthread.php?t=57079
Weighted Average on Filtered Data
http://www.ozgrid.com/forum/showthread.php?t=57169
Extracting Data Within Parentheses
http://www.ozgrid.com/forum/showthread.php?t=57265
Average Fixed Intervals In A Large Column Of Data http://www.ozgrid.com/forum/showthread.php?t=57266
Count Times Between 2 Specified Times
http://www.ozgrid.com/forum/showthread.php?t=57260
Count of Duplicate Entries
http://www.ozgrid.com/forum/showthread.php?t=57232
Extract Letters from Cell
http://www.mrexcel.com/board2/viewtopic.php?t=232227

Formulas....

Weeknum to Date
http://www.ozgrid.com/forum/showthread.php?t=56784
Commission Formula
http://www.ozgrid.com/forum/showthread.php?t=56891
Lookup Based on 2 Criteria
http://www.ozgrid.com/forum/showthread.php?t=56835
Lookup
http://www.ozgrid.com/forum/showthread.php?t=56827
2 Dimensional Lookup
http://www.ozgrid.com/forum/showthread.php?t=56964
Sum with Multiple Criteria
http://www.mrexcel.com/board2/viewtopic.php?t=231395
Countif with a Twist
http://www.mrexcel.com/board2/viewtopic.php?t=230845
Count Days Excluding SUnday
http://www.mrexcel.com/board2/viewtopic.php?t=230749
Lookup With Multiple Results
http://www.mrexcel.com/board2/viewtopic.php?t=231144


VBA

Change Sheet Name
http://www.ozgrid.com/forum/showthread.php?t=56781
Clear Old Pivot Items
http://www.ozgrid.com/forum/showthread.php?t=56885


List of All Excel Functions

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