tag:blogger.com,1999:blog-50114650730790017652024-03-13T17:20:09.879+05:30Kris' Spreadsheet SolutionsA collection of my excel posts at different forumsKrishnakumarhttp://www.blogger.com/profile/10413219034695961726noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-5011465073079001765.post-39491322118945043112009-03-01T12:08:00.011+05:302009-07-26T21:04:37.506+05:30<span style="color: rgb(153, 0, 0); font-weight: bold;font-size:130%;" >NUMBER TO WORDS (RUPEES) ADD-IN</span><br /><br />Click the following link to download the add-in<br /><br /><a linkindex="19" href="http://www.savefile.com/files/2163931">KrisUtilities.xla</a><br /><br />My thanks to Yogi(SpellIndian), Damon for his UDF showing image in cell and Colo (Menu generator)<br /><br /><span style="color: rgb(51, 51, 255); font-weight: bold;">VBAs</span><br /><br /><br />Listing of Files and Worksheets<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=122285">http://www.ozgrid.com/forum/showthread.php?t=122285</a><br /><br />Match Values Between 2 Sheets, Copy All Corresponding Data & Sum Results<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=133858">http://www.ozgrid.com/forum/showthread.php?t=133858<br /></a><br />Compare 2 Columns For Matches<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=132226">http://www.ozgrid.com/forum/showthread.php?t=132226</a><br /><br />Consolidate Lists From Multiple Sheets Into One<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=132325">http://www.ozgrid.com/forum/showthread.php?t=132325</a><br /><br />Remove Duplicates & Create Word Documents For Each Group<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=126677">http://www.ozgrid.com/forum/showthread.php?t=126677</a><br /><br />List Files & Cell Values With Specific Sheet Names From ListBox<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=123494http://www.ozgrid.com/forum/showthread.php?t=123494">http://www.ozgrid.com/forum/showthread.php?t=123494</a><br /><br />Dynamic Charts Based On Mulitple Dynamic Ranges On Different Worksheets<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=124872">http://www.ozgrid.com/forum/showthread.php?t=124872</a><br /><br />Subtotal Rows & Summary Report Of Dynamic Table<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=123001">http://www.ozgrid.com/forum/showthread.php?t=123001</a><br /><br />Delete Named Ranges Specific To 1 Worksheet<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=120437">http://www.ozgrid.com/forum/showthread.php?t=120437</a><br /><br />VBA Macro To Find Bold Cells In User Stated Range<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=120150">http://www.ozgrid.com/forum/showthread.php?t=120150</a><br /><br />Consolidate all worksheets into master workbook<br /><br /><a href="http://www.mrexcel.com/forum/showthread.php?t=369609">http://www.mrexcel.com/forum/showthread.php?t=369609</a><br /><br />Converting multiple rows to single rows<br /><br /><a href="http://www.mrexcel.com/forum/showthread.php?t=368008">http://www.mrexcel.com/forum/showthread.php?t=368008</a><br /><br />Select a filtered Range with vba<br /><br /><a href="http://www.mrexcel.com/forum/showthread.php?t=368027">http://www.mrexcel.com/forum/showthread.php?t=368027</a><br /><br />Write the Text file into the Excel sheet in VBA<br /><br /><a href="http://www.mrexcel.com/forum/showthread.php?t=358515">http://www.mrexcel.com/forum/showthread.php?t=358515</a><br /><br />Find unique values in different spreadsheets<br /><br /><a href="http://www.mrexcel.com/forum/showthread.php?t=357776">http://www.mrexcel.com/forum/showthread.php?t=357776</a><br /><br />Search all Spreadsheets for data<br /><br /><a href="http://www.mrexcel.com/forum/showthread.php?t=357829">http://www.mrexcel.com/forum/showthread.php?t=357829</a><br /><br />Macro for copying cells with specific value in them to another worksheet<br /><br /><a href="http://www.mrexcel.com/forum/showthread.php?t=355538">http://www.mrexcel.com/forum/showthread.php?t=355538</a><br /><br />Importing specific sheet of multiple XLS files into one<br /><br /><a href="http://www.mrexcel.com/forum/showthread.php?t=353721">http://www.mrexcel.com/forum/showthread.php?t=353721</a><br /><br />VBA- delete all defined names beginning "_service"<br /><br /><a href="http://www.mrexcel.com/forum/showthread.php?t=352561">http://www.mrexcel.com/forum/showthread.php?t=352561</a><br /><br />Delete rows with 3 or more semicolons<br /><br /><a href="http://www.mrexcel.com/forum/showthread.php?t=346669">http://www.mrexcel.com/forum/showthread.php?t=346669</a><br /><br />Vba countif visible cells<br /><br /><a href="http://www.mrexcel.com/forum/showthread.php?t=342735">http://www.mrexcel.com/forum/showthread.php?t=342735</a><br /><br /><br /><br /><span style="font-weight: bold; color: rgb(51, 51, 255);">FORMULAs</span><br /><br />Create Unique List & Summarize All Associated Values<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=133538">http://www.ozgrid.com/forum/showthread.php?t=133538</a><br /><br />Count Of Unique Numbers Meeting Criteria<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=133012">http://www.ozgrid.com/forum/showthread.php?t=133012</a><br /><br />Shift Work Time Sheet With Normal & Overtime Hours<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=131966">http://www.ozgrid.com/forum/showthread.php?t=131966</a><br /><br />Calculated Weighted & Conditional Average<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=131716">http://www.ozgrid.com/forum/showthread.php?t=131716</a><br /><br />Calculate Increase Based On Criteria<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=130864">http://www.ozgrid.com/forum/showthread.php?t=130864</a><br /><br />Display Related Information By Postcode<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=116922">http://www.ozgrid.com/forum/showthread.php?t=116922</a><br /><br />Average with Special Criteria<br /><br /><a href="http://www.mrexcel.com/forum/showthread.php?t=368077">http://www.mrexcel.com/forum/showthread.php?t=368077</a><br /><br />Sumif with multiple criteria<br /><br /><a href="http://www.mrexcel.com/forum/showthread.php?t=365119">http://www.mrexcel.com/forum/showthread.php?t=365119</a><br /><br />Populate a list box using multiple lookup<br /><br /><a href="http://www.mrexcel.com/forum/showthread.php?t=353912">http://www.mrexcel.com/forum/showthread.php?t=353912</a><br /><br />Transpose<br /><br /><a href="http://www.mrexcel.com/forum/showthread.php?t=353065">http://www.mrexcel.com/forum/showthread.php?t=353065</a><br /><br />Weighted Average Of Filtered Data<br /><br /><a href="http://www.mrexcel.com/forum/showthread.php?t=349685">http://www.mrexcel.com/forum/showthread.php?t=349685</a><br /><br />Largest number starting with "9" in a list<br /><br /><a href="http://www.mrexcel.com/forum/showthread.php?t=347787">http://www.mrexcel.com/forum/showthread.php?t=347787</a><br /><br /><br />Keep visiting..Krishnakumarhttp://www.blogger.com/profile/10413219034695961726noreply@blogger.com2tag:blogger.com,1999:blog-5011465073079001765.post-45525143709633747572008-10-09T20:47:00.003+05:302008-10-10T21:51:45.683+05:30VBAs and Formulas posted at OzGridMerge Shift Timesheet Files Into Monthly Reports<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=109949">http://www.ozgrid.com/forum/showthread.php?t=109949</a><br /><br />Copy/Special Paste Data Within A Range To Next Empty Cell Then Mark the Copied Area<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=103752">http://www.ozgrid.com/forum/showthread.php?t=103752</a><br /><br />Calculate Weighted Median<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=102065">http://www.ozgrid.com/forum/showthread.php?t=102065</a><br /><br />Pull Each Each Digit From Number Into Single Cells<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=101909">http://www.ozgrid.com/forum/showthread.php?t=101909</a><br /><br />X Condition Lookup<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=101800">http://www.ozgrid.com/forum/showthread.php?t=101800</a><br /><br />Auto-Extending Graph/Chart Range<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=101710">http://www.ozgrid.com/forum/showthread.php?t=101710</a><br /><br />Lookup & Return All Occurences<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=100061">http://www.ozgrid.com/forum/showthread.php?t=100061</a><br /><br />Remove All But 1st Of Duplicate Rows<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=99030">http://www.ozgrid.com/forum/showthread.php?t=99030</a><br /><br />Create A New Worksheet With Specific Cell<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=98949">http://www.ozgrid.com/forum/showthread.php?t=98949</a><br /><br />Reference Cell In Macro Using Row & Column Numbers From Cell<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=98948">http://www.ozgrid.com/forum/showthread.php?t=98948</a><br /><br />Concatenate Each Row To Cells In Column<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=98718">http://www.ozgrid.com/forum/showthread.php?t=98718</a><br /><br />Colour Cells Conditionally From Formula<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=98631">http://www.ozgrid.com/forum/showthread.php?t=98631</a><br /><br />Add Missing Leading Zeros To Text<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=98627">http://www.ozgrid.com/forum/showthread.php?t=98627</a><br /><br />Filter Named Range To Userform ListBox<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=98624">http://www.ozgrid.com/forum/showthread.php?t=98624</a><br /><br />Conditional Percentage Calculation<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=98459">http://www.ozgrid.com/forum/showthread.php?t=98459</a><br /><br />Concatenating Many Columns To One<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=98406">http://www.ozgrid.com/forum/showthread.php?t=98406</a><br /><br />Quartile Function In VBA<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=98152">http://www.ozgrid.com/forum/showthread.php?t=98152</a><br /><br />Sum Range Defined By Reference Cell<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=98147">http://www.ozgrid.com/forum/showthread.php?t=98147</a><br /><br />Sum If With Multiple Criteria<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=98140">http://www.ozgrid.com/forum/showthread.php?t=98140</a><br /><br />Return All Results Corresponding To Lookup Value<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=90243">http://www.ozgrid.com/forum/showthread.php?t=90243</a><br /><br />Lookup Value Across Multiple Worksheets<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=89679">http://www.ozgrid.com/forum/showthread.php?t=89679</a><br /><br />Subtotal Filtered Column By Criteria<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=89215">http://www.ozgrid.com/forum/showthread.php?t=89215</a><br /><br />Lookup & Return Adjacent Value From Left<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=87509">http://www.ozgrid.com/forum/showthread.php?t=87509</a><br /><br />Separate Comma Delimited Cells To New Rows<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=87390">http://www.ozgrid.com/forum/showthread.php?t=87390</a><br /><br />Lookup Two Values In A List And Return Multiple Corresponding Values<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=87166">http://www.ozgrid.com/forum/showthread.php?t=87166</a><br /><br />Compare Ranges And Delete Duplicates<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=87414">http://www.ozgrid.com/forum/showthread.php?t=87414</a><br /><br />2 Criteria Lookup Without #N/A<br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=87381">http://www.ozgrid.com/forum/showthread.php?t=87381</a><br /><br />Keep EXCELlingKrishnakumarhttp://www.blogger.com/profile/10413219034695961726noreply@blogger.com0tag:blogger.com,1999:blog-5011465073079001765.post-83679699991130468722007-07-12T16:14:00.000+05:302007-07-26T15:03:14.243+05:30GeneralUserid And Password To Access Worksheets<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=73749">http://www.ozgrid.com/forum/showthread.php?t=73749</a><br /><br /><br />Yearly Calendar<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=58028">http://www.ozgrid.com/forum/showthread.php?t=58028</a><br /><br /><br />Dynamic Chart<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=58206">http://www.ozgrid.com/forum/showthread.php?t=58206</a><br /><br /><br />List of All Excel Functions<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=230815">http://www.mrexcel.com/board2/viewtopic.php?t=230815</a>Krishnakumarhttp://www.blogger.com/profile/10413219034695961726noreply@blogger.com0tag:blogger.com,1999:blog-5011465073079001765.post-19937134565727102282007-07-12T15:53:00.000+05:302007-07-26T15:03:06.588+05:30VBAsMerge, Sort & Eliminate Close Duplicates<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=73401">http://www.ozgrid.com/forum/showthread.php?t=73401</a><br /><br />Match Data from 2 Sheets and Results in 3rd Sheet<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=72681">http://www.ozgrid.com/forum/showthread.php?t=72681</a><br /><br />Remove zeros only<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=72623">http://www.ozgrid.com/forum/showthread.php?t=72623</a><br /><br />Check and Append data in Cells<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=72270">http://www.ozgrid.com/forum/showthread.php?t=72270</a><br /><br />Countif with SpecialCells<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=71997">http://www.ozgrid.com/forum/showthread.php?t=71997</a><br /><br />Count Most Frequent Values in a Cell<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=269509">http://www.mrexcel.com/board2/viewtopic.php?t=269509</a><br /><br />Add Unique Items in Combobox<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=271120">http://www.mrexcel.com/board2/viewtopic.php?t=271120</a><br /><br />Distribute 35000 Rows equally into 6 different excel sheets<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=254762">http://www.mrexcel.com/board2/viewtopic.php?t=254762</a><br /><br />Create Unique Words<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=249267">http://www.mrexcel.com/board2/viewtopic.php?t=249267</a><br /><br />Delete Rows Meeting Criteria or Condition<br /><a href="http://www.ozgrid.com/forum/showpost.php?p=312532&postcount=5">http://www.ozgrid.com/forum/showpost.php?p=312532&postcount=5</a><br /><br />Retain Leading Zero in Custom Format<br /><a href="http://www.ozgrid.com/forum/showpost.php?p=313474&postcount=4">http://www.ozgrid.com/forum/showpost.php?p=313474&postcount=4</a><br /><br />Add X Rows Between Each List Item<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=61058">http://www.ozgrid.com/forum/showthread.php?t=61058</a><br /><br />List All Worksheet Names<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=61138">http://www.ozgrid.com/forum/showthread.php?t=61138</a><br /><br />Match Cells And Sum<br /><a href="http://www.ozgrid.com/forum/showpost.php?p=319433&postcount=14">http://www.ozgrid.com/forum/showpost.php?p=319433&postcount=14</a><br /><br />Scanning Schedule<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=246085">http://www.mrexcel.com/board2/viewtopic.php?t=246085</a><br /><br />Unmerge and Fill Blank Cells<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=246451">http://www.mrexcel.com/board2/viewtopic.php?t=246451</a><br /><br />Filter by Background Color<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=240068">http://www.mrexcel.com/board2/viewtopic.php?t=240068</a><br /><br />Insert Rows<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=238604">http://www.mrexcel.com/board2/viewtopic.php?t=238604</a><br /><br />Transpose Data from Columns to Rows<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=238917">http://www.mrexcel.com/board2/viewtopic.php?t=238917</a><br /><br />Consolidate Data from Many Files to Single File<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=235229">http://www.mrexcel.com/board2/viewtopic.php?t=235229</a><br /><br />Change Sheet Name<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=56781">http://www.ozgrid.com/forum/showthread.php?t=56781</a><br /><br />Clear Old Pivot Items<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=56885">http://www.ozgrid.com/forum/showthread.php?t=56885</a><br /><br />Match Data from 2 Sheets and Results in 3rd Sheet<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=72681">http://www.ozgrid.com/forum/showthread.php?t=72681</a><br /><br />Remove zeros only<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=72623">http://www.ozgrid.com/forum/showthread.php?t=72623</a><br /><br />Check and Append data in Cells<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=72270">http://www.ozgrid.com/forum/showthread.php?t=72270</a><br /><br />Countif with SpecialCells<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=71997">http://www.ozgrid.com/forum/showthread.php?t=71997</a><br /><br />Count Most Frequent Values in a Cell<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=269509">http://www.mrexcel.com/board2/viewtopic.php?t=269509</a><br /><br />Add Unique Items in Combobox<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=271120">http://www.mrexcel.com/board2/viewtopic.php?t=271120</a><br /><br />Distribute 35000 Rows equally into 6 different excel sheets<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=254762">http://www.mrexcel.com/board2/viewtopic.php?t=254762</a><br /><br />Create Unique Words<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=249267">http://www.mrexcel.com/board2/viewtopic.php?t=249267</a><br /><br />Autofilter By Color<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=59611">http://www.ozgrid.com/forum/showthread.php?t=59611</a><br /><br />Move Data from 1 to Multiple Columns<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=59106">http://www.ozgrid.com/forum/showthread.php?t=59106</a>Krishnakumarhttp://www.blogger.com/profile/10413219034695961726noreply@blogger.com2tag:blogger.com,1999:blog-5011465073079001765.post-28555099053940995692007-07-12T15:49:00.000+05:302007-07-12T15:52:56.216+05:30FormulasFormulas..<br /><br />Count Occurence of 2 variables<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=72647">http://www.ozgrid.com/forum/showthread.php?t=72647</a><br /><br />Lookup Minimun with Criteria<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=72481">http://www.ozgrid.com/forum/showthread.php?t=72481</a><br /><br />Convert Date to Quarter<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=72428">http://www.ozgrid.com/forum/showthread.php?t=72428</a><br /><br />Count Unique Items in Autofilter<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=70131">http://www.ozgrid.com/forum/showthread.php?t=70131</a><br /><br />Split Text over x characters<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=71850">http://www.ozgrid.com/forum/showthread.php?t=71850</a><br /><br />Dual Headings Match<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=71471">http://www.ozgrid.com/forum/showthread.php?t=71471</a><br /><br />Convert Letter Grade to Numbers<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=71469">http://www.ozgrid.com/forum/showthread.php?t=71469</a><br /><br />Split Varying Lenght of Text<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=281367">http://www.mrexcel.com/board2/viewtopic.php?t=281367</a><br /><br />Lookup with Multiple results<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=70050">http://www.ozgrid.com/forum/showthread.php?t=70050</a><br /><br />Roundup to Nearest x<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=70107">http://www.ozgrid.com/forum/showthread.php?t=70107</a><br /><br />Index Match Function For Two Same Values<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=70267">http://www.ozgrid.com/forum/showthread.php?t=70267</a><br /><br />Extracting Subtotal Results<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=69791">http://www.ozgrid.com/forum/showthread.php?t=69791</a><br /><br />Vlookup Cell Containing Symbol & Text<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=69610">http://www.ozgrid.com/forum/showthread.php?t=69610</a><br /><br />Find first positive value<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=275007">http://www.mrexcel.com/board2/viewtopic.php?t=275007</a><br /><br />Last Text & Numeric Entry in Dynamic Range<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=68869">http://www.ozgrid.com/forum/showthread.php?t=68869</a><br /><br />Split Text<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=60226">http://www.ozgrid.com/forum/showthread.php?t=60226</a><br /><br />Convert Decimal to Feet & Inches<br /><a href="http://www.ozgrid.com/forum/showpost.php?p=311731&postcount=19">http://www.ozgrid.com/forum/showpost.php?p=311731&postcount=19</a><br /><br />Find Nos. In Strings<br /><a href="http://www.ozgrid.com/forum/showpost.php?p=312542&postcount=3">http://www.ozgrid.com/forum/showpost.php?p=312542&postcount=3</a><br /><br />Copy Unique Lists<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=60309">http://www.ozgrid.com/forum/showthread.php?t=60309</a><br /><br />Convert Date with Dot Separated<br /><a href="http://www.ozgrid.com/forum/showpost.php?p=311790&postcount=10">http://www.ozgrid.com/forum/showpost.php?p=311790&postcount=10</a><br /><br />Take Value to Left of Max Value in a Column<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=60519">http://www.ozgrid.com/forum/showthread.php?t=60519</a><br /><br />Highlight Array Formulas in Range<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=55433">http://www.ozgrid.com/forum/showthread.php?t=55433</a><br /><br />Lookup on Multiple Sheets<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=60681">http://www.ozgrid.com/forum/showthread.php?t=60681</a><br /><br />Phone Number Splitting<br /><a href="http://www.ozgrid.com/forum/showpost.php?p=313634&postcount=6">http://www.ozgrid.com/forum/showpost.php?p=313634&postcount=6</a><br /><br />Lookup Transposed Table<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=60822">http://www.ozgrid.com/forum/showthread.php?t=60822</a><br /><br />Count Numbers In Sequence<br /><a href="http://www.ozgrid.com/forum/showpost.php?p=316909&postcount=8">http://www.ozgrid.com/forum/showpost.php?p=316909&postcount=8</a><br /><br />Return Value After Matching Two Variables<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=61412">http://www.ozgrid.com/forum/showthread.php?t=61412</a><br /><br />Show Nth Day of Month<br /><a href="http://www.ozgrid.com/forum/showpost.php?p=317454&postcount=4">http://www.ozgrid.com/forum/showpost.php?p=317454&postcount=4</a><br /><br />Date Formula Based on Other Dates<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=61679">http://www.ozgrid.com/forum/showthread.php?t=61679</a><br /><br /><a href="http://www.ozgrid.com/forum/showpost.php?p=319433&postcount=14">http://www.ozgrid.com/forum/showpost.php?p=319433&postcount=14</a><br /><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=61880">http://www.ozgrid.com/forum/showthread.php?t=61880</a><br /><br />Sort By Lookup & Ranking<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=61857">http://www.ozgrid.com/forum/showthread.php?t=61857</a><br /><br />Sum Range Using 1 Column of Named Range as Criteria<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=61929">http://www.ozgrid.com/forum/showthread.php?t=61929</a><br /><br />Adding Cell Names<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=246234">http://www.mrexcel.com/board2/viewtopic.php?t=246234</a><br /><br />Return Row No. of Top 3 Values<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=248288">http://www.mrexcel.com/board2/viewtopic.php?t=248288</a><br /><br />Counting No. of Different Instances<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=246432">http://www.mrexcel.com/board2/viewtopic.php?t=246432</a><br /><br />Formatting Phone Numbers<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=242707">http://www.mrexcel.com/board2/viewtopic.php?t=242707</a><br /><br />Find Last Non-zero Value<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=241778">http://www.mrexcel.com/board2/viewtopic.php?t=241778</a><br /><br />Scroll Area Limit<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=240865">http://www.mrexcel.com/board2/viewtopic.php?t=240865</a><br /><br />Count Words with All Caps<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=237290">http://www.mrexcel.com/board2/viewtopic.php?t=237290</a><br /><br />Extract Data from String<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=236351">http://www.mrexcel.com/board2/viewtopic.php?t=236351</a><br /><br />Sum Alphanumerics<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=60111">http://www.ozgrid.com/forum/showthread.php?t=60111</a><br /><br />Match Multiple Criteria<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=60019">http://www.ozgrid.com/forum/showthread.php?t=60019</a><br /><br />Extract Digits From Text<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=60076">http://www.ozgrid.com/forum/showthread.php?t=60076</a><br /><br />Dynamic Range Formula<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=59919">http://www.ozgrid.com/forum/showthread.php?t=59919</a><br /><br />Sum Values based on Text<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=59855">http://www.ozgrid.com/forum/showthread.php?t=59855</a><br /><br />Calculate Financial Year<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=59901">http://www.ozgrid.com/forum/showthread.php?t=59901</a><br /><br />Return Lowest Based on Text<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=59818">http://www.ozgrid.com/forum/showthread.php?t=59818</a><br /><br />Find Last Values and Sum<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=59744">http://www.ozgrid.com/forum/showthread.php?t=59744</a><br /><br />Delete Duplicates Except Last<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=59705">http://www.ozgrid.com/forum/showthread.php?t=59705</a><br /><br />Lookup on Multiple Sheets<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=59341">http://www.ozgrid.com/forum/showthread.php?t=59341</a><br /><br />Last Name, First Name<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=59127">http://www.ozgrid.com/forum/showthread.php?t=59127</a><br /><br />Bring Sum into a Single Digit<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=58770">http://www.ozgrid.com/forum/showthread.php?t=58770</a><br /><br />Transpose Columns Data into Single Column<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=58549">http://www.ozgrid.com/forum/showthread.php?t=58549</a><br /><br />Convert yyyymmdd to dd-mm-yyyy<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=58317">http://www.ozgrid.com/forum/showthread.php?t=58317</a><br /><br />List Sheet Names<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=58897">http://www.ozgrid.com/forum/showthread.php?t=58897</a><br /><br />Splitting Address to Multiple Cells<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=58851">http://www.ozgrid.com/forum/showthread.php?t=58851</a><br /><br />Match Data and Split<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=58393">http://www.ozgrid.com/forum/showthread.php?t=58393</a><br /><br />DSUM<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=57491">http://www.ozgrid.com/forum/showthread.php?t=57491</a><br /><br />Extract Text Between Characters<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=57416">http://www.ozgrid.com/forum/showthread.php?t=57416</a><br /><br />SUMIF on Badly Laid out Data<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=57079">http://www.ozgrid.com/forum/showthread.php?t=57079</a><br /><br />Weighted Average on Filtered Data<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=57169">http://www.ozgrid.com/forum/showthread.php?t=57169</a><br /><br />Extracting Data Within Parentheses<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=57265">http://www.ozgrid.com/forum/showthread.php?t=57265</a><br /><br />Average Fixed Intervals In A Large Column Of Data<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=57266">http://www.ozgrid.com/forum/showthread.php?t=57266</a><br /><br />Count Times Between 2 Specified Times<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=57260">http://www.ozgrid.com/forum/showthread.php?t=57260</a><br /><br />Count of Duplicate Entries<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=57232">http://www.ozgrid.com/forum/showthread.php?t=57232</a><br /><br />Extract Letters from Cell<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=232227">http://www.mrexcel.com/board2/viewtopic.php?t=232227</a><br /><br />Count Occurence of 2 variables<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=72647">http://www.ozgrid.com/forum/showthread.php?t=72647</a><br /><br />Lookup Minimun with Criteria<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=72481">http://www.ozgrid.com/forum/showthread.php?t=72481</a><br /><br />Convert Date to Quarter<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=72428">http://www.ozgrid.com/forum/showthread.php?t=72428</a><br /><br />Count Unique Items in Autofilter<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=70131">http://www.ozgrid.com/forum/showthread.php?t=70131</a><br /><br />Split Text over x characters<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=71850">http://www.ozgrid.com/forum/showthread.php?t=71850</a><br /><br />Dual Headings Match<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=71471">http://www.ozgrid.com/forum/showthread.php?t=71471</a><br /><br />Convert Letter Grade to Numbers<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=71469">http://www.ozgrid.com/forum/showthread.php?t=71469</a><br /><br />Split Varying Lenght of Text<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=281367">http://www.mrexcel.com/board2/viewtopic.php?t=281367</a><br /><br />Lookup with Multiple results<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=70050">http://www.ozgrid.com/forum/showthread.php?t=70050</a><br /><br />Roundup to Nearest x<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=70107">http://www.ozgrid.com/forum/showthread.php?t=70107</a><br /><br />Index Match Function For Two Same Values<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=70267">http://www.ozgrid.com/forum/showthread.php?t=70267</a><br /><br />Weeknum to Date<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=56784">http://www.ozgrid.com/forum/showthread.php?t=56784</a><br /><br />Commission Formula<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=56891">http://www.ozgrid.com/forum/showthread.php?t=56891</a><br /><br />Lookup Based on 2 Criteria<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=56835">http://www.ozgrid.com/forum/showthread.php?t=56835</a><br /><br />Lookup<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=56827">http://www.ozgrid.com/forum/showthread.php?t=56827</a><br /><br />2 Dimensional Lookup<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=56964">http://www.ozgrid.com/forum/showthread.php?t=56964</a><br /><br />Sum with Multiple Criteria<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=231395">http://www.mrexcel.com/board2/viewtopic.php?t=231395</a><br /><br />Countif with a Twist<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=230845">http://www.mrexcel.com/board2/viewtopic.php?t=230845</a><br /><br />Count Days Excluding SUnday<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=230749">http://www.mrexcel.com/board2/viewtopic.php?t=230749</a><br /><br />Lookup With Multiple Results<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=231144">http://www.mrexcel.com/board2/viewtopic.php?t=231144</a><br /><br />Extracting Subtotal Results<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=69791">http://www.ozgrid.com/forum/showthread.php?t=69791</a><br /><br />Vlookup Cell Containing Symbol & Text<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=69610">http://www.ozgrid.com/forum/showthread.php?t=69610</a><br /><br />Find first positive value<br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=275007">http://www.mrexcel.com/board2/viewtopic.php?t=275007</a><br /><br />Last Text & Numeric Entry in Dynamic Range<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=68869">http://www.ozgrid.com/forum/showthread.php?t=68869</a>Krishnakumarhttp://www.blogger.com/profile/10413219034695961726noreply@blogger.com0