Percentage Change from First to Last Value of a Given Date

M

mlarson

Well-known Member
Joined
Aug 25, 2011
Messages
509
Office Version
  1. 2010
Platform
  1. Windows
<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:EnableOpenTypeKerning/> <w:DontFlipMirrorIndents/> <w:OverrideTableStyleHps/> </w:Compatibility> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true" DefSemiHidden="true" DefQFormat="false" DefPriority="99" LatentStyleCount="267"> <w:LsdException Locked="false" Priority="0" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" Priority="39" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" Name="toc 9"/> <w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/> <w:LsdException Locked="false" Priority="10" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Title"/> <w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/> <w:LsdException Locked="false" Priority="11" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" Priority="22" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" Priority="59" SemiHidden="false" UnhideWhenUsed="false" Name="Table Grid"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/> <w:LsdException Locked="false" Priority="34" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} </style> <![endif]--> Hi there, I am trying to figure out how to calculate the percentage change from the first price (column J) of a particular date (column B) to the last price of the same date, with the output in Column P.

For example, the first entry for 8/6/10 (cell B3) is 5.20 (cell J3) and the last is 4.68 (cell J6) with the output of -10.00% (cell P3). Another example, the first entry for 8/7/10 (cell B7) is 5.32 (cell J7) and the last is 3.40 (cell J12) with the output of -36.09% (cell P7).

Do you know of a macro that can do this task? Thanks so much!


<table border="0" cellpadding="0" cellspacing="0" width="1125"><col style="width: 48pt;" width="64"> <col style="width: 58pt;" width="77"> <col style="width: 48pt;" width="64"> <col style="width: 58pt;" width="77"> <col style="width: 48pt;" width="64" span="11"> <col style="width: 104pt;" width="139"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 48pt;" width="64" height="20">A</td> <td class="xl64" style="border-left: medium none; width: 58pt;" width="77">B</td> <td class="xl64" style="border-left: medium none; width: 48pt;" width="64">C</td> <td class="xl64" style="border-left: medium none; width: 58pt;" width="77">D</td> <td class="xl64" style="border-left: medium none; width: 48pt;" width="64">E</td> <td class="xl64" style="border-left: medium none; width: 48pt;" width="64">F</td> <td class="xl64" style="border-left: medium none; width: 48pt;" width="64">G</td> <td class="xl64" style="border-left: medium none; width: 48pt;" width="64">H</td> <td class="xl64" style="border-left: medium none; width: 48pt;" width="64">I</td> <td class="xl64" style="border-left: medium none; width: 48pt;" width="64">J</td> <td class="xl64" style="border-left: medium none; width: 48pt;" width="64">K</td> <td class="xl64" style="border-left: medium none; width: 48pt;" width="64">L</td> <td class="xl64" style="border-left: medium none; width: 48pt;" width="64">M</td> <td class="xl64" style="border-left: medium none; width: 48pt;" width="64">N</td> <td class="xl64" style="border-left: medium none; width: 48pt;" width="64">O</td> <td class="xl64" style="border-left: medium none; width: 104pt;" width="139">P</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">2</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">Date</td> <td class="xl64" style="border-top: medium none; border-left: medium none;">Time</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;">Price</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;">Percentage (Output)</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">3</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">8/6/2010</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">11:00</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl67" style="border-top: medium none; border-left: medium none;">5.20</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl68" style="border-top: medium none; border-left: medium none;">-10.00%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">4</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">8/6/2010</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">11:01</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl67" style="border-top: medium none; border-left: medium none;">5.59</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl68" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">5</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">8/6/2010</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">11:02</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl67" style="border-top: medium none; border-left: medium none;">4.98</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl68" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">6</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">8/6/2010</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">11:03</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl67" style="border-top: medium none; border-left: medium none;">4.68</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl68" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">7</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">8/7/2010</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">11:00</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl67" style="border-top: medium none; border-left: medium none;">5.32</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl68" style="border-top: medium none; border-left: medium none;">-36.09%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">8</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">8/7/2010</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">11:01</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl67" style="border-top: medium none; border-left: medium none;">5.45</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl68" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">9</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">8/7/2010</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">11:02</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl67" style="border-top: medium none; border-left: medium none;">5.40</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl68" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">10</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">8/7/2010</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">11:03</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl67" style="border-top: medium none; border-left: medium none;">5.20</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl68" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">11</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">8/7/2010</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">11:04</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl67" style="border-top: medium none; border-left: medium none;">4.75</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl68" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">12</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">8/7/2010</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">11:05</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl67" style="border-top: medium none; border-left: medium none;">3.40</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl68" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">13</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">8/8/2010</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">11:00</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl67" style="border-top: medium none; border-left: medium none;">3.50</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl68" style="border-top: medium none; border-left: medium none;">12.29%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">14</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">8/8/2010</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">11:01</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl67" style="border-top: medium none; border-left: medium none;">3.43</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl68" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">15</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">8/8/2010</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">11:02</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl67" style="border-top: medium none; border-left: medium none;">4.10</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl68" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">16</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">8/8/2010</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">11:03</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl67" style="border-top: medium none; border-left: medium none;">3.25</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl68" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">17</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">8/8/2010</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">11:04</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl67" style="border-top: medium none; border-left: medium none;">3.95</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl68" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">18</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">8/8/2010</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">11:05</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl67" style="border-top: medium none; border-left: medium none;">4.20</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl68" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">19</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">8/8/2010</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">11:06</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl67" style="border-top: medium none; border-left: medium none;">3.85</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl68" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; border-top: medium none;" height="20">20</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">8/8/2010</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">11:07</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl67" style="border-top: medium none; border-left: medium none;">3.93</td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl64" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl68" style="border-top: medium none; border-left: medium none;"> </td> </tr> </tbody></table>
 
Sort by date Sort by votes
In this situation , I don't know the answer !!.
Perhaps you could try running the code twice to cover the total of 150,000 rows.
Copy the code and set the range variable "Rng " to half the rows in each
i.e :- [Set rng = Range("B1:B75000") and similarly for the other half of the rows.
See if this creates an error.
 
Upvote 0

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Thank you, Mick. I will try that out. Appreciate your help!
 
Upvote 0
mlarson said:
I entered the formula and used macro recorder to come up with the code below, and it worked so thanks for that! However, what would I need to change in the macro to make it dynamic (that is, to automatically find the last value in a column instead of the arbitrary number of 200,000 that I have entered)? Thanks.

Code: 
  Sub Macro352()
  '
 
    Windows("Workbook1.xlsm").Activate
    Range("P3").Select
      ActiveCell.FormulaR1C1 = _
          "=IF(RC[-14]=R[-1]C[-14],"""",VLOOKUP(RC[-14],R[-1]C[-14]:R[149998]C[-6],9)/RC[-6]-1)"
      Range("P3").Select
      Selection.AutoFill Destination:=Range("P3:P200000"), Type:=xlFillDefault
 
 
End Sub
Click to expand...

Either...

=IF(B3=B2, "", VLOOKUP(B3, B:J, 9, 1)/J3-1)

Or...

=IF(B3=B2, "", LOOKUP(B3, B:B, J:J)/J3-1)

as long as the dates are in ascending order.
 
Upvote 0
Hi MickG, Aladin, and shg (or anybody else that wants to help),

If I wanted to find the Log Change (instead of the percentage change) of the first and last values of a given date, how would that change the code/formula?

Thanks!
Mark
 
Upvote 0
mlarson said:
Hi MickG, Aladin, and shg (or anybody else that wants to help),

If I wanted to find the Log Change (instead of the percentage change) of the first and last values of a given date, how would that change the code/formula?

Thanks!
Mark
Click to expand...

Would you explain what you mean by "Log Change"?
 
Upvote 0
Let's say I want the log change between cells A5 and B5, the formula would be =LN(A5/B5).
 
Upvote 0
It keeps giving me a #NUM! error. Any reasons on why that might be? Thanks.
 
Upvote 0
The problem was the "-1" at the end of the equation... made sense for me to use that with finding percentage but not for finding LN. Thank you so much for your help as it is working very well!
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Question
Select the time from the list and search with Selenium VBA
Replies
6
Views
245
John_w
J
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
1K
CrashOD
C
E
  • Question
VBA for Web Scraping help
Replies
0
Views
606
epactheactor
E
A
  • Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
1K
Attrazion
A
D
  • Question
Problems Encountered When Generating VBA Excel Charts with 15-Minute Interval Data.
Replies
0
Views
172
dilshod_k
D

Forum statistics

Threads
1,215,503
Messages
6,125,179
Members
449,212
Latest member
kenmaldonado

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top