Require single column return, from multiple columns, using advance filtering

Zbish

Board Regular
Joined
Apr 12, 2003
Messages
100
Hi
I'm attempting to filter a data set, mutiple columns and rows, multiple criteria
I'm using advance filter option
Results are as expected, but Ineed to see only one colum of data returned not all columns
Any thoughts

Using Excel 2007

Any help, direction would be greatly appreciated
 
Last edited:

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
24,348
There are more that one column in the List Range entered? Correct?
Are there any blank columns in the List range.
 
Upvote 0

Zbish

Board Regular
Joined
Apr 12, 2003
Messages
100
Thanks for taking the time Mikerickson

Yes there aare mutiple columns and no no blank Columns or rows in data set
 
Upvote 0

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
24,348
It sounds like you are using the Copy to different location feature. Is the Copy To location on a protected sheet?
 
Upvote 0

Zbish

Board Regular
Joined
Apr 12, 2003
Messages
100
Hi Not sure if the attached makes sense
Not sure how to use this
let me know
looking for matched results from column H only
Criteria in column D should be 0

<table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /></colgroup><tr style="height:18px ;"><td >*</td><td >*</td><td >*</td><td >*</td><td >XXX</td><td >Criteria</td><td style="font-weight:bold; font-family:Arial; font-size:10pt; text-align:center; ">D</td><td style="font-weight:bold; font-family:Arial; font-size:10pt; text-align:center; ">XXX</td><td style="font-weight:bold; font-family:Arial; font-size:10pt; text-align:center; ">F</td><td >*</td><td >*</td><td >*</td><td >*</td><td >XXX</td><td >*</td><td >*</td></tr><tr style="height:18px ;"><td >*</td><td >XXX</td><td >*</td><td >*</td><td >XXX</td><td >*</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">XXX</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">0</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">1200</td><td >*</td><td >Note results to be posted in Sheet2 cell D5</td><td >*</td><td >XXX</td><td >*</td><td >*</td><td >*</td></tr><tr style="height:18px ;"><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >XXX</td><td >XXX</td><td >*</td><td >XXX</td><td >*</td><td >*</td></tr><tr style="height:18px ;"><td >*</td><td >*</td><td >*</td><td >*</td><td >XXX</td><td >*</td><td >*</td><td >*</td><td >XXX</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td></tr><tr style="height:18px ;"><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >XXX</td><td >*</td><td >*</td><td >XXX</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td></tr><tr style="height:18px ;"><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >XXX</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >XXX</td><td >*</td></tr><tr style="height:18px ;"><td >XXX</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >XXX</td><td >*</td><td >*</td><td >*</td><td >*</td><td >XXX</td><td >*</td><td >*</td></tr><tr style="height:18px ;"><td >*</td><td >*</td><td >*</td><td >XXX</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >XXX</td><td >*</td><td >*</td><td >*</td><td >*</td></tr><tr style="height:18px ;"><td >*</td><td >*</td><td >XXX</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td></tr><tr style="height:18px ;"><td style="font-family:Arial; font-size:10pt; ">A</td><td style="font-family:Arial; font-size:10pt; ">B</td><td style="font-family:Arial; font-size:10pt; ">C</td><td style="font-family:Arial; font-size:10pt; ">D</td><td style="font-family:Arial; font-size:10pt; ">E</td><td style="font-family:Arial; font-size:10pt; ">F</td><td style="font-family:Arial; font-size:10pt; ">G</td><td style="font-family:Arial; font-size:10pt; ">H</td><td style="font-family:Arial; font-size:10pt; ">I</td><td style="font-family:Arial; font-size:10pt; ">J</td><td style="font-family:Arial; font-size:10pt; ">K</td><td style="font-family:Arial; font-size:10pt; ">L</td><td style="font-family:Arial; font-size:10pt; ">M</td><td style="font-family:Arial; font-size:10pt; ">N</td><td style="font-family:Arial; font-size:10pt; ">O</td><td style="font-family:Arial; font-size:10pt; ">P</td></tr><tr style="height:18px ;"><td style="text-align:right; ">-40</td><td style="text-align:right; ">-25</td><td style="text-align:right; ">0</td><td style="text-align:right; ">-10</td><td style="text-align:right; ">-4</td><td style="text-align:right; ">1200</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">43</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">2.61</td><td style="text-align:right; ">3.03</td><td style="text-align:right; ">5.64</td><td style="text-align:right; ">2646</td><td style="text-align:right; ">261</td><td style="text-align:right; ">141</td><td style="text-align:right; ">402</td></tr><tr style="height:18px ;"><td style="text-align:right; ">-40</td><td style="text-align:right; ">-25</td><td style="text-align:right; ">0</td><td style="text-align:right; ">-10</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">1600</td><td style="text-align:right; ">101.3</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">173.9</td><td style="text-align:right; ">3.18</td><td style="text-align:right; ">4.56</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">3527</td><td style="text-align:right; ">332</td><td style="text-align:right; ">238</td><td style="text-align:right; ">571</td></tr><tr style="height:18px ;"><td style="text-align:right; ">-40</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">0</td><td style="text-align:right; ">-10</td><td style="text-align:right; ">-4</td><td style="text-align:right; ">2000</td><td style="text-align:right; ">123.4</td><td style="text-align:right; ">110.1</td><td style="text-align:right; ">233.5</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">6.31</td><td style="text-align:right; ">10.02</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">405</td><td style="text-align:right; ">361</td><td style="text-align:right; ">XXX</td></tr><tr style="height:18px ;"><td style="text-align:right; ">XXX</td><td style="text-align:right; ">-25</td><td style="text-align:right; ">0</td><td style="text-align:right; ">-10</td><td style="text-align:right; ">-4</td><td style="text-align:right; ">2400</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">156.1</td><td style="text-align:right; ">306.3</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">8.28</td><td style="text-align:right; ">12.6</td><td style="text-align:right; ">5291</td><td style="text-align:right; ">493</td><td style="text-align:right; ">512</td><td style="text-align:right; ">1005</td></tr><tr style="height:18px ;"><td style="text-align:right; ">XXX</td><td style="text-align:right; ">-25</td><td style="text-align:right; ">0</td><td style="text-align:right; ">-10</td><td style="text-align:right; ">-4</td><td style="text-align:right; ">2800</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">211.2</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">5.4</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">15.86</td><td style="text-align:right; ">6173</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">693</td><td style="text-align:right; ">1346</td></tr><tr style="height:18px ;"><td style="text-align:right; ">-40</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">0</td><td style="text-align:right; ">-10</td><td style="text-align:right; ">-2</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">80.6</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">124.7</td><td style="text-align:right; ">2.66</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">5.76</td><td style="text-align:right; ">2646</td><td style="text-align:right; ">264</td><td style="text-align:right; ">145</td><td style="text-align:right; ">409</td></tr><tr style="height:18px ;"><td style="text-align:right; ">XXX</td><td style="text-align:right; ">-25</td><td style="text-align:right; ">0</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">-2</td><td style="text-align:right; ">1600</td><td style="text-align:right; ">103.2</td><td style="text-align:right; ">75.1</td><td style="text-align:right; ">178.4</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">7.96</td><td style="text-align:right; ">3527</td><td style="text-align:right; ">339</td><td style="text-align:right; ">246</td><td style="text-align:right; ">585</td></tr><tr style="height:18px ;"><td style="text-align:right; ">XXX</td><td style="text-align:right; ">-25</td><td style="text-align:right; ">0</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">-2</td><td style="text-align:right; ">2000</td><td style="text-align:right; ">126.7</td><td style="text-align:right; ">115.2</td><td style="text-align:right; ">242</td><td style="text-align:right; ">3.83</td><td style="text-align:right; ">6.58</td><td style="text-align:right; ">10.41</td><td style="text-align:right; ">4409</td><td style="text-align:right; ">416</td><td style="text-align:right; ">378</td><td style="text-align:right; ">794</td></tr><tr style="height:18px ;"><td style="text-align:right; ">-40</td><td style="text-align:right; ">-25</td><td style="text-align:right; ">0</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">-2</td><td style="text-align:right; ">2400</td><td style="text-align:right; ">162.2</td><td style="text-align:right; ">165.3</td><td style="text-align:right; ">327.5</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">8.72</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">5291</td><td style="text-align:right; ">532</td><td style="text-align:right; ">542</td><td style="text-align:right; ">1074</td></tr><tr style="height:18px ;"><td style="text-align:right; ">-40</td><td style="text-align:right; ">-25</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">-10</td><td style="text-align:right; ">-2</td><td style="text-align:right; ">2800</td><td style="text-align:right; ">220</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">446.4</td><td style="text-align:right; ">5.96</td><td style="text-align:right; ">11.14</td><td style="text-align:right; ">17.1</td><td style="text-align:right; ">6173</td><td style="text-align:right; ">722</td><td style="text-align:right; ">743</td><td style="text-align:right; ">1465</td></tr><tr style="height:18px ;"><td style="text-align:right; ">-40</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">0</td><td style="text-align:right; ">-10</td><td style="text-align:right; ">0</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">45.3</td><td style="text-align:right; ">126.7</td><td style="text-align:right; ">2.7</td><td style="text-align:right; ">3.18</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">2646</td><td style="text-align:right; ">267</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">416</td></tr><tr style="height:18px ;"><td style="text-align:right; ">-40</td><td style="text-align:right; ">-25</td><td style="text-align:right; ">0</td><td style="text-align:right; ">-10</td><td style="text-align:right; ">0</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">105.1</td><td style="text-align:right; ">77.9</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">3.33</td><td style="text-align:right; ">4.88</td><td style="text-align:right; ">8.21</td><td style="text-align:right; ">3527</td><td style="text-align:right; ">345</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">601</td></tr><tr style="height:18px ;"><td style="text-align:right; ">-40</td><td style="text-align:right; ">-25</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">-10</td><td style="text-align:right; ">0</td><td style="text-align:right; ">2000</td><td style="text-align:right; ">130.3</td><td style="text-align:right; ">120.9</td><td style="text-align:right; ">251.3</td><td style="text-align:right; ">3.96</td><td style="text-align:right; ">6.88</td><td style="text-align:right; ">10.85</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">427</td><td style="text-align:right; ">397</td><td style="text-align:right; ">824</td></tr><tr style="height:18px ;"><td style="text-align:right; ">-40</td><td style="text-align:right; ">-25</td><td style="text-align:right; ">0</td><td style="text-align:right; ">-10</td><td style="text-align:right; ">0</td><td style="text-align:right; ">2400</td><td style="text-align:right; ">176.5</td><td style="text-align:right; ">175.7</td><td style="text-align:right; ">352.2</td><td style="text-align:right; ">5.06</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">5291</td><td style="text-align:right; ">579</td><td style="text-align:right; ">576</td><td style="text-align:right; ">1156</td></tr><tr style="height:18px ;"><td style="text-align:right; ">XXX</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">0</td><td style="text-align:right; ">-10</td><td style="text-align:right; ">0</td><td style="text-align:right; ">2800</td><td style="text-align:right; ">246.4</td><td style="text-align:right; ">244</td><td style="text-align:right; ">490.4</td><td style="text-align:right; ">6.66</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">18.58</td><td style="text-align:right; ">6173</td><td style="text-align:right; ">808</td><td style="text-align:right; ">801</td><td style="text-align:right; ">1609</td></tr><tr style="height:18px ;"><td style="text-align:right; ">XXX</td><td style="text-align:right; ">-25</td><td style="text-align:right; ">0</td><td style="text-align:right; ">-10</td><td style="text-align:right; ">2</td><td style="text-align:right; ">1200</td><td style="text-align:right; ">82.3</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">128.8</td><td style="text-align:right; ">2.74</td><td style="text-align:right; ">3.26</td><td style="text-align:right; ">6</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">270</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">423</td></tr><tr style="height:18px ;"><td style="text-align:right; ">-40</td><td style="text-align:right; ">-25</td><td style="text-align:right; ">0</td><td style="text-align:right; ">-10</td><td style="text-align:right; ">2</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">107.1</td><td style="text-align:right; ">81</td><td style="text-align:right; ">188.1</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">5.05</td><td style="text-align:right; ">8.46</td><td style="text-align:right; ">3527</td><td style="text-align:right; ">351</td><td style="text-align:right; ">266</td><td style="text-align:right; ">617</td></tr><tr style="height:18px ;"><td style="text-align:right; ">-40</td><td style="text-align:right; ">-25</td><td style="text-align:right; ">0</td><td style="text-align:right; ">-10</td><td style="text-align:right; ">2</td><td style="text-align:right; ">2000</td><td style="text-align:right; ">134.2</td><td style="text-align:right; ">127.2</td><td style="text-align:right; ">261.4</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">7.21</td><td style="text-align:right; ">11.32</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">440</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">XXX</td></tr><tr style="height:18px ;"><td style="text-align:right; ">XXX</td><td style="text-align:right; ">-25</td><td style="text-align:right; ">0</td><td style="text-align:right; ">-10</td><td style="text-align:right; ">2</td><td style="text-align:right; ">2400</td><td style="text-align:right; ">193.6</td><td style="text-align:right; ">187.5</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">5.55</td><td style="text-align:right; ">9.78</td><td style="text-align:right; ">15.33</td><td style="text-align:right; ">5291</td><td style="text-align:right; ">635</td><td style="text-align:right; ">615</td><td style="text-align:right; ">1250</td></tr><tr style="height:18px ;"><td style="text-align:right; ">-40</td><td style="text-align:right; ">-25</td><td style="text-align:right; ">0</td><td style="text-align:right; ">-10</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">2800</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">264.8</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">12.83</td><td style="text-align:right; ">20.37</td><td style="text-align:right; ">6173</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">869</td><td style="text-align:right; ">1786</td></tr><tr style="height:18px ;"><td style="text-align:right; ">XXX</td><td style="text-align:right; ">-25</td><td style="text-align:right; ">0</td><td style="text-align:right; ">-10</td><td style="text-align:right; ">4</td><td style="text-align:right; ">1200</td><td style="text-align:right; ">83.2</td><td style="text-align:right; ">47.8</td><td style="text-align:right; ">131</td><td style="text-align:right; ">2.79</td><td style="text-align:right; ">3.34</td><td style="text-align:right; ">6.13</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">157</td><td style="text-align:right; ">430</td></tr><tr style="height:18px ;"><td style="text-align:right; ">-40</td><td style="text-align:right; ">-25</td><td style="text-align:right; ">0</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">4</td><td style="text-align:right; ">1600</td><td style="text-align:right; ">109.2</td><td style="text-align:right; ">84.2</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">3.5</td><td style="text-align:right; ">5.24</td><td style="text-align:right; ">8.74</td><td style="text-align:right; ">3527</td><td style="text-align:right; ">358</td><td style="text-align:right; ">276</td><td style="text-align:right; ">635</td></tr><tr style="height:18px ;"><td style="text-align:right; ">-40</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">0</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">4</td><td style="text-align:right; ">2000</td><td style="text-align:right; ">142.5</td><td style="text-align:right; ">134.2</td><td style="text-align:right; ">276.7</td><td style="text-align:right; ">4.37</td><td style="text-align:right; ">7.57</td><td style="text-align:right; ">11.94</td><td style="text-align:right; ">4409</td><td style="text-align:right; ">468</td><td style="text-align:right; ">440</td><td style="text-align:right; ">908</td></tr><tr style="height:18px ;"><td style="text-align:right; ">-40</td><td style="text-align:right; ">-25</td><td style="text-align:right; ">0</td><td style="text-align:right; ">-10</td><td style="text-align:right; ">4</td><td style="text-align:right; ">2400</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">201.1</td><td style="text-align:right; ">415.9</td><td style="text-align:right; ">6.14</td><td style="text-align:right; ">10.42</td><td style="text-align:right; ">16.56</td><td style="text-align:right; ">5291</td><td style="text-align:right; ">705</td><td style="text-align:right; ">660</td><td style="text-align:right; ">1365</td></tr><tr style="height:18px ;"><td style="text-align:right; ">-40</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">0</td><td style="text-align:right; ">-10</td><td style="text-align:right; ">4</td><td style="text-align:right; ">2800</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">289.6</td><td style="text-align:right; ">614.8</td><td style="text-align:right; ">8.73</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">22.63</td><td style="text-align:right; ">6173</td><td style="text-align:right; ">1067</td><td style="text-align:right; ">950</td><td style="text-align:right; ">2017</td></tr><tr style="height:18px ;"><td style="text-align:right; ">-40</td><td style="text-align:right; ">-25</td><td style="text-align:right; ">0</td><td style="text-align:right; ">0</td><td style="text-align:right; ">-4</td><td style="text-align:right; ">1200</td><td style="text-align:right; ">60.5</td><td style="text-align:right; ">21.8</td><td style="text-align:right; ">82.2</td><td style="text-align:right; ">2.61</td><td style="text-align:right; ">2.22</td><td style="text-align:right; ">4.83</td><td style="text-align:right; ">2646</td><td style="text-align:right; ">198</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">270</td></tr><tr style="height:18px ;"><td style="text-align:right; ">-40</td><td style="text-align:right; ">-25</td><td style="text-align:right; ">0</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">-4</td><td style="text-align:right; ">1600</td><td style="text-align:right; ">78.4</td><td style="text-align:right; ">40</td><td style="text-align:right; ">118.4</td><td style="text-align:right; ">3.18</td><td style="text-align:right; ">3.49</td><td style="text-align:right; ">6.67</td><td style="text-align:right; ">3527</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">131</td><td style="text-align:right; ">388</td></tr><tr style="height:18px ;"><td style="text-align:right; ">XXX</td><td style="text-align:right; ">-25</td><td style="text-align:right; ">0</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">-4</td><td style="text-align:right; ">2000</td><td style="text-align:right; ">97</td><td style="text-align:right; ">64.4</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">3.71</td><td style="text-align:right; ">4.98</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">4409</td><td style="text-align:right; ">318</td><td style="text-align:right; ">211</td><td style="text-align:right; ">530</td></tr><tr style="height:18px ;"><td style="text-align:right; ">-40</td><td style="text-align:right; ">-25</td><td style="text-align:right; ">0</td><td style="text-align:right; ">0</td><td style="text-align:right; ">-4</td><td style="text-align:right; ">2400</td><td style="text-align:right; ">119.7</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">4.32</td><td style="text-align:right; ">6.69</td><td style="text-align:right; ">11.01</td><td style="text-align:right; ">5291</td><td style="text-align:right; ">393</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">706</td></tr><tr style="height:18px ;"><td style="text-align:right; ">-40</td><td style="text-align:right; ">-25</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">0</td><td style="text-align:right; ">-4</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">134.1</td><td style="text-align:right; ">295.2</td><td style="text-align:right; ">5.4</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">14.01</td><td style="text-align:right; ">6173</td><td style="text-align:right; ">529</td><td style="text-align:right; ">440</td><td style="text-align:right; ">XXX</td></tr><tr style="height:18px ;"><td style="text-align:right; ">-40</td><td style="text-align:right; ">-25</td><td style="text-align:right; ">0</td><td style="text-align:right; ">0</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">1200</td><td style="text-align:right; ">61.1</td><td style="text-align:right; ">22.3</td><td style="text-align:right; ">83.5</td><td style="text-align:right; ">2.66</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">4.93</td><td style="text-align:right; ">2646</td><td style="text-align:right; ">200</td><td style="text-align:right; ">73</td><td style="text-align:right; ">274</td></tr><tr style="height:18px ;"><td style="text-align:right; ">XXX</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">0</td><td style="text-align:right; ">0</td><td style="text-align:right; ">-2</td><td style="text-align:right; ">1600</td><td style="text-align:right; ">79.8</td><td style="text-align:right; ">41.5</td><td style="text-align:right; ">121.2</td><td style="text-align:right; ">3.25</td><td style="text-align:right; ">3.61</td><td style="text-align:right; ">6.86</td><td style="text-align:right; ">3527</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">136</td><td style="text-align:right; ">398</td></tr><tr style="height:18px ;"><td style="text-align:right; ">-40</td><td style="text-align:right; ">-25</td><td style="text-align:right; ">0</td><td style="text-align:right; ">0</td><td style="text-align:right; ">-2</td><td style="text-align:right; ">2000</td><td style="text-align:right; ">99.5</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">3.83</td><td style="text-align:right; ">5.21</td><td style="text-align:right; ">9.04</td><td style="text-align:right; ">4409</td><td style="text-align:right; ">326</td><td style="text-align:right; ">221</td><td style="text-align:right; ">548</td></tr><tr style="height:18px ;"><td style="text-align:right; ">-40</td><td style="text-align:right; ">-25</td><td style="text-align:right; ">0</td><td style="text-align:right; ">0</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">2400</td><td style="text-align:right; ">129.3</td><td style="text-align:right; ">101.4</td><td style="text-align:right; ">230.8</td><td style="text-align:right; ">4.66</td><td style="text-align:right; ">7.06</td><td style="text-align:right; ">11.72</td><td style="text-align:right; ">5291</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">333</td><td style="text-align:right; ">XXX</td></tr><tr style="height:18px ;"><td style="text-align:right; ">-40</td><td style="text-align:right; ">-25</td><td style="text-align:right; ">0</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">-2</td><td style="text-align:right; ">2800</td><td style="text-align:right; ">178</td><td style="text-align:right; ">144.1</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">5.96</td><td style="text-align:right; ">9.2</td><td style="text-align:right; ">15.15</td><td style="text-align:right; ">6173</td><td style="text-align:right; ">584</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">1057</td></tr><tr style="height:18px ;"><td style="text-align:right; ">-40</td><td style="text-align:right; ">-25</td><td style="text-align:right; ">0</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">0</td><td style="text-align:right; ">1200</td><td style="text-align:right; ">61.7</td><td style="text-align:right; ">23</td><td style="text-align:right; ">84.6</td><td style="text-align:right; ">2.7</td><td style="text-align:right; ">2.33</td><td style="text-align:right; ">5.03</td><td style="text-align:right; ">XXX</td><td style="text-align:right; ">202</td><td style="text-align:right; ">75</td><td style="text-align:right; ">278</td></tr></table>
 
Upvote 0

Forum statistics

Threads
1,191,090
Messages
5,984,572
Members
439,896
Latest member
SquareCare

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
Top