Jul 12, 2007

General

Userid And Password To Access Worksheets
http://www.ozgrid.com/forum/showthread.php?t=73749


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


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


List of All Excel Functions
http://www.mrexcel.com/board2/viewtopic.php?t=230815

VBAs

Merge, Sort & Eliminate Close Duplicates
http://www.ozgrid.com/forum/showthread.php?t=73401

Match Data from 2 Sheets and Results in 3rd Sheet
http://www.ozgrid.com/forum/showthread.php?t=72681

Remove zeros only
http://www.ozgrid.com/forum/showthread.php?t=72623

Check and Append data in Cells
http://www.ozgrid.com/forum/showthread.php?t=72270

Countif with SpecialCells
http://www.ozgrid.com/forum/showthread.php?t=71997

Count Most Frequent Values in a Cell
http://www.mrexcel.com/board2/viewtopic.php?t=269509

Add Unique Items in Combobox
http://www.mrexcel.com/board2/viewtopic.php?t=271120

Distribute 35000 Rows equally into 6 different excel sheets
http://www.mrexcel.com/board2/viewtopic.php?t=254762

Create Unique Words
http://www.mrexcel.com/board2/viewtopic.php?t=249267

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

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

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

Match Data from 2 Sheets and Results in 3rd Sheet
http://www.ozgrid.com/forum/showthread.php?t=72681

Remove zeros only
http://www.ozgrid.com/forum/showthread.php?t=72623

Check and Append data in Cells
http://www.ozgrid.com/forum/showthread.php?t=72270

Countif with SpecialCells
http://www.ozgrid.com/forum/showthread.php?t=71997

Count Most Frequent Values in a Cell
http://www.mrexcel.com/board2/viewtopic.php?t=269509

Add Unique Items in Combobox
http://www.mrexcel.com/board2/viewtopic.php?t=271120

Distribute 35000 Rows equally into 6 different excel sheets
http://www.mrexcel.com/board2/viewtopic.php?t=254762

Create Unique Words
http://www.mrexcel.com/board2/viewtopic.php?t=249267

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

Formulas

Formulas..

Count Occurence of 2 variables
http://www.ozgrid.com/forum/showthread.php?t=72647

Lookup Minimun with Criteria
http://www.ozgrid.com/forum/showthread.php?t=72481

Convert Date to Quarter
http://www.ozgrid.com/forum/showthread.php?t=72428

Count Unique Items in Autofilter
http://www.ozgrid.com/forum/showthread.php?t=70131

Split Text over x characters
http://www.ozgrid.com/forum/showthread.php?t=71850

Dual Headings Match
http://www.ozgrid.com/forum/showthread.php?t=71471

Convert Letter Grade to Numbers
http://www.ozgrid.com/forum/showthread.php?t=71469

Split Varying Lenght of Text
http://www.mrexcel.com/board2/viewtopic.php?t=281367

Lookup with Multiple results
http://www.ozgrid.com/forum/showthread.php?t=70050

Roundup to Nearest x
http://www.ozgrid.com/forum/showthread.php?t=70107

Index Match Function For Two Same Values
http://www.ozgrid.com/forum/showthread.php?t=70267

Extracting Subtotal Results
http://www.ozgrid.com/forum/showthread.php?t=69791

Vlookup Cell Containing Symbol & Text
http://www.ozgrid.com/forum/showthread.php?t=69610

Find first positive value
http://www.mrexcel.com/board2/viewtopic.php?t=275007

Last Text & Numeric Entry in Dynamic Range
http://www.ozgrid.com/forum/showthread.php?t=68869

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

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

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

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

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

Count Occurence of 2 variables
http://www.ozgrid.com/forum/showthread.php?t=72647

Lookup Minimun with Criteria
http://www.ozgrid.com/forum/showthread.php?t=72481

Convert Date to Quarter
http://www.ozgrid.com/forum/showthread.php?t=72428

Count Unique Items in Autofilter
http://www.ozgrid.com/forum/showthread.php?t=70131

Split Text over x characters
http://www.ozgrid.com/forum/showthread.php?t=71850

Dual Headings Match
http://www.ozgrid.com/forum/showthread.php?t=71471

Convert Letter Grade to Numbers
http://www.ozgrid.com/forum/showthread.php?t=71469

Split Varying Lenght of Text
http://www.mrexcel.com/board2/viewtopic.php?t=281367

Lookup with Multiple results
http://www.ozgrid.com/forum/showthread.php?t=70050

Roundup to Nearest x
http://www.ozgrid.com/forum/showthread.php?t=70107

Index Match Function For Two Same Values
http://www.ozgrid.com/forum/showthread.php?t=70267

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

Extracting Subtotal Results
http://www.ozgrid.com/forum/showthread.php?t=69791

Vlookup Cell Containing Symbol & Text
http://www.ozgrid.com/forum/showthread.php?t=69610

Find first positive value
http://www.mrexcel.com/board2/viewtopic.php?t=275007

Last Text & Numeric Entry in Dynamic Range
http://www.ozgrid.com/forum/showthread.php?t=68869