Oct 9, 2008

VBAs and Formulas posted at OzGrid

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

Keep EXCELling

No comments: