<?xml version="1.0" encoding="UTF-8"?>
<howcast version="0.1">
  <title>Howcast - mrexcel's favorites</title>
  <count>80</count>
  <videos>
    <video>
      <category-id>1499</category-id>
      <id>67671</id>
      <title>Episode 879 - Icon Sets II</title>
      <type nil="true"></type>
      <views>37</views>
      <created-at>Thu, 30 Oct 2008 20:01:28 -0700</created-at>
      <rating>2</rating>
      <username>mrexcel</username>
      <description>
        <![CDATA[Excel 2007 offers a new visualization called an Icon Set. I usually
hate this feature, because my numbers are right justified and the icons
are left justified. However, in &lt;a href="http://mrexcel.libsyn.com/media/mrexcel/podcast879.mp4"&gt;Episode 879&lt;/a&gt;, Joanna ]]>
      </description>
      <embed>
        <![CDATA[<object width="425" height="352" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="howcastplayer"><param name="movie" value="http://www.howcast.com/flash/howcast_player.swf?file=67671"></param><param name="allowFullScreen" value="true"></param><param name="allowScriptAccess" value="always"></param><embed src="http://www.howcast.com/flash/howcast_player.swf?file=67671" type="application/x-shockwave-flash" width="425" height="352" allowFullScreen="true" allowScriptAccess="always" ></embed></object>]]>
      </embed>
      <duration>154</duration>
      <filename>http://media.howcast.com/system/videos/2/71/76/06/67671.flv</filename>
      <tags>Excel, business, accounting, spreadsheets, technology, MrExcel, Excel 2007, Formatting, tutorial</tags>
      <category-hierarchy>
        <category id="1470">Technology</category>
        <category parent_id="1470" id="1494">Computer Software</category>
        <category parent_id="1494" id="1499">Spreadsheets</category>
      </category-hierarchy>
      <comment-count>0</comment-count>
      <thumbnail-url>http://img.howcast.com/system/thumbnails/67671/75_xxlarge_maintained_aspect.jpg</thumbnail-url>
      <permalink>http://www.howcast.com/videos/67671-Episode-879-Icon-Sets-II</permalink>
    </video>
    <video>
      <category-id>1499</category-id>
      <id>66610</id>
      <title>Episode 878 - Pivot Formula Functions</title>
      <type nil="true"></type>
      <views>47</views>
      <created-at>Wed, 29 Oct 2008 20:01:14 -0700</created-at>
      <rating>1</rating>
      <username>mrexcel</username>
      <description>
        <![CDATA[Can you use a function in an Excel calculated field? Well, Bryony from the U.K. says yes you can, and sure enough...it works. &lt;a href="http://mrexcel.libsyn.com/media/mrexcel/podcast878.mp4"&gt;Episode 878&lt;/a&gt; shows an example of using a function to create a new fie]]>
      </description>
      <embed>
        <![CDATA[<object width="425" height="352" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="howcastplayer"><param name="movie" value="http://www.howcast.com/flash/howcast_player.swf?file=66610"></param><param name="allowFullScreen" value="true"></param><param name="allowScriptAccess" value="always"></param><embed src="http://www.howcast.com/flash/howcast_player.swf?file=66610" type="application/x-shockwave-flash" width="425" height="352" allowFullScreen="true" allowScriptAccess="always" ></embed></object>]]>
      </embed>
      <duration>192</duration>
      <filename>http://media.howcast.com/system/videos/5/10/66/06/66610.flv</filename>
      <tags>Excel, business, accounting, spreadsheets, technology, MrExcel, pivot table, calculation, function, tutorial</tags>
      <category-hierarchy>
        <category id="1470">Technology</category>
        <category parent_id="1470" id="1494">Computer Software</category>
        <category parent_id="1494" id="1499">Spreadsheets</category>
      </category-hierarchy>
      <comment-count>0</comment-count>
      <thumbnail-url>http://img.howcast.com/system/thumbnails/66610/95_xxlarge_maintained_aspect.jpg</thumbnail-url>
      <permalink>http://www.howcast.com/videos/66610-Episode-878-Pivot-Formula-Functions</permalink>
    </video>
    <video>
      <category-id>1499</category-id>
      <id>64054</id>
      <title>Episode 877 - Paste Values VII</title>
      <type nil="true"></type>
      <views>19</views>
      <created-at>Tue, 28 Oct 2008 20:01:48 -0700</created-at>
      <rating>1</rating>
      <username>mrexcel</username>
      <description>
        <![CDATA[Seven ways to paste values in Excel. While I talk about many ways to
convert formulas to values, Don from Orrville has come up with a method
shorter than the other 6 methods I usually discuss. So...drumroll
please... &lt;a href="http://mrexcel.libsyn.com/media/mrexcel/pod]]>
      </description>
      <embed>
        <![CDATA[<object width="425" height="352" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="howcastplayer"><param name="movie" value="http://www.howcast.com/flash/howcast_player.swf?file=64054"></param><param name="allowFullScreen" value="true"></param><param name="allowScriptAccess" value="always"></param><embed src="http://www.howcast.com/flash/howcast_player.swf?file=64054" type="application/x-shockwave-flash" width="425" height="352" allowFullScreen="true" allowScriptAccess="always" ></embed></object>]]>
      </embed>
      <duration>239</duration>
      <filename>http://media.howcast.com/system/videos/4/54/40/06/64054.flv</filename>
      <tags>Excel, business, accounting, spreadsheets, technology, MrExcel, tutorial, paste special</tags>
      <category-hierarchy>
        <category id="1470">Technology</category>
        <category parent_id="1470" id="1494">Computer Software</category>
        <category parent_id="1494" id="1499">Spreadsheets</category>
      </category-hierarchy>
      <comment-count>0</comment-count>
      <thumbnail-url>http://img.howcast.com/system/thumbnails/64054/115_xxlarge_maintained_aspect.jpg</thumbnail-url>
      <permalink>http://www.howcast.com/videos/64054-Episode-877-Paste-Values-VII</permalink>
    </video>
    <video>
      <category-id>1499</category-id>
      <id>64053</id>
      <title>Webinar and Survey</title>
      <type nil="true"></type>
      <views>11</views>
      <created-at>Tue, 28 Oct 2008 20:01:48 -0700</created-at>
      <rating>1</rating>
      <username>mrexcel</username>
      <description>
        <![CDATA[A mid-day &lt;a href="http://mrexcel.libsyn.com/media/mrexcel/podcast877a.mp4"&gt;podcast&lt;/a&gt; to invite you to a free &lt;a href="http://www.mrexcel.com/webinar.html"&gt;Excel webinar&lt;/a&gt; on Thursday, October 30, 2008 and also to invite you to provide feedback on]]>
      </description>
      <embed>
        <![CDATA[<object width="425" height="352" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="howcastplayer"><param name="movie" value="http://www.howcast.com/flash/howcast_player.swf?file=64053"></param><param name="allowFullScreen" value="true"></param><param name="allowScriptAccess" value="always"></param><embed src="http://www.howcast.com/flash/howcast_player.swf?file=64053" type="application/x-shockwave-flash" width="425" height="352" allowFullScreen="true" allowScriptAccess="always" ></embed></object>]]>
      </embed>
      <duration>131</duration>
      <filename>http://media.howcast.com/system/videos/3/53/40/06/64053.flv</filename>
      <tags>Excel, Webinar</tags>
      <category-hierarchy>
        <category id="1470">Technology</category>
        <category parent_id="1470" id="1494">Computer Software</category>
        <category parent_id="1494" id="1499">Spreadsheets</category>
      </category-hierarchy>
      <comment-count>0</comment-count>
      <thumbnail-url>http://img.howcast.com/system/thumbnails/64053/65_xxlarge_maintained_aspect.jpg</thumbnail-url>
      <permalink>http://www.howcast.com/videos/64053-Webinar-and-Survey</permalink>
    </video>
    <video>
      <category-id>1499</category-id>
      <id>62015</id>
      <title>Episode 876 - Cartesian Grid</title>
      <type nil="true"></type>
      <views>38</views>
      <created-at>Mon, 27 Oct 2008 20:01:23 -0700</created-at>
      <rating>1</rating>
      <username>mrexcel</username>
      <description>
        <![CDATA[Rodney is trying to label a Cartesian grid in Excel. This is a cool
idea - Excel is really the world's largest sheet of graph paper, but
the labels for the Cartesian grids aren't working well. In &lt;a href="http://mrexcel.libsyn.com/media/mrexcel/podcast876.mp4"&gt;Episod]]>
      </description>
      <embed>
        <![CDATA[<object width="425" height="352" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="howcastplayer"><param name="movie" value="http://www.howcast.com/flash/howcast_player.swf?file=62015"></param><param name="allowFullScreen" value="true"></param><param name="allowScriptAccess" value="always"></param><embed src="http://www.howcast.com/flash/howcast_player.swf?file=62015" type="application/x-shockwave-flash" width="425" height="352" allowFullScreen="true" allowScriptAccess="always" ></embed></object>]]>
      </embed>
      <duration>311</duration>
      <filename>http://media.howcast.com/system/videos/2/15/20/06/62015.flv</filename>
      <tags>Excel, business, accounting, spreadsheets, technology, MrExcel, drawing, tutorial</tags>
      <category-hierarchy>
        <category id="1470">Technology</category>
        <category parent_id="1470" id="1494">Computer Software</category>
        <category parent_id="1494" id="1499">Spreadsheets</category>
      </category-hierarchy>
      <comment-count>0</comment-count>
      <thumbnail-url>http://img.howcast.com/system/thumbnails/62015/155_xxlarge_maintained_aspect.jpg</thumbnail-url>
      <permalink>http://www.howcast.com/videos/62015-Episode-876-Cartesian-Grid</permalink>
    </video>
    <video>
      <category-id>1499</category-id>
      <id>60172</id>
      <title>Episode 875 - Conditional Pivot Formatting</title>
      <type nil="true"></type>
      <views>53</views>
      <created-at>Fri, 24 Oct 2008 20:01:50 -0700</created-at>
      <rating>1</rating>
      <username>mrexcel</username>
      <description>
        <![CDATA[Neville from Germany sends in a good suggestion for overcoming pivot
formatting problems from Episode 865. By using conditional formatting
on the underlying worksheet, Neville comes up with a way to make sure
that the total rows are always highlighted in a pivot table. &l]]>
      </description>
      <embed>
        <![CDATA[<object width="425" height="352" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="howcastplayer"><param name="movie" value="http://www.howcast.com/flash/howcast_player.swf?file=60172"></param><param name="allowFullScreen" value="true"></param><param name="allowScriptAccess" value="always"></param><embed src="http://www.howcast.com/flash/howcast_player.swf?file=60172" type="application/x-shockwave-flash" width="425" height="352" allowFullScreen="true" allowScriptAccess="always" ></embed></object>]]>
      </embed>
      <duration>236</duration>
      <filename>http://media.howcast.com/system/videos/0/72/01/06/60172.flv</filename>
      <tags>Excel, business, accounting, spreadsheets, technology, MrExcel, pivot table, conditional formatting, tutorial, Formatting</tags>
      <category-hierarchy>
        <category id="1470">Technology</category>
        <category parent_id="1470" id="1494">Computer Software</category>
        <category parent_id="1494" id="1499">Spreadsheets</category>
      </category-hierarchy>
      <comment-count>0</comment-count>
      <thumbnail-url>http://img.howcast.com/system/thumbnails/60172/115_xxlarge_maintained_aspect.jpg</thumbnail-url>
      <permalink>http://www.howcast.com/videos/60172-Episode-875-Conditional-Pivot-Formatting</permalink>
    </video>
    <video>
      <category-id>1499</category-id>
      <id>59812</id>
      <title>Episode 874 - in-Cell Editing Woes</title>
      <type nil="true"></type>
      <views>7</views>
      <created-at>Thu, 23 Oct 2008 20:01:30 -0700</created-at>
      <rating>1</rating>
      <username>mrexcel</username>
      <description>
        <![CDATA[After watching Episode 859, Tom from the U.K. pointed out that the problems go away if you turn off in-cell editing. &lt;a href="http://mrexcel.libsyn.com/media/mrexcel/podcast874.mp4"&gt;Episode 874&lt;/a&gt; shows the benefits of turning off in-cell editing.&lt;br/&gt;&lt;]]>
      </description>
      <embed>
        <![CDATA[<object width="425" height="352" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="howcastplayer"><param name="movie" value="http://www.howcast.com/flash/howcast_player.swf?file=59812"></param><param name="allowFullScreen" value="true"></param><param name="allowScriptAccess" value="always"></param><embed src="http://www.howcast.com/flash/howcast_player.swf?file=59812" type="application/x-shockwave-flash" width="425" height="352" allowFullScreen="true" allowScriptAccess="always" ></embed></object>]]>
      </embed>
      <duration>134</duration>
      <filename>http://media.howcast.com/system/videos/4/12/98/05/59812.flv</filename>
      <tags>Excel, business, accounting, spreadsheets, technology, MrExcel, tutorial, editing</tags>
      <category-hierarchy>
        <category id="1470">Technology</category>
        <category parent_id="1470" id="1494">Computer Software</category>
        <category parent_id="1494" id="1499">Spreadsheets</category>
      </category-hierarchy>
      <comment-count>0</comment-count>
      <thumbnail-url>http://img.howcast.com/system/thumbnails/59812/65_xxlarge_maintained_aspect.jpg</thumbnail-url>
      <permalink>http://www.howcast.com/videos/59812-Episode-874-inCell-Editing-Woes</permalink>
    </video>
    <video>
      <category-id>1499</category-id>
      <id>55413</id>
      <title>Episode 873 - First Macro</title>
      <type nil="true"></type>
      <views>44</views>
      <created-at>Wed, 22 Oct 2008 20:01:49 -0700</created-at>
      <rating>1</rating>
      <username>mrexcel</username>
      <description>
        <![CDATA[Rick asks how to get started with VBA. In &lt;a href="http://mrexcel.libsyn.com/media/mrexcel/podcast873.mp4"&gt;Episode 873&lt;/a&gt;,
I show a horribly formatted file that someone in my Power Excel
audience has to deal with daily. A macro seems like a good way to deal
w]]>
      </description>
      <embed>
        <![CDATA[<object width="425" height="352" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="howcastplayer"><param name="movie" value="http://www.howcast.com/flash/howcast_player.swf?file=55413"></param><param name="allowFullScreen" value="true"></param><param name="allowScriptAccess" value="always"></param><embed src="http://www.howcast.com/flash/howcast_player.swf?file=55413" type="application/x-shockwave-flash" width="425" height="352" allowFullScreen="true" allowScriptAccess="always" ></embed></object>]]>
      </embed>
      <duration>308</duration>
      <filename>http://media.howcast.com/system/videos/1/13/54/05/55413.flv</filename>
      <tags>Excel, business, accounting, spreadsheets, technology, MrExcel, VBA, tutorial</tags>
      <category-hierarchy>
        <category id="1470">Technology</category>
        <category parent_id="1470" id="1494">Computer Software</category>
        <category parent_id="1494" id="1499">Spreadsheets</category>
      </category-hierarchy>
      <comment-count>0</comment-count>
      <thumbnail-url>http://img.howcast.com/system/thumbnails/55413/150_xxlarge_maintained_aspect.jpg</thumbnail-url>
      <permalink>http://www.howcast.com/videos/55413-Episode-873-First-Macro</permalink>
    </video>
    <video>
      <category-id>1499</category-id>
      <id>55163</id>
      <title>Episode 872 - VLOOKUP Not Working</title>
      <type nil="true"></type>
      <views>237</views>
      <created-at>Tue, 21 Oct 2008 20:01:45 -0700</created-at>
      <rating>1</rating>
      <username>mrexcel</username>
      <description>
        <![CDATA[Janet wonders why her VLOOKUPs are not working in certain cases. If
your key field contains a mix of numbers and text that looks like
numbers, then the VLOOKUP won't work. &lt;a href="http://mrexcel.libsyn.com/media/mrexcel/podcast872.mp4"&gt;Episode 872&lt;/a&gt; shows ho]]>
      </description>
      <embed>
        <![CDATA[<object width="425" height="352" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="howcastplayer"><param name="movie" value="http://www.howcast.com/flash/howcast_player.swf?file=55163"></param><param name="allowFullScreen" value="true"></param><param name="allowScriptAccess" value="always"></param><embed src="http://www.howcast.com/flash/howcast_player.swf?file=55163" type="application/x-shockwave-flash" width="425" height="352" allowFullScreen="true" allowScriptAccess="always" ></embed></object>]]>
      </embed>
      <duration>214</duration>
      <filename>http://media.howcast.com/system/videos/3/63/51/05/55163.flv</filename>
      <tags>Excel, business, accounting, spreadsheets, technology, MrExcel, VLOOKUP, custom format, tutorial</tags>
      <category-hierarchy>
        <category id="1470">Technology</category>
        <category parent_id="1470" id="1494">Computer Software</category>
        <category parent_id="1494" id="1499">Spreadsheets</category>
      </category-hierarchy>
      <comment-count>0</comment-count>
      <thumbnail-url>http://img.howcast.com/system/thumbnails/55163/105_xxlarge_maintained_aspect.jpg</thumbnail-url>
      <permalink>http://www.howcast.com/videos/55163-Episode-872-VLOOKUP-Not-Working</permalink>
    </video>
    <video>
      <category-id>1499</category-id>
      <id>54880</id>
      <title>Episode 871 - Finding Dates</title>
      <type nil="true"></type>
      <views>37</views>
      <created-at>Mon, 20 Oct 2008 20:01:53 -0700</created-at>
      <rating>1</rating>
      <username>mrexcel</username>
      <description>
        <![CDATA[Someone tried to record a macro to find the records from a certain
date. Since finding dates requires the date format to match exactly, a
better way to go would be using Advanced Filter. In &lt;a href="http://mrexcel.libsyn.com/media/mrexcel/podcast871.mp4"&gt;Episode 871&]]>
      </description>
      <embed>
        <![CDATA[<object width="425" height="352" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="howcastplayer"><param name="movie" value="http://www.howcast.com/flash/howcast_player.swf?file=54880"></param><param name="allowFullScreen" value="true"></param><param name="allowScriptAccess" value="always"></param><embed src="http://www.howcast.com/flash/howcast_player.swf?file=54880" type="application/x-shockwave-flash" width="425" height="352" allowFullScreen="true" allowScriptAccess="always" ></embed></object>]]>
      </embed>
      <duration>230</duration>
      <filename>http://media.howcast.com/system/videos/0/80/48/05/54880.flv</filename>
      <tags>Excel, business, accounting, spreadsheets, technology, MrExcel, VBA, Advanced Filter, tutorial</tags>
      <category-hierarchy>
        <category id="1470">Technology</category>
        <category parent_id="1470" id="1494">Computer Software</category>
        <category parent_id="1494" id="1499">Spreadsheets</category>
      </category-hierarchy>
      <comment-count>0</comment-count>
      <thumbnail-url>http://img.howcast.com/system/thumbnails/54880/115_xxlarge_maintained_aspect.jpg</thumbnail-url>
      <permalink>http://www.howcast.com/videos/54880-Episode-871-Finding-Dates</permalink>
    </video>
    <video>
      <category-id>1499</category-id>
      <id>54121</id>
      <title>Episode 870 - GetPivotData</title>
      <type nil="true"></type>
      <views>96</views>
      <created-at>Fri, 17 Oct 2008 20:01:40 -0700</created-at>
      <rating>1</rating>
      <username>mrexcel</username>
      <description>
        <![CDATA[You could solve yesterday's podcast using the often-cursed-at, but seldom-understood GETPIVOTDATA function. In &lt;a href="http://mrexcel.libsyn.com/media/mrexcel/podcast870.mp4"&gt;Episode 870&lt;/a&gt;, how to use GETPIVOTDATA to return the grand total and also using =IF(I]]>
      </description>
      <embed>
        <![CDATA[<object width="425" height="352" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="howcastplayer"><param name="movie" value="http://www.howcast.com/flash/howcast_player.swf?file=54121"></param><param name="allowFullScreen" value="true"></param><param name="allowScriptAccess" value="always"></param><embed src="http://www.howcast.com/flash/howcast_player.swf?file=54121" type="application/x-shockwave-flash" width="425" height="352" allowFullScreen="true" allowScriptAccess="always" ></embed></object>]]>
      </embed>
      <duration>194</duration>
      <filename>http://media.howcast.com/system/videos/4/21/41/05/54121.flv</filename>
      <tags>Excel, business, accounting, spreadsheets, technology, MrExcel, GetPivotData, ISBLANK, tutorial, pivot table</tags>
      <category-hierarchy>
        <category id="1470">Technology</category>
        <category parent_id="1470" id="1494">Computer Software</category>
        <category parent_id="1494" id="1499">Spreadsheets</category>
      </category-hierarchy>
      <comment-count>0</comment-count>
      <thumbnail-url>http://img.howcast.com/system/thumbnails/54121/95_xxlarge_maintained_aspect.jpg</thumbnail-url>
      <permalink>http://www.howcast.com/videos/54121-Episode-870-GetPivotData</permalink>
    </video>
    <video>
      <category-id>1499</category-id>
      <id>53707</id>
      <title>Episode 869 - Final Pivot Row?</title>
      <type nil="true"></type>
      <views>25</views>
      <created-at>Thu, 16 Oct 2008 20:01:37 -0700</created-at>
      <rating>1</rating>
      <username>mrexcel</username>
      <description>
        <![CDATA[Richard is building a formula outside of the pivot table that needs to divide by the grand total of the pivot table. In &lt;a href="http://mrexcel.libsyn.com/media/mrexcel/podcast869.mp4"&gt;Episode 869&lt;/a&gt;, I show two solutions, one of which is an incredibly geeky use]]>
      </description>
      <embed>
        <![CDATA[<object width="425" height="352" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="howcastplayer"><param name="movie" value="http://www.howcast.com/flash/howcast_player.swf?file=53707"></param><param name="allowFullScreen" value="true"></param><param name="allowScriptAccess" value="always"></param><embed src="http://www.howcast.com/flash/howcast_player.swf?file=53707" type="application/x-shockwave-flash" width="425" height="352" allowFullScreen="true" allowScriptAccess="always" ></embed></object>]]>
      </embed>
      <duration>228</duration>
      <filename>http://media.howcast.com/system/videos/3/07/37/05/53707.flv</filename>
      <tags>Excel, business, accounting, spreadsheets, technology, MrExcel, pivot table, formula, tutorial</tags>
      <category-hierarchy>
        <category id="1470">Technology</category>
        <category parent_id="1470" id="1494">Computer Software</category>
        <category parent_id="1494" id="1499">Spreadsheets</category>
      </category-hierarchy>
      <comment-count>0</comment-count>
      <thumbnail-url>http://img.howcast.com/system/thumbnails/53707/110_xxlarge_maintained_aspect.jpg</thumbnail-url>
      <permalink>http://www.howcast.com/videos/53707-Episode-869-Final-Pivot-Row</permalink>
    </video>
    <video>
      <category-id>1499</category-id>
      <id>53432</id>
      <title>Episode 868 - Clearing Input Cells</title>
      <type nil="true"></type>
      <views>15</views>
      <created-at>Wed, 15 Oct 2008 20:01:27 -0700</created-at>
      <rating>1</rating>
      <username>mrexcel</username>
      <description>
        <![CDATA[Donna from Colorado asks how to clear all of the input cells from a model. In today's Where Is It Wednesday &lt;a href="http://mrexcel.libsyn.com/media/mrexcel/podcast868.mp4"&gt;Episode 868&lt;/a&gt;,
we take a look at how to select only the numeric constants. Also -
foll]]>
      </description>
      <embed>
        <![CDATA[<object width="425" height="352" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="howcastplayer"><param name="movie" value="http://www.howcast.com/flash/howcast_player.swf?file=53432"></param><param name="allowFullScreen" value="true"></param><param name="allowScriptAccess" value="always"></param><embed src="http://www.howcast.com/flash/howcast_player.swf?file=53432" type="application/x-shockwave-flash" width="425" height="352" allowFullScreen="true" allowScriptAccess="always" ></embed></object>]]>
      </embed>
      <duration>194</duration>
      <filename>http://media.howcast.com/system/videos/1/32/34/05/53432.flv</filename>
      <tags>Excel, business, accounting, spreadsheets, technology, MrExcel, tutorial, Formatting</tags>
      <category-hierarchy>
        <category id="1470">Technology</category>
        <category parent_id="1470" id="1494">Computer Software</category>
        <category parent_id="1494" id="1499">Spreadsheets</category>
      </category-hierarchy>
      <comment-count>0</comment-count>
      <thumbnail-url>http://img.howcast.com/system/thumbnails/53432/95_xxlarge_maintained_aspect.jpg</thumbnail-url>
      <permalink>http://www.howcast.com/videos/53432-Episode-868-Clearing-Input-Cells</permalink>
    </video>
    <video>
      <category-id>1499</category-id>
      <id>52912</id>
      <title>Episode 867 - Fill Across Sheets</title>
      <type nil="true"></type>
      <views>76</views>
      <created-at>Tue, 14 Oct 2008 20:01:29 -0700</created-at>
      <rating>2</rating>
      <username>mrexcel</username>
      <description>
        <![CDATA[If you need to make an exact copy of formulas, you can use the method from episode 866 or this Fill Across Worksheets solution. &lt;a href="http://mrexcel.libsyn.com/media/mrexcel/podcast867.mp4"&gt;Episode 867&lt;/a&gt; shows you how.&lt;br/&gt;&lt;br/&gt;This blog is the v]]>
      </description>
      <embed>
        <![CDATA[<object width="425" height="352" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="howcastplayer"><param name="movie" value="http://www.howcast.com/flash/howcast_player.swf?file=52912"></param><param name="allowFullScreen" value="true"></param><param name="allowScriptAccess" value="always"></param><embed src="http://www.howcast.com/flash/howcast_player.swf?file=52912" type="application/x-shockwave-flash" width="425" height="352" allowFullScreen="true" allowScriptAccess="always" ></embed></object>]]>
      </embed>
      <duration>146</duration>
      <filename>http://media.howcast.com/system/videos/6/12/29/05/52912.flv</filename>
      <tags>Excel, business, accounting, spreadsheets, technology, MrExcel, Formulas, tutorial</tags>
      <category-hierarchy>
        <category id="1470">Technology</category>
        <category parent_id="1470" id="1494">Computer Software</category>
        <category parent_id="1494" id="1499">Spreadsheets</category>
      </category-hierarchy>
      <comment-count>0</comment-count>
      <thumbnail-url>http://img.howcast.com/system/thumbnails/52912/70_xxlarge_maintained_aspect.jpg</thumbnail-url>
      <permalink>http://www.howcast.com/videos/52912-Episode-867-Fill-Across-Sheets</permalink>
    </video>
    <video>
      <category-id>1499</category-id>
      <id>51176</id>
      <title>Episode 866 - Exact Formula Copy</title>
      <type nil="true"></type>
      <views>43</views>
      <created-at>Mon, 13 Oct 2008 20:01:31 -0700</created-at>
      <rating>1</rating>
      <username>mrexcel</username>
      <description>
        <![CDATA[Markus from Germany sends in this tip. Say that you have to make an
exact copy of a range of formulas. It is like you need to do a CUT and
PASTE, but also leave the original cells where they were. Normally, a
Copy and Paste will rewrite the formulas. Using this trick from]]>
      </description>
      <embed>
        <![CDATA[<object width="425" height="352" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="howcastplayer"><param name="movie" value="http://www.howcast.com/flash/howcast_player.swf?file=51176"></param><param name="allowFullScreen" value="true"></param><param name="allowScriptAccess" value="always"></param><embed src="http://www.howcast.com/flash/howcast_player.swf?file=51176" type="application/x-shockwave-flash" width="425" height="352" allowFullScreen="true" allowScriptAccess="always" ></embed></object>]]>
      </embed>
      <duration>105</duration>
      <filename>http://media.howcast.com/system/videos/6/76/11/05/51176.flv</filename>
      <tags>Excel, business, accounting, spreadsheets, technology, MrExcel, Formulas, tutorial</tags>
      <category-hierarchy>
        <category id="1470">Technology</category>
        <category parent_id="1470" id="1494">Computer Software</category>
        <category parent_id="1494" id="1499">Spreadsheets</category>
      </category-hierarchy>
      <comment-count>0</comment-count>
      <thumbnail-url>http://img.howcast.com/system/thumbnails/51176/50_xxlarge_maintained_aspect.jpg</thumbnail-url>
      <permalink>http://www.howcast.com/videos/51176-Episode-866-Exact-Formula-Copy</permalink>
    </video>
  </videos>
</howcast>
