tag:blogger.com,1999:blog-5011465073079001765Tue, 12 Jan 2010 06:06:52 +0000A collection of my excel posts at different forumshttp://krisexcelpostings.blogspot.com/noreply@blogger.com (Krishnakumar)Blogger5125tag:blogger.com,1999:blog-5011465073079001765.post-3949132211894504311Sun, 01 Mar 2009 06:38:00 +00002009-07-26T21:04:37.506+05:30<p><a href="http://feedads.g.doubleclick.net/~a/OeJjVWeueZHqkxateetCN_2ZQSE/0/da"><img src="http://feedads.g.doubleclick.net/~a/OeJjVWeueZHqkxateetCN_2ZQSE/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/OeJjVWeueZHqkxateetCN_2ZQSE/1/da"><img src="http://feedads.g.doubleclick.net/~a/OeJjVWeueZHqkxateetCN_2ZQSE/1/di" border="0" ismap="true"></img></a></p>Merge 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 &amp; 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 &amp; 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 &amp; 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 EXCELling<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5011465073079001765-4552514370963374757?l=krisexcelpostings.blogspot.com' alt='' /></div><img src="http://feeds.feedburner.com/~r/blogspot/oDoJ/~4/gkXDYbRTRPc" height="1" width="1"/>http://feedproxy.google.com/~r/blogspot/oDoJ/~3/gkXDYbRTRPc/vbas-and-formulas-posted-at-ozgrid.htmlnoreply@blogger.com (Krishnakumar)0http://krisexcelpostings.blogspot.com/2008/10/vbas-and-formulas-posted-at-ozgrid.htmltag:blogger.com,1999:blog-5011465073079001765.post-8367969999113046872Thu, 12 Jul 2007 10:44:00 +00002007-07-26T15:03:14.243+05:30<p><a href="http://feedads.g.doubleclick.net/~a/qdWxqHVel1nLmjhqbHlV7RCbfHw/0/da"><img src="http://feedads.g.doubleclick.net/~a/qdWxqHVel1nLmjhqbHlV7RCbfHw/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/qdWxqHVel1nLmjhqbHlV7RCbfHw/1/da"><img src="http://feedads.g.doubleclick.net/~a/qdWxqHVel1nLmjhqbHlV7RCbfHw/1/di" border="0" ismap="true"></img></a></p>Userid 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><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5011465073079001765-8367969999113046872?l=krisexcelpostings.blogspot.com' alt='' /></div><img src="http://feeds.feedburner.com/~r/blogspot/oDoJ/~4/X31p9eQIRrU" height="1" width="1"/>http://feedproxy.google.com/~r/blogspot/oDoJ/~3/X31p9eQIRrU/general.htmlnoreply@blogger.com (Krishnakumar)0http://krisexcelpostings.blogspot.com/2007/07/general.htmltag:blogger.com,1999:blog-5011465073079001765.post-1993713456572710228Thu, 12 Jul 2007 10:23:00 +00002007-07-26T15:03:06.588+05:30<p><a href="http://feedads.g.doubleclick.net/~a/SsAeKgoLWjFDdns8Knaymc_MYtk/0/da"><img src="http://feedads.g.doubleclick.net/~a/SsAeKgoLWjFDdns8Knaymc_MYtk/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/SsAeKgoLWjFDdns8Knaymc_MYtk/1/da"><img src="http://feedads.g.doubleclick.net/~a/SsAeKgoLWjFDdns8Knaymc_MYtk/1/di" border="0" ismap="true"></img></a></p>Merge, 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&amp;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&amp;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&amp;postcount=14">http://www.ozgrid.com/forum/showpost.php?p=319433&amp;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><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5011465073079001765-1993713456572710228?l=krisexcelpostings.blogspot.com' alt='' /></div><img src="http://feeds.feedburner.com/~r/blogspot/oDoJ/~4/VcjpIWhlJy8" height="1" width="1"/>http://feedproxy.google.com/~r/blogspot/oDoJ/~3/VcjpIWhlJy8/vbas-match-data-from-2-sheets-and.htmlnoreply@blogger.com (Krishnakumar)2http://krisexcelpostings.blogspot.com/2007/07/vbas-match-data-from-2-sheets-and.htmltag:blogger.com,1999:blog-5011465073079001765.post-2855509905394099569Thu, 12 Jul 2007 10:19:00 +00002007-07-12T15:52:56.216+05:30<p><a href="http://feedads.g.doubleclick.net/~a/OM3Bm4KQbCyBH4bj1VPPqJIklxM/0/da"><img src="http://feedads.g.doubleclick.net/~a/OM3Bm4KQbCyBH4bj1VPPqJIklxM/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/OM3Bm4KQbCyBH4bj1VPPqJIklxM/1/da"><img src="http://feedads.g.doubleclick.net/~a/OM3Bm4KQbCyBH4bj1VPPqJIklxM/1/di" border="0" ismap="true"></img></a></p>Formulas..<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 &amp; 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&amp;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&amp;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&amp;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&amp;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&amp;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&amp;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&amp;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 &amp; 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 &amp; 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><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5011465073079001765-2855509905394099569?l=krisexcelpostings.blogspot.com' alt='' /></div><img src="http://feeds.feedburner.com/~r/blogspot/oDoJ/~4/EHWkTkSVPc8" height="1" width="1"/>http://feedproxy.google.com/~r/blogspot/oDoJ/~3/EHWkTkSVPc8/formulas.htmlnoreply@blogger.com (Krishnakumar)0http://krisexcelpostings.blogspot.com/2007/07/formulas.html