Finding highest drop in value

C

capex

New Member
Joined
Apr 18, 2009
Messages
44
I need some help to automate process of finding largest drop percentages in a series based on following criteria:

1. These two columns represent S&P 500 value for last few months.
2. I am trying to find out highest drop in the series.
3. Drop in value starts if value is lower than previous day.
4. Drop in value stops as value goes up from previous day.
5. Example provided shows value drop in B3 from previous day B2, that event started the series and ended on B6 where value increased from previous day B5.
6. Highlighted cells is where drop started and ended with next day going up higher than previous day.
7. I am trying to find a formula which would find out
A. Each drop
B. Present only highest drop based on above mention conditions which is -11.18% from 8/3/2011 to 8/8/2011. Only interested in highest drop.
8. This series will continue daily as it unfolds, there could be many small drops along the way, want to see only highest one till another one goes higher than current one.

Thank you in advance for helping me out.

AD


<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">Date</td><td style=";">Adj Close</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">8/3/2011</td><td style="text-align: right;;">1260.34</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;">8/4/2011</td><td style="text-align: right;background-color: #FFFF00;;">1200.07</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;;">8/5/2011</td><td style="text-align: right;background-color: #FFFF00;;">1199.38</td><td style="text-align: right;;">-11.18%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;;">8/8/2011</td><td style="text-align: right;background-color: #FFFF00;;">1119.46</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: right;;">8/9/2011</td><td style="text-align: right;;">1172.53</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;">8/10/2011</td><td style="text-align: right;background-color: #FFFF00;;">1120.76</td><td style="text-align: right;;">-4.62%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;">8/11/2011</td><td style="text-align: right;;">1172.64</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: right;;">8/12/2011</td><td style="text-align: right;;">1178.81</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: right;;">8/15/2011</td><td style="text-align: right;;">1204.49</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="text-align: right;;">8/16/2011</td><td style="text-align: right;background-color: #FFFF00;;">1192.76</td><td style="text-align: right;;">-0.98%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="text-align: right;;">8/17/2011</td><td style="text-align: right;;">1193.89</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="text-align: right;;">8/18/2011</td><td style="text-align: right;background-color: #FFFF00;;">1140.65</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="text-align: right;;">8/19/2011</td><td style="text-align: right;background-color: #FFFF00;;">1123.53</td><td style="text-align: right;;">-6.26%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style="text-align: right;;">8/22/2011</td><td style="text-align: right;;">1123.82</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style="text-align: right;;">8/23/2011</td><td style="text-align: right;;">1162.35</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style="text-align: right;;">8/24/2011</td><td style="text-align: right;;">1177.6</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style="text-align: right;;">8/25/2011</td><td style="text-align: right;background-color: #FFFF00;;">1159.27</td><td style="text-align: right;;">-1.58%</td><td style="text-align: right;;"></td><td style=";">Highest</td></tr><tr ><td style="color: #161120;text-align: center;">19</td><td style="text-align: right;;">8/26/2011</td><td style="text-align: right;;">1176.8</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="background-color: #92D050;;">??</td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style="text-align: right;;">8/29/2011</td><td style="text-align: right;;">1210.08</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">21</td><td style="text-align: right;;">8/30/2011</td><td style="text-align: right;;">1212.92</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">22</td><td style="text-align: right;;">8/31/2011</td><td style="text-align: right;;">1218.89</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">23</td><td style="text-align: right;;">9/1/2011</td><td style="text-align: right;background-color: #FFFF00;;">1204.42</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">24</td><td style="text-align: right;;">9/2/2011</td><td style="text-align: right;background-color: #FFFF00;;">1173.97</td><td style="text-align: right;;">-4.60%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">25</td><td style="text-align: right;;">9/6/2011</td><td style="text-align: right;background-color: #FFFF00;;">1165.24</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">26</td><td style="text-align: right;;">9/7/2011</td><td style="text-align: right;;">1198.62</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">27</td><td style="text-align: right;;">9/8/2011</td><td style="text-align: right;background-color: #FFFF00;;">1185.9</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">28</td><td style="text-align: right;;">9/9/2011</td><td style="text-align: right;background-color: #FFFF00;;">1154.23</td><td style="text-align: right;;">-3.85%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">29</td><td style="text-align: right;;">9/12/2011</td><td style="text-align: right;;">1162.27</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">30</td><td style="text-align: right;;">9/13/2011</td><td style="text-align: right;;">1172.87</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">31</td><td style="text-align: right;;">9/14/2011</td><td style="text-align: right;;">1188.68</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">32</td><td style="text-align: right;;">9/15/2011</td><td style="text-align: right;;">1209.11</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">33</td><td style="text-align: right;;">9/16/2011</td><td style="text-align: right;;">1216.01</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">34</td><td style="text-align: right;;">9/19/2011</td><td style="text-align: right;background-color: #FFFF00;;">1204.09</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">35</td><td style="text-align: right;;">9/20/2011</td><td style="text-align: right;background-color: #FFFF00;;">1202.09</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">36</td><td style="text-align: right;;">9/21/2011</td><td style="text-align: right;background-color: #FFFF00;;">1166.76</td><td style="text-align: right;;">-7.65%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">37</td><td style="text-align: right;;">9/22/2011</td><td style="text-align: right;background-color: #FFFF00;;">1129.56</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">38</td><td style="text-align: right;;">9/23/2011</td><td style="text-align: right;;">1136.43</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">39</td><td style="text-align: right;;">9/26/2011</td><td style="text-align: right;;">1162.95</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">40</td><td style="text-align: right;;">9/27/2011</td><td style="text-align: right;;">1175.38</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">41</td><td style="text-align: right;;">9/28/2011</td><td style="text-align: right;background-color: #FFFF00;;">1151.06</td><td style="text-align: right;;">-2.11%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">42</td><td style="text-align: right;;">9/29/2011</td><td style="text-align: right;;">1160.4</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">43</td><td style="text-align: right;;">9/30/2011</td><td style="text-align: right;background-color: #FFFF00;;">1131.42</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">44</td><td style="text-align: right;;">10/3/2011</td><td style="text-align: right;background-color: #FFFF00;;">1099.23</td><td style="text-align: right;;">-5.56%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">45</td><td style="text-align: right;;">10/4/2011</td><td style="text-align: right;;">1123.95</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">46</td><td style="text-align: right;;">10/5/2011</td><td style="text-align: right;;">1144.03</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">47</td><td style="text-align: right;;">10/6/2011</td><td style="text-align: right;;">1164.97</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">48</td><td style="text-align: right;;">10/7/2011</td><td style="text-align: right;background-color: #FFFF00;;">1155.46</td><td style="text-align: right;;">-0.82%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">49</td><td style="text-align: right;;">10/10/2011</td><td style="text-align: right;;">1194.89</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">50</td><td style="text-align: right;;">10/11/2011</td><td style="text-align: right;;">1195.54</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">51</td><td style="text-align: right;;">10/12/2011</td><td style="text-align: right;;">1207.25</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">52</td><td style="text-align: right;;">10/13/2011</td><td style="text-align: right;background-color: #FFFF00;;">1203.66</td><td style="text-align: right;;">-0.30%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">53</td><td style="text-align: right;;">10/14/2011</td><td style="text-align: right;;">1224.58</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">54</td><td style="text-align: right;;">10/17/2011</td><td style="text-align: right;background-color: #FFFF00;;">1200.86</td><td style="text-align: right;;">-1.98%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">55</td><td style="text-align: right;;">10/18/2011</td><td style="text-align: right;;">1225.38</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">56</td><td style="text-align: right;;">10/19/2011</td><td style="text-align: right;background-color: #FFFF00;;">1209.88</td><td style="text-align: right;;">-1.28%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">57</td><td style="text-align: right;;">10/20/2011</td><td style="text-align: right;;">1215.39</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">58</td><td style="text-align: right;;">10/21/2011</td><td style="text-align: right;;">1238.25</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">59</td><td style="text-align: right;;">10/24/2011</td><td style="text-align: right;;">1254.19</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">60</td><td style="text-align: right;;">10/25/2011</td><td style="text-align: right;background-color: #FFFF00;;">1229.05</td><td style="text-align: right;;">-2.05%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">61</td><td style="text-align: right;;">10/26/2011</td><td style="text-align: right;;">1242</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">62</td><td style="text-align: right;;">10/27/2011</td><td style="text-align: right;;">1284.59</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">63</td><td style="text-align: right;;">10/28/2011</td><td style="text-align: right;;">1285.09</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">64</td><td style="text-align: right;;">10/31/2011</td><td style="text-align: right;;">1253.3</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">65</td><td style="text-align: right;;">11/1/2011</td><td style="text-align: right;background-color: #FFFF00;;">1218.28</td><td style="text-align: right;;">-2.87%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">66</td><td style="text-align: right;;">11/2/2011</td><td style="text-align: right;;">1237.9</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">67</td><td style="text-align: right;;">11/3/2011</td><td style="text-align: right;;">1261.15</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">68</td><td style="text-align: right;;">11/4/2011</td><td style="text-align: right;background-color: #FFFF00;;">1253.23</td><td style="text-align: right;;">-0.63%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet1</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C4</th><td style="text-align:left">=(<font color="Blue">B5-B2</font>)/B2</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C7</th><td style="text-align:left">=(<font color="Blue">B7-B6</font>)/B7</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C11</th><td style="text-align:left">=(<font color="Blue">B11-B10</font>)/B11</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C14</th><td style="text-align:left">=(<font color="Blue">B14-B12</font>)/B14</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C18</th><td style="text-align:left">=(<font color="Blue">B18-B17</font>)/B18</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C24</th><td style="text-align:left">=(<font color="Blue">B25-B22</font>)/B25</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C28</th><td style="text-align:left">=(<font color="Blue">B28-B26</font>)/B28</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C36</th><td style="text-align:left">=(<font color="Blue">B37-B33</font>)/B37</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C41</th><td style="text-align:left">=(<font color="Blue">B41-B40</font>)/B41</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C44</th><td style="text-align:left">=(<font color="Blue">B44-B42</font>)/B44</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C48</th><td style="text-align:left">=(<font color="Blue">B48-B47</font>)/B48</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C52</th><td style="text-align:left">=(<font color="Blue">B52-B51</font>)/B52</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C54</th><td style="text-align:left">=(<font color="Blue">B54-B53</font>)/B54</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C56</th><td style="text-align:left">=(<font color="Blue">B56-B55</font>)/B56</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C60</th><td style="text-align:left">=(<font color="Blue">B60-B59</font>)/B60</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C65</th><td style="text-align:left">=(<font color="Blue">B65-B64</font>)/B65</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C68</th><td style="text-align:left">=(<font color="Blue">B68-B67</font>)/B68</td></tr></tbody></table></td></tr></table><br />
 
Sort by date Sort by votes
capex said:
Hi, Peter,

Would like to know only highest drop start and end date in entire series. Which is -11.18% starts on 8/3 and ends on 8/8/2011. Thank you.
Click to expand...
I understand what the answer would be for the data you provided. My question was about what might happen with the data in the future.

Take the sample data below. The highest drop is -10%. However, that drop occurs twice (green cells).

So my previous question was, if that was the entire data, whether you would want reported
- both yellow and blue dates (all occurrances), or
- just yellow dates (first occurrance), or
- just blue dates (last occurrance), or
- simply the fact that there are multiple occurrances, or
- something else?

Excel Workbook
ABC
1DateAdj Close
203-Aug-201112000.00%
304-Aug-20111150
405-Aug-20111080-10.00%
508-Aug-20111130
609-Aug-201111400.00%
710-Aug-20111090-4.39%
811-Aug-201111000.00%
912-Aug-20111090
1015-Aug-20111070
1116-Aug-20111060
1217-Aug-20111040
1318-Aug-2011990-10.00%
1419-Aug-20111020
1522-Aug-201110300.00%
16
Biggest drop (2)
 
Upvote 0

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
capex said:
Just last occurrence, thank you. AD
Click to expand...
Try these.

Excel Workbook
ABCDE
1DateAdj CloseBiggest Drop:-10.00%
203-Aug-201112000.00%Start Date:11-Aug-2011
304-Aug-20111150 End Date:18-Aug-2011
405-Aug-20111080-10.00%
508-Aug-20111130
609-Aug-201111400.00%
710-Aug-20111090-4.39%
811-Aug-201111000.00%
912-Aug-20111090
1015-Aug-20111070
1116-Aug-20111060
1217-Aug-20111040
1318-Aug-2011990-10.00%
1419-Aug-20111020
1522-Aug-201110300.00%
Biggest drop + Dates
 
Upvote 0
Hi, CC,

Some how end date is incorrect it should be 10/3/2011 not 10/26/2011, not sure what I am doing wrong? Thanks.

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5" /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th><th>L</th><th>M</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">Date</td><td style=";">Adj Close</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">-12.78%</td><td style="text-align: right;;">8/3/2011</td><td style=";">Start Date</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">8/3/2011</td><td style="text-align: right;background-color: #FFFF00;;">1260.34</td><td style="text-align: right;;">1260.34</td><td style="text-align: right;;">1260.34</td><td style="text-align: right;;">1</td><td style="text-align: right;;">8/3/2011</td><td style="text-align: right;;">10/26/2011</td><td style="text-align: right;;">1099.23</td><td style="text-align: right;;">1260.34</td><td style="text-align: right;;">-12.78%</td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #FFFF00;;">10/26/2011</td><td style=";">End Date</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;">8/4/2011</td><td style="text-align: right;background-color: #FFFF00;;">1200.07</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;;">8/5/2011</td><td style="text-align: right;background-color: #FFFF00;;">1199.38</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;;">8/8/2011</td><td style="text-align: right;background-color: #FFFF00;;">1119.46</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: right;;">8/9/2011</td><td style="text-align: right;background-color: #FFFF00;;">1172.53</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;">8/10/2011</td><td style="text-align: right;background-color: #FFFF00;;">1120.76</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;">8/11/2011</td><td style="text-align: right;background-color: #FFFF00;;">1172.64</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: right;;">8/12/2011</td><td style="text-align: right;background-color: #FFFF00;;">1178.81</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: right;;">8/15/2011</td><td style="text-align: right;background-color: #FFFF00;;">1204.49</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="text-align: right;;">8/16/2011</td><td style="text-align: right;background-color: #FFFF00;;">1192.76</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="text-align: right;;">8/17/2011</td><td style="text-align: right;background-color: #FFFF00;;">1193.89</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="text-align: right;;">8/18/2011</td><td style="text-align: right;background-color: #FFFF00;;">1140.65</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="text-align: right;;">8/19/2011</td><td style="text-align: right;background-color: #FFFF00;;">1123.53</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style="text-align: right;;">8/22/2011</td><td style="text-align: right;background-color: #FFFF00;;">1123.82</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style="text-align: right;;">8/23/2011</td><td style="text-align: right;background-color: #FFFF00;;">1162.35</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style="text-align: right;;">8/24/2011</td><td style="text-align: right;background-color: #FFFF00;;">1177.6</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style="text-align: right;;">8/25/2011</td><td style="text-align: right;background-color: #FFFF00;;">1159.27</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">19</td><td style="text-align: right;;">8/26/2011</td><td style="text-align: right;background-color: #FFFF00;;">1176.8</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style="text-align: right;;">8/29/2011</td><td style="text-align: right;background-color: #FFFF00;;">1210.08</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">21</td><td style="text-align: right;;">8/30/2011</td><td style="text-align: right;background-color: #FFFF00;;">1212.92</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">22</td><td style="text-align: right;;">8/31/2011</td><td style="text-align: right;background-color: #FFFF00;;">1218.89</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">23</td><td style="text-align: right;;">9/1/2011</td><td style="text-align: right;background-color: #FFFF00;;">1204.42</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">24</td><td style="text-align: right;;">9/2/2011</td><td style="text-align: right;background-color: #FFFF00;;">1173.97</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">25</td><td style="text-align: right;;">9/6/2011</td><td style="text-align: right;background-color: #FFFF00;;">1165.24</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">26</td><td style="text-align: right;;">9/7/2011</td><td style="text-align: right;background-color: #FFFF00;;">1198.62</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">27</td><td style="text-align: right;;">9/8/2011</td><td style="text-align: right;background-color: #FFFF00;;">1185.9</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">28</td><td style="text-align: right;;">9/9/2011</td><td style="text-align: right;background-color: #FFFF00;;">1154.23</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">29</td><td style="text-align: right;;">9/12/2011</td><td style="text-align: right;background-color: #FFFF00;;">1162.27</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">30</td><td style="text-align: right;;">9/13/2011</td><td style="text-align: right;background-color: #FFFF00;;">1172.87</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">31</td><td style="text-align: right;;">9/14/2011</td><td style="text-align: right;background-color: #FFFF00;;">1188.68</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">32</td><td style="text-align: right;;">9/15/2011</td><td style="text-align: right;background-color: #FFFF00;;">1209.11</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">33</td><td style="text-align: right;;">9/16/2011</td><td style="text-align: right;background-color: #FFFF00;;">1216.01</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">34</td><td style="text-align: right;;">9/19/2011</td><td style="text-align: right;background-color: #FFFF00;;">1204.09</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">35</td><td style="text-align: right;;">9/20/2011</td><td style="text-align: right;background-color: #FFFF00;;">1202.09</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">36</td><td style="text-align: right;;">9/21/2011</td><td style="text-align: right;background-color: #FFFF00;;">1166.76</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">37</td><td style="text-align: right;;">9/22/2011</td><td style="text-align: right;background-color: #FFFF00;;">1129.56</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">38</td><td style="text-align: right;;">9/23/2011</td><td style="text-align: right;background-color: #FFFF00;;">1136.43</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">39</td><td style="text-align: right;;">9/26/2011</td><td style="text-align: right;background-color: #FFFF00;;">1162.95</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">40</td><td style="text-align: right;;">9/27/2011</td><td style="text-align: right;background-color: #FFFF00;;">1175.38</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">41</td><td style="text-align: right;;">9/28/2011</td><td style="text-align: right;background-color: #FFFF00;;">1151.06</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">42</td><td style="text-align: right;;">9/29/2011</td><td style="text-align: right;background-color: #FFFF00;;">1160.4</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">43</td><td style="text-align: right;;">9/30/2011</td><td style="text-align: right;background-color: #FFFF00;;">1131.42</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">44</td><td style="text-align: right;;">10/3/2011</td><td style="text-align: right;background-color: #FFFF00;;">1099.23</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">45</td><td style="text-align: right;;">10/4/2011</td><td style="text-align: right;;">1123.95</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">46</td><td style="text-align: right;;">10/5/2011</td><td style="text-align: right;;">1144.03</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">47</td><td style="text-align: right;;">10/6/2011</td><td style="text-align: right;;">1164.97</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">48</td><td style="text-align: right;;">10/7/2011</td><td style="text-align: right;;">1155.46</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">49</td><td style="text-align: right;;">10/10/2011</td><td style="text-align: right;;">1194.89</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">50</td><td style="text-align: right;;">10/11/2011</td><td style="text-align: right;;">1195.54</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">51</td><td style="text-align: right;;">10/12/2011</td><td style="text-align: right;;">1207.25</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">52</td><td style="text-align: right;;">10/13/2011</td><td style="text-align: right;;">1203.66</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">53</td><td style="text-align: right;;">10/14/2011</td><td style="text-align: right;;">1224.58</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">54</td><td style="text-align: right;;">10/17/2011</td><td style="text-align: right;;">1200.86</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">55</td><td style="text-align: right;;">10/18/2011</td><td style="text-align: right;;">1225.38</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">56</td><td style="text-align: right;;">10/19/2011</td><td style="text-align: right;;">1209.88</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">57</td><td style="text-align: right;;">10/20/2011</td><td style="text-align: right;;">1215.39</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">58</td><td style="text-align: right;;">10/21/2011</td><td style="text-align: right;;">1238.25</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">59</td><td style="text-align: right;;">10/24/2011</td><td style="text-align: right;;">1254.19</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">60</td><td style="text-align: right;;">10/25/2011</td><td style="text-align: right;;">1229.05</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">61</td><td style="text-align: right;;">10/26/2011</td><td style="text-align: right;;">1242</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">1</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">62</td><td style="text-align: right;;">10/27/2011</td><td style="text-align: right;background-color: #92D050;;">1284.59</td><td style="text-align: right;;">1284.59</td><td style=";"></td><td style="text-align: right;;">2</td><td style="text-align: right;;">10/27/2011</td><td style="text-align: right;;">11/4/2011</td><td style="text-align: right;;">1218.28</td><td style="text-align: right;;">1285.09</td><td style="text-align: right;;">-5.20%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">63</td><td style="text-align: right;;">10/28/2011</td><td style="text-align: right;background-color: #92D050;;">1285.09</td><td style="text-align: right;;">1285.09</td><td style="text-align: right;;">1285.09</td><td style="text-align: right;;">2</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">64</td><td style="text-align: right;;">10/31/2011</td><td style="text-align: right;background-color: #92D050;;">1253.3</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">2</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">65</td><td style="text-align: right;;">11/1/2011</td><td style="text-align: right;background-color: #92D050;;">1218.28</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">2</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">66</td><td style="text-align: right;;">11/2/2011</td><td style="text-align: right;;">1237.9</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">2</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">67</td><td style="text-align: right;;">11/3/2011</td><td style="text-align: right;;">1261.15</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">2</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">68</td><td style="text-align: right;;">11/4/2011</td><td style="text-align: right;;">1253.23</td><td style=";"></td><td style=";"></td><td style="text-align: right;;">2</td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5;color: #161120">LongDD</p><br /><br />
 
Upvote 0
Worked perfectly, I wonder if you got a chance to look at my second problem. CC is helping me and came up with solution but I am curious to know how formula looks like on yours. Thank you.
 
Upvote 0
I don't understand your second problem. Could you make another example that has a few 'groups', each with a fairly small number of rows and try to explain again in relation to that new sample data?
 
Upvote 0
Hello,

The dates as they currently are show the start and end dates of the periods themselves. If you want the start date to be the peak in the period and the end date the trough, you could do something like:

  • Start Date: =INDEX(A:A,MATCH(MAX(INDIRECT("B"&MATCH(INDEX(F:F,MATCH(K1,J:J,0)),A:A,0)&":B"&MATCH(INDEX(G:G,MATCH(K1,J:J,0)),A:A,0))),B:B,0))
  • End Date: =INDEX(A:A,MATCH(MIN(INDIRECT("B"&MATCH(INDEX(F:F,MATCH(K1,J:J,0)),A:A,0)&":B"&MATCH(INDEX(G:G,MATCH(K1,J:J,0)),A:A,0))),B:B,0))
 
Upvote 0
Hi, Peter,
I am going to compare first problem (which you have already solved) to second one, it is slightly different,

On first one: I wanted to find multiple drops and find the largest among multiple drops. In this scenario I wanted to find smaller cycles.
Cycle started in a series and ended with value going higher than previous day.

On Second problem: I want to find peak to trough bigger cycle (% drop) and another cycle does not start till it goes higher than previous peak.
I hope I am explaining this properly, if not let me know I will make another attempt, I have also marked sheet. I am sorry for the big sheet. Thank you.

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5" /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">Date</td><td style=";">Adj Close</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">8/3/2011</td><td style="text-align: right;background-color: #FFFF00;;">1260.34</td><td style=";">< First cycle started here</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;">8/4/2011</td><td style="text-align: right;background-color: #FFFF00;;">1200.07</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;;">8/5/2011</td><td style="text-align: right;background-color: #FFFF00;;">1199.38</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;;">8/8/2011</td><td style="text-align: right;background-color: #FFFF00;;">1119.46</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: right;;">9/1/2011</td><td style="text-align: right;background-color: #FFFF00;;">1204.42</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;">9/23/2011</td><td style="text-align: right;background-color: #FFFF00;;">1136.43</td><td style="text-align: right;;">-12.78%</td><td style=";">< drop of cycle one</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;">9/26/2011</td><td style="text-align: right;background-color: #FFFF00;;">1162.95</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: right;;">9/27/2011</td><td style="text-align: right;background-color: #FFFF00;;">1175.38</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: right;;">9/28/2011</td><td style="text-align: right;background-color: #FFFF00;;">1151.06</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="text-align: right;;">9/29/2011</td><td style="text-align: right;background-color: #FFFF00;;">1160.4</td><td style="text-align: right;;"></td><td style="text-align: right;;">Highest</td><td style="text-align: right;;">-12.78%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="text-align: right;;">9/30/2011</td><td style="text-align: right;background-color: #FFFF00;;">1131.42</td><td style="text-align: right;;"></td><td style="text-align: right;;">Start</td><td style="text-align: right;;">8/3/2011</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="text-align: right;;">10/3/2011</td><td style="text-align: right;background-color: #FFFF00;;">1099.23</td><td style="text-align: right;;"></td><td style="text-align: right;;">End</td><td style="text-align: right;;">10/3/2011</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="text-align: right;;">10/4/2011</td><td style="text-align: right;;">1123.95</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style="text-align: right;;">10/5/2011</td><td style="text-align: right;;">1144.03</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style="text-align: right;;">10/6/2011</td><td style="text-align: right;;">1164.97</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style="text-align: right;;">10/20/2011</td><td style="text-align: right;;">1215.39</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style="text-align: right;;">10/21/2011</td><td style="text-align: right;;">1238.25</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">19</td><td style="text-align: right;;">10/24/2011</td><td style="text-align: right;;">1254.19</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style="text-align: right;;">10/25/2011</td><td style="text-align: right;;">1229.05</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">21</td><td style="text-align: right;;">10/26/2011</td><td style="text-align: right;;">1242</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">22</td><td style="text-align: right;;">10/27/2011</td><td style="text-align: right;background-color: #00B0F0;;">1284.59</td><td style=";">< Second New cycle started here since it is higher than previous high in B2</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">23</td><td style="text-align: right;;">10/28/2011</td><td style="text-align: right;background-color: #92D050;;">1285.09</td><td style="text-align: right;;">-5.48%</td><td style=";">< so far it is -5.48%, high is 1285.09 and low is 1218.28 in second cycle, this will continue to unfold as new market data comes in daily, till one day market goes beyond 1285.09 (B23), that will mark new cycle.</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">24</td><td style="text-align: right;;">10/31/2011</td><td style="text-align: right;background-color: #92D050;;">1253.3</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">25</td><td style="text-align: right;;">11/1/2011</td><td style="text-align: right;background-color: #92D050;;">1218.28</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">26</td><td style="text-align: right;;">11/2/2011</td><td style="text-align: right;background-color: #92D050;;">1237.9</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">27</td><td style="text-align: right;;">11/3/2011</td><td style="text-align: right;background-color: #92D050;;">1261.15</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">28</td><td style="text-align: right;;">11/4/2011</td><td style="text-align: right;background-color: #92D050;;">1253.23</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">29</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">30</td><td style="text-align: right;;"></td><td style=";">??</td><td style=";">? < Third cycle will not start till  value goes higher than B23</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5;color: #161120">Sheet1</p><br /><br />
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Question
Adding a custom message.
Replies
1
Views
429
Micron
M
P
  • Solved
Compile error: method or data member not found
Replies
6
Views
244
Patriot2879
P
A
  • Question
Need help with finding a value in a table for a horse that matches a date as well.
Replies
3
Views
114
Peter_SSs
Peter_SSs
H
  • Question
Get values from a range based on certain conditions
Replies
5
Views
122
Peter_SSs
Peter_SSs
D
  • Question
Excel Word Link - part table Excel to Word, part Word to Excel
Replies
2
Views
91
NdNoviceHlp
NdNoviceHlp

Forum statistics

Threads
1,214,935
Messages
6,122,337
Members
449,078
Latest member
skydd

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