NUMBER TO WORDS (RUPEES) ADD-IN
Click the following link to download the add-in
KrisUtilities.xla
My thanks to Yogi(SpellIndian), Damon for his UDF showing image in cell and Colo (Menu generator)
VBAs
Listing of Files and Worksheets
http://www.ozgrid.com/forum/showthread.php?t=122285
Match Values Between 2 Sheets, Copy All Corresponding Data & Sum Results
http://www.ozgrid.com/forum/showthread.php?t=133858
Compare 2 Columns For Matches
http://www.ozgrid.com/forum/showthread.php?t=132226
Consolidate Lists From Multiple Sheets Into One
http://www.ozgrid.com/forum/showthread.php?t=132325
Remove Duplicates & Create Word Documents For Each Group
http://www.ozgrid.com/forum/showthread.php?t=126677
List Files & Cell Values With Specific Sheet Names From ListBox
http://www.ozgrid.com/forum/showthread.php?t=123494
Dynamic Charts Based On Mulitple Dynamic Ranges On Different Worksheets
http://www.ozgrid.com/forum/showthread.php?t=124872
Subtotal Rows & Summary Report Of Dynamic Table
http://www.ozgrid.com/forum/showthread.php?t=123001
Delete Named Ranges Specific To 1 Worksheet
http://www.ozgrid.com/forum/showthread.php?t=120437
VBA Macro To Find Bold Cells In User Stated Range
http://www.ozgrid.com/forum/showthread.php?t=120150
Consolidate all worksheets into master workbook
http://www.mrexcel.com/forum/showthread.php?t=369609
Converting multiple rows to single rows
http://www.mrexcel.com/forum/showthread.php?t=368008
Select a filtered Range with vba
http://www.mrexcel.com/forum/showthread.php?t=368027
Write the Text file into the Excel sheet in VBA
http://www.mrexcel.com/forum/showthread.php?t=358515
Find unique values in different spreadsheets
http://www.mrexcel.com/forum/showthread.php?t=357776
Search all Spreadsheets for data
http://www.mrexcel.com/forum/showthread.php?t=357829
Macro for copying cells with specific value in them to another worksheet
http://www.mrexcel.com/forum/showthread.php?t=355538
Importing specific sheet of multiple XLS files into one
http://www.mrexcel.com/forum/showthread.php?t=353721
VBA- delete all defined names beginning "_service"
http://www.mrexcel.com/forum/showthread.php?t=352561
Delete rows with 3 or more semicolons
http://www.mrexcel.com/forum/showthread.php?t=346669
Vba countif visible cells
http://www.mrexcel.com/forum/showthread.php?t=342735
FORMULAs
Create Unique List & Summarize All Associated Values
http://www.ozgrid.com/forum/showthread.php?t=133538
Count Of Unique Numbers Meeting Criteria
http://www.ozgrid.com/forum/showthread.php?t=133012
Shift Work Time Sheet With Normal & Overtime Hours
http://www.ozgrid.com/forum/showthread.php?t=131966
Calculated Weighted & Conditional Average
http://www.ozgrid.com/forum/showthread.php?t=131716
Calculate Increase Based On Criteria
http://www.ozgrid.com/forum/showthread.php?t=130864
Display Related Information By Postcode
http://www.ozgrid.com/forum/showthread.php?t=116922
Average with Special Criteria
http://www.mrexcel.com/forum/showthread.php?t=368077
Sumif with multiple criteria
http://www.mrexcel.com/forum/showthread.php?t=365119
Populate a list box using multiple lookup
http://www.mrexcel.com/forum/showthread.php?t=353912
Transpose
http://www.mrexcel.com/forum/showthread.php?t=353065
Weighted Average Of Filtered Data
http://www.mrexcel.com/forum/showthread.php?t=349685
Largest number starting with "9" in a list
http://www.mrexcel.com/forum/showthread.php?t=347787
Keep visiting..
Kris' Spreadsheet Solutions
A collection of my excel posts at different forums
Mar 1, 2009
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
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
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
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
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
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
Subscribe to:
Posts (Atom)