tag:blogger.com,1999:blog-321709772011-12-14T19:04:04.633-08:00My Excel PostingsKrishnakumarhttp://www.blogger.com/profile/10413219034695961726noreply@blogger.comBlogger91100tag:blogger.com,1999:blog-32170977.post-85399646440693521252008-10-10T08:36:00.001-07:002008-10-10T08:37:40.732-07:00<p></p><p>Merge Shift Timesheet Files Into Monthly Reports<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=109949">http://www.ozgrid.com/forum/showthread.php?t=109949</a><br />Copy/Special Paste Data Within A Range To Next Empty Cell Then Mark the Copied Area<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=103752">http://www.ozgrid.com/forum/showthread.php?t=103752</a><br />Calculate Weighted Median<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=102065">http://www.ozgrid.com/forum/showthread.php?t=102065</a><br />Pull Each Each Digit From Number Into Single Cells<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=101909">http://www.ozgrid.com/forum/showthread.php?t=101909</a><br />X Condition Lookup<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=101800">http://www.ozgrid.com/forum/showthread.php?t=101800</a><br />Auto-Extending Graph/Chart Range<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=101710">http://www.ozgrid.com/forum/showthread.php?t=101710</a><br />Lookup & Return All Occurences<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=100061">http://www.ozgrid.com/forum/showthread.php?t=100061</a><br />Remove All But 1st Of Duplicate Rows<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=99030">http://www.ozgrid.com/forum/showthread.php?t=99030</a><br />Create A New Worksheet With Specific Cell<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=98949">http://www.ozgrid.com/forum/showthread.php?t=98949</a><br />Reference Cell In Macro Using Row & Column Numbers From Cell<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=98948">http://www.ozgrid.com/forum/showthread.php?t=98948</a><br />Concatenate Each Row To Cells In Column<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=98718">http://www.ozgrid.com/forum/showthread.php?t=98718</a><br />Colour Cells Conditionally From Formula<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=98631">http://www.ozgrid.com/forum/showthread.php?t=98631</a><br />Add Missing Leading Zeros To Text<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=98627">http://www.ozgrid.com/forum/showthread.php?t=98627</a><br />Filter Named Range To Userform ListBox<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=98624">http://www.ozgrid.com/forum/showthread.php?t=98624</a><br />Conditional Percentage Calculation<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=98459">http://www.ozgrid.com/forum/showthread.php?t=98459</a><br />Concatenating Many Columns To One<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=98406">http://www.ozgrid.com/forum/showthread.php?t=98406</a><br />Quartile Function In VBA<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=98152">http://www.ozgrid.com/forum/showthread.php?t=98152</a><br />Sum Range Defined By Reference Cell<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=98147">http://www.ozgrid.com/forum/showthread.php?t=98147</a><br />Sum If With Multiple Criteria<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=98140">http://www.ozgrid.com/forum/showthread.php?t=98140</a><br />Return All Results Corresponding To Lookup Value<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=90243">http://www.ozgrid.com/forum/showthread.php?t=90243</a><br />Lookup Value Across Multiple Worksheets<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=89679">http://www.ozgrid.com/forum/showthread.php?t=89679</a><br />Subtotal Filtered Column By Criteria<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=89215">http://www.ozgrid.com/forum/showthread.php?t=89215</a><br />Lookup & Return Adjacent Value From Left<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=87509">http://www.ozgrid.com/forum/showthread.php?t=87509</a><br />Separate Comma Delimited Cells To New Rows<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=87390">http://www.ozgrid.com/forum/showthread.php?t=87390</a><br />Lookup Two Values In A List And Return Multiple Corresponding Values<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=87166">http://www.ozgrid.com/forum/showthread.php?t=87166</a><br />Compare Ranges And Delete Duplicates<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=87414">http://www.ozgrid.com/forum/showthread.php?t=87414</a><br />2 Criteria Lookup Without #N/A<br /><a href="http://www.ozgrid.com/forum/showthread.php?t=87381">http://www.ozgrid.com/forum/showthread.php?t=87381</a></p><p></p><div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-6384948159667908";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as_rimg";
google_cpa_choice = "CAAQ8aaVzgEaCPJg3qtkyXM9KOm293M";
google_ad_channel = "";
//--></script>
<script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/32170977-8539964644069352125?l=kris-myexcelpages.blogspot.com' alt='' /></div>Krishnakumarhttp://www.blogger.com/profile/10413219034695961726noreply@blogger.com0tag:blogger.com,1999:blog-32170977.post-60384806938687465762007-07-13T22:20:00.000-07:002008-12-11T20:32:05.431-08:00<a href="http://4.bp.blogspot.com/_setLkvnIaUY/RphhZJGNKfI/AAAAAAAAAAM/A5LhVCWSKyQ/s1600-h/DSC00100.JPG"></a><br /><div></div><div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-6384948159667908";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as_rimg";
google_cpa_choice = "CAAQ8aaVzgEaCPJg3qtkyXM9KOm293M";
google_ad_channel = "";
//--></script>
<script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/32170977-6038480693868746576?l=kris-myexcelpages.blogspot.com' alt='' /></div>Krishnakumarhttp://www.blogger.com/profile/10413219034695961726noreply@blogger.com0tag:blogger.com,1999:blog-32170977.post-1166687150554828212006-12-20T22:59:00.000-08:002006-12-21T00:25:11.696-08:00<strong><span style="color:#009900;">FORMULAS</span></strong><br /><strong><span style="color:#009900;"></span></strong><br />Split Text<br /><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 /><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 /><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 /><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 /><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 /><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 /><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 /><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 /><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 /><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 /><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 /><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 /><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 /><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 /><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 /><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 /><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 /><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 /><br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=246432">http://www.mrexcel.com/board2/viewtopic.php?t=246432</a><br /><br /><br /><br /><strong><span style="color:#339999;">VBA</span></strong><br /><br />Delete Rows Meeting Criteria or Condition<br /><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 /><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 /><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 /><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 /><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 /><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 /><br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=246451">http://www.mrexcel.com/board2/viewtopic.php?t=246451</a><br /><br /><br /><a id="thread_title_60519" href="http://www.ozgrid.com/forum/showthread.php?t=60519"></a><div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-6384948159667908";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as_rimg";
google_cpa_choice = "CAAQ8aaVzgEaCPJg3qtkyXM9KOm293M";
google_ad_channel = "";
//--></script>
<script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/32170977-116668715055482821?l=kris-myexcelpages.blogspot.com' alt='' /></div>Krishnakumarhttp://www.blogger.com/profile/10413219034695961726noreply@blogger.com0tag:blogger.com,1999:blog-32170977.post-1163669925906701322006-11-16T01:23:00.000-08:002006-11-16T01:38:46.226-08:00<strong><span style="color:#339999;">FORMULAS</span></strong><br /><strong><span style="color:#339999;"></span></strong><br /><span style="color:#000000;">Formatting Phone Numbers</span><br /><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 /><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 /><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 /><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 /><br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=236351">http://www.mrexcel.com/board2/viewtopic.php?t=236351</a><br /><br /><br /><br /><strong><span style="color:#339999;">VBAs</span></strong><br /><br />Filter by Background Color<br /><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 /><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 /><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 /><br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=235229">http://www.mrexcel.com/board2/viewtopic.php?t=235229</a><div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-6384948159667908";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as_rimg";
google_cpa_choice = "CAAQ8aaVzgEaCPJg3qtkyXM9KOm293M";
google_ad_channel = "";
//--></script>
<script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/32170977-116366992590670132?l=kris-myexcelpages.blogspot.com' alt='' /></div>Krishnakumarhttp://www.blogger.com/profile/10413219034695961726noreply@blogger.com0tag:blogger.com,1999:blog-32170977.post-1163576503925530872006-11-14T23:14:00.000-08:002006-11-14T23:41:44.743-08:00<strong><span style="color:#339999;">FORMULAS</span></strong><br /><strong><span style="color:#339999;"></span></strong><br /><p>Sum Alphanumerics</p><p><a href="http://www.ozgrid.com/forum/showthread.php?t=60111">http://www.ozgrid.com/forum/showthread.php?t=60111</a></p><p>Match Multiple Criteria</p><p><a href="http://www.ozgrid.com/forum/showthread.php?t=60019">http://www.ozgrid.com/forum/showthread.php?t=60019</a></p><p>Extract Digits From Text</p><p><a href="http://www.ozgrid.com/forum/showthread.php?t=60076">http://www.ozgrid.com/forum/showthread.php?t=60076</a></p><p>Dynamic Range Formula</p><p><a href="http://www.ozgrid.com/forum/showthread.php?t=59919">http://www.ozgrid.com/forum/showthread.php?t=59919</a></p><p>Sum Values based on Text</p><p><a href="http://www.ozgrid.com/forum/showthread.php?t=59855">http://www.ozgrid.com/forum/showthread.php?t=59855</a></p><p>Calculate Financial Year</p><p><a href="http://www.ozgrid.com/forum/showthread.php?t=59901">http://www.ozgrid.com/forum/showthread.php?t=59901</a></p><p>Return Lowest Based on Text</p><p><a href="http://www.ozgrid.com/forum/showthread.php?t=59818">http://www.ozgrid.com/forum/showthread.php?t=59818</a></p><p>Find Last Values and Sum</p><p><a href="http://www.ozgrid.com/forum/showthread.php?t=59744">http://www.ozgrid.com/forum/showthread.php?t=59744</a></p><p>Delete Duplicates Except Last</p><p><a href="http://www.ozgrid.com/forum/showthread.php?t=59705">http://www.ozgrid.com/forum/showthread.php?t=59705</a></p><p>Lookup on Multiple Sheets</p><p><a href="http://www.ozgrid.com/forum/showthread.php?t=59341">http://www.ozgrid.com/forum/showthread.php?t=59341</a></p><p>Last Name, First Name</p><p><a href="http://www.ozgrid.com/forum/showthread.php?t=59127">http://www.ozgrid.com/forum/showthread.php?t=59127</a></p><p>Bring Sum into a Single Digit</p><p><a href="http://www.ozgrid.com/forum/showthread.php?t=58770">http://www.ozgrid.com/forum/showthread.php?t=58770</a></p><p>Transpose Columns Data into Single Column</p><p><a href="http://www.ozgrid.com/forum/showthread.php?t=58549">http://www.ozgrid.com/forum/showthread.php?t=58549</a><br /> </p><p>Convert yyyymmdd to dd-mm-yyyy</p><p><a href="http://www.ozgrid.com/forum/showthread.php?t=58317">http://www.ozgrid.com/forum/showthread.php?t=58317</a></p><p>Yearly Calendar</p><p><a href="http://www.ozgrid.com/forum/showthread.php?t=58028">http://www.ozgrid.com/forum/showthread.php?t=58028</a></p><p> </p><p>VBAs</p><p>Autofilter By Color</p><p><a href="http://www.ozgrid.com/forum/showthread.php?t=59611">http://www.ozgrid.com/forum/showthread.php?t=59611</a></p><p>Move Data from 1 to Multiple Columns</p><p><a href="http://www.ozgrid.com/forum/showthread.php?t=59106">http://www.ozgrid.com/forum/showthread.php?t=59106</a><br /></p><p>List Sheet Names</p><p><a href="http://www.ozgrid.com/forum/showthread.php?t=58897">http://www.ozgrid.com/forum/showthread.php?t=58897</a><br /></p><p>Splitting Address to Multiple Cells</p><p><a href="http://www.ozgrid.com/forum/showthread.php?t=58851">http://www.ozgrid.com/forum/showthread.php?t=58851</a><br /></p><p>Match Data and Split</p><p><a href="http://www.ozgrid.com/forum/showthread.php?t=58393">http://www.ozgrid.com/forum/showthread.php?t=58393</a><br /></p><p>Dynamic Chart</p><p><a href="http://www.ozgrid.com/forum/showthread.php?t=58206">http://www.ozgrid.com/forum/showthread.php?t=58206</a></p><div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-6384948159667908";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as_rimg";
google_cpa_choice = "CAAQ8aaVzgEaCPJg3qtkyXM9KOm293M";
google_ad_channel = "";
//--></script>
<script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/32170977-116357650392553087?l=kris-myexcelpages.blogspot.com' alt='' /></div>Krishnakumarhttp://www.blogger.com/profile/10413219034695961726noreply@blogger.com0tag:blogger.com,1999:blog-32170977.post-1158738065522367992006-09-20T00:37:00.000-07:002006-09-20T00:41:05.680-07:00<span style="color:#cc9933;"><strong>Formulas...</strong></span><br /><br /><br /><span style="color:#009900;">DSUM</span><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=57491">http://www.ozgrid.com/forum/showthread.php?t=57491</a><br /><span style="color:#009900;">Extract Text Between Characters</span><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=57416">http://www.ozgrid.com/forum/showthread.php?t=57416</a><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 /><span style="color:#009900;">Weighted Average on Filtered Data</span><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=57169">http://www.ozgrid.com/forum/showthread.php?t=57169</a><br /><span style="color:#009900;">Extracting Data Within Parentheses</span><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=57265">http://www.ozgrid.com/forum/showthread.php?t=57265</a><br /><span style="color:#009900;">Average Fixed Intervals In A Large Column Of Data</span> <a href="http://www.ozgrid.com/forum/showthread.php?t=57266">http://www.ozgrid.com/forum/showthread.php?t=57266</a><br /><span style="color:#009900;">Count Times Between 2 Specified Times</span><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=57260">http://www.ozgrid.com/forum/showthread.php?t=57260</a><br /><span style="color:#009900;">Count of Duplicate Entries</span><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=57232">http://www.ozgrid.com/forum/showthread.php?t=57232</a><br /><span style="color:#009900;">Extract Letters from Cell</span><br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=232227">http://www.mrexcel.com/board2/viewtopic.php?t=232227</a><div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-6384948159667908";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as_rimg";
google_cpa_choice = "CAAQ8aaVzgEaCPJg3qtkyXM9KOm293M";
google_ad_channel = "";
//--></script>
<script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/32170977-115873806552236799?l=kris-myexcelpages.blogspot.com' alt='' /></div>Krishnakumarhttp://www.blogger.com/profile/10413219034695961726noreply@blogger.com0tag:blogger.com,1999:blog-32170977.post-1157955989930653972006-09-10T23:19:00.000-07:002006-09-20T00:34:59.676-07:00<span style="font-size:130%;color:#ff9900;">Formulas....</span><br /><span style="color:#009900;"></span><br /><span style="color:#009900;">Weeknum to Date</span><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=56784">http://www.ozgrid.com/forum/showthread.php?t=56784</a><br /><span style="color:#009900;">Commission Formula</span><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=56891">http://www.ozgrid.com/forum/showthread.php?t=56891</a><br /><span style="color:#009900;">Lookup Based on 2 Criteria</span><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=56835">http://www.ozgrid.com/forum/showthread.php?t=56835</a><br /><span style="color:#009900;">Lookup</span><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=56827">http://www.ozgrid.com/forum/showthread.php?t=56827</a><br /><span style="color:#009900;">2 Dimensional Lookup</span><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=56964">http://www.ozgrid.com/forum/showthread.php?t=56964</a><br /><span style="color:#009900;">Sum with Multiple Criteria</span><br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=231395">http://www.mrexcel.com/board2/viewtopic.php?t=231395</a><br /><span style="color:#009900;">Countif with a Twist</span><br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=230845">http://www.mrexcel.com/board2/viewtopic.php?t=230845</a><br /><span style="color:#009900;">Count Days Excluding SUnday</span><br /><a href="http://www.mrexcel.com/board2/viewtopic.php?t=230749">http://www.mrexcel.com/board2/viewtopic.php?t=230749</a><br /><span style="color:#009900;">Lookup With Multiple Results</span><br />http://www.mrexcel.com/board2/viewtopic.php?t=231144<br /><br /><br /><span style="color:#ff9900;"><span style="font-size:130%;">VBA</span><br /><br /></span><span style="color:#ff9900;"></span><span style="color:#009900;">Change Sheet Name</span><br /><a href="http://www.ozgrid.com/forum/showthread.php?t=56781">http://www.ozgrid.com/forum/showthread.php?t=56781</a><br /><span style="color:#009900;">Clear Old Pivot Items</span><br />http://www.ozgrid.com/forum/showthread.php?t=56885<br /><br /><br /><span style="font-size:130%;color:#ff9900;">List of All Excel Functions </span><br /><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"><script type="text/javascript"><!--
google_ad_client = "pub-6384948159667908";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as_rimg";
google_cpa_choice = "CAAQ8aaVzgEaCPJg3qtkyXM9KOm293M";
google_ad_channel = "";
//--></script>
<script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/32170977-115795598993065397?l=kris-myexcelpages.blogspot.com' alt='' /></div>Krishnakumarhttp://www.blogger.com/profile/10413219034695961726noreply@blogger.com0tag:blogger.com,1999:blog-32170977.post-1156925152988274622006-08-30T01:02:00.000-07:002006-08-31T01:45:16.626-07:00I'm really happy to inform you all that on Monday (28-08-2006) I have been awarded the MVP status at OzGrid Excel Forum.<br /><br />Quote from the forum..<br /><br />"Please welcome Batman, Krishnakumar and carlmack to their newly appointed Oz MVP status. I would like to start of by saying a BIG thanks to all 3 for their totally unselfish attitude and making the Ozgrid forums a better place for all."<br /><br />Kind Regards<br />Dave Hawley@OzGrid<div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-6384948159667908";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as_rimg";
google_cpa_choice = "CAAQ8aaVzgEaCPJg3qtkyXM9KOm293M";
google_ad_channel = "";
//--></script>
<script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/32170977-115692515298827462?l=kris-myexcelpages.blogspot.com' alt='' /></div>Krishnakumarhttp://www.blogger.com/profile/10413219034695961726noreply@blogger.com2tag:blogger.com,1999:blog-32170977.post-1154688179748942182006-08-04T03:28:00.000-07:002006-08-31T01:09:16.380-07:00Hi All,<br /><br />My posts at different Excel Forums....<br /><br /><strong><span style="color:#3333ff;">Formulas</span></strong><br /><ul><li><a href="http://www.ozgrid.com/forum/showthread.php?t=55160">http://www.ozgrid.com/forum/showthread.php?t=55160</a> (Lookup Backward)</li><li><a href="http://www.ozgrid.com/forum/showthread.php?t=55101">http://www.ozgrid.com/forum/showthread.php?t=55101</a> (Nearest Number Match)</li><li><a href="http://www.ozgrid.com/forum/showthread.php?t=54741">http://www.ozgrid.com/forum/showthread.php?t=54741</a> (Sumif Inside Sumproduct)</li><li><a href="http://www.ozgrid.com/forum/showthread.php?t=54734">http://www.ozgrid.com/forum/showthread.php?t=54734</a> (Find 2nd Occurrence)</li><li><a href="http://www.ozgrid.com/forum/showthread.php?t=54430">http://www.ozgrid.com/forum/showthread.php?t=54430</a> (Return Last Value Based on Criteria)</li><li><a href="http://www.ozgrid.com/forum/showthread.php?t=55613">http://www.ozgrid.com/forum/showthread.php?t=55613</a> (Find Missing Numbers)</li><li><a href="http://www.ozgrid.com/forum/showthread.php?t=56513">http://www.ozgrid.com/forum/showthread.php?t=56513</a> (Military Time)</li><li><a href="http://www.ozgrid.com/forum/showthread.php?t=56465">http://www.ozgrid.com/forum/showthread.php?t=56465</a> (Sumif with Criteria being Strikethru)</li><li><a href="http://www.ozgrid.com/forum/showthread.php?t=56477">http://www.ozgrid.com/forum/showthread.php?t=56477</a> (Dependent List - Data Validation)</li><li><a href="http://www.ozgrid.com/forum/showthread.php?t=56214">http://www.ozgrid.com/forum/showthread.php?t=56214</a> (Match Postal Codes)</li><li><a href="http://www.ozgrid.com/forum/showthread.php?t=56428">http://www.ozgrid.com/forum/showthread.php?t=56428</a> (Average Letters)</li><li><a href="http://www.ozgrid.com/forum/showthread.php?t=56338">http://www.ozgrid.com/forum/showthread.php?t=56338</a> (Weekdays Count)</li><li><a href="http://www.ozgrid.com/forum/showthread.php?t=56325">http://www.ozgrid.com/forum/showthread.php?t=56325</a> (Lookup Results in One Cell)</li><li><a href="http://www.ozgrid.com/forum/showthread.php?t=56139">http://www.ozgrid.com/forum/showthread.php?t=56139</a> (List of Folders)</li><li><a href="http://www.ozgrid.com/forum/showthread.php?t=56314">http://www.ozgrid.com/forum/showthread.php?t=56314</a> (Lookup on 2 Lists)</li><li><a href="http://www.ozgrid.com/forum/showthread.php?t=56079">http://www.ozgrid.com/forum/showthread.php?t=56079</a> (Average Column Containing Errors)</li><li><a href="http://www.ozgrid.com/forum/showthread.php?t=28928">http://www.ozgrid.com/forum/showthread.php?t=28928</a> (Vlookup with Multiple Results)</li><li><a href="http://www.mrexcel.com/board2/viewtopic.php?t=229542">http://www.mrexcel.com/board2/viewtopic.php?t=229542</a> (Extract nofrom String)</li><li><a href="http://www.mrexcel.com/board2/viewtopic.php?t=229533">http://www.mrexcel.com/board2/viewtopic.php?t=229533</a> (Sumif Multiple Columns)</li><li><a href="http://www.mrexcel.com/board2/viewtopic.php?t=228839">http://www.mrexcel.com/board2/viewtopic.php?t=228839</a> (Find Numbers/Strings)</li><li><a href="http://www.mrexcel.com/board2/viewtopic.php?t=225668">http://www.mrexcel.com/board2/viewtopic.php?t=225668</a> (Split Data and Average)</li><li><a href="http://www.mrexcel.com/board2/viewtopic.php?t=224165">http://www.mrexcel.com/board2/viewtopic.php?t=224165</a> (Indian Currency Format)</li><li><a href="http://www.mrexcel.com/board2/viewtopic.php?t=224641">http://www.mrexcel.com/board2/viewtopic.php?t=224641</a> (Sheet Name)</li><li><a href="http://www.mrexcel.com/board2/viewtopic.php?t=223162">http://www.mrexcel.com/board2/viewtopic.php?t=223162</a> (Highlight Duplicate rows)</li><li><a href="http://www.mrexcel.com/board2/viewtopic.php?t=222896">http://www.mrexcel.com/board2/viewtopic.php?t=222896</a> (Average excluding blanks)<br /></li></ul><br /><span style="color:#3333ff;"><strong>VBA</strong></span><br /><span style="color:#3333ff;"></span><ul><li><a href="http://www.mrexcel.com/board2/viewtopic.php?t=213955">http://www.mrexcel.com/board2/viewtopic.php?t=213955</a> (Delete Duplicate - VBA)</li><li><a href="http://www.mrexcel.com/board2/viewtopic.php?t=205456">http://www.mrexcel.com/board2/viewtopic.php?t=205456</a> (Military Time)</li><li><a href="http://www.mrexcel.com/board2/viewtopic.php?t=227315">http://www.mrexcel.com/board2/viewtopic.php?t=227315</a> (Delete Blank Rows)</li><li><a href="http://www.mrexcel.com/board2/viewtopic.php?t=227084">http://www.mrexcel.com/board2/viewtopic.php?t=227084</a> (Extract Username from Comments)</li><li><a href="http://www.mrexcel.com/board2/viewtopic.php?t=226451">http://www.mrexcel.com/board2/viewtopic.php?t=226451</a> (Consolidate Sheets into a Master Sheet)</li><li><a href="http://www.mrexcel.com/board2/viewtopic.php?t=230134">http://www.mrexcel.com/board2/viewtopic.php?t=230134</a> (VBA to return Column Letter)</li><li><a href="http://www.mrexcel.com/board2/viewtopic.php?t=209639">http://www.mrexcel.com/board2/viewtopic.php?t=209639</a> (Sum Blocks)<br /></li></ul><p><strong><span style="color:#3333ff;">Chart</span></strong></p><ul><li><a href="http://www.ozgrid.com/forum/showthread.php?t=49268">http://www.ozgrid.com/forum/showthread.php?t=49268</a> (Dynamic Chart)<br /></li></ul><p><strong><span style="color:#3333ff;">Solver</span></strong></p><ul><li><a href="http://www.ozgrid.com/forum/showthread.php?t=40750">http://www.ozgrid.com/forum/showthread.php?t=40750</a> (Solver)</li></ul><p></p><p></p><p></p><p><span style="color:#009900;"><strong><em></em></strong></span> </p><p><span style="color:#009900;"><strong><em>Keep visiting. More to follows...</em></strong></span></p><p></p><div class="blogger-post-footer"><script type="text/javascript"><!--
google_ad_client = "pub-6384948159667908";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as_rimg";
google_cpa_choice = "CAAQ8aaVzgEaCPJg3qtkyXM9KOm293M";
google_ad_channel = "";
//--></script>
<script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/32170977-115468817974894218?l=kris-myexcelpages.blogspot.com' alt='' /></div>Krishnakumarhttp://www.blogger.com/profile/10413219034695961726noreply@blogger.com0