Formula to bring Last Values of the multiple columns

Daiwik

New Member
Joined
Jan 12, 2016
Messages
15
Hi,

I am looking for a suitable trick to get last values of the multiple columns, as shown in the table below.
I am using a following formula (which is just half being a trial) which is working fine but it would be too lengthy. Just want to get an appropriate one. Thanks you!

=IF(B30<>"",B30,IF(B29<>"",B29,IF(B28<>"",B28,IF(B27<>"",B27,IF(B26<>"",B26,IF(B25<>"",B25,IF(B24<>"",B24,IF(B23<>"",B23,IF(B22<>"",B22,IF(B21<>"",B21,""))))))))))

DateList 1List 2List 3List 4List 5List 6List 7List 8List 9List 10
01-02-201645573348376149463850
02-02-201644573544455530565747
03-02-201636445534623152603044
04-02-201644376132614535434652
05-02-201644376132614535434652
06-02-201634484762403362585131
07-02-201623315737493959303140
08-02-201643315058463035454854
09-02-201622394445413362336060
10-02-201629493558403557313637
11-02-201643526157614046383440
12-02-201642506256585050574632
13-02-201629363949584134464544
14-02-201638413133343535304158
15-02-201645544735424361456040
16-02-201650435835325045515840
17-02-201630563355494936345341
18-02-201633354962346041595857
19-02-201624316052434933426059
20-02-201639343738384354595158
21-02-201645334448513248525940
22-02-201633475237 59483447
23-02-201631455359 343648
24-02-201649515440 60 31
25-02-20163050 53 57
26-02-2016 42
27-02-2016
28-02-2016
29-02-2016
Last Figure.30505442515960365740

<colgroup><col><col><col span="9"></colgroup><tbody>
</tbody>
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Daiwik

New Member
Joined
Jan 12, 2016
Messages
15
Hi BarryL,

just want to know why did you chose MAX formula with +1, What's the concept behind it? Thanks in advance.
 

michaelsmith559

Well-known Member
Joined
Oct 6, 2013
Messages
842

ADVERTISEMENT

Here is a macro to do it. I assume you want last figure at the end of your date column. Set up your sheet like the first screenshot, run the macro. Second Screenshot shows the results.

Set up Sheet:
<b>Excel 2003</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 /><col /><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><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;text-align: center;color: #993300;;">Date</td><td style="font-weight: bold;text-align: center;color: #993300;;">List 1</td><td style="font-weight: bold;text-align: center;color: #993300;;">List 2</td><td style="font-weight: bold;text-align: center;color: #993300;;">List 3</td><td style="font-weight: bold;text-align: center;color: #993300;;">List 4</td><td style="font-weight: bold;text-align: center;color: #993300;;">List 5</td><td style="font-weight: bold;text-align: center;color: #993300;;">List 6</td><td style="font-weight: bold;text-align: center;color: #993300;;">List 7</td><td style="font-weight: bold;text-align: center;color: #993300;;">List 8</td><td style="font-weight: bold;text-align: center;color: #993300;;">List 9</td><td style="font-weight: bold;text-align: center;color: #993300;;">List 10</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="font-weight: bold;text-align: center;color: #993300;;">1/2/2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">45</td><td style="font-weight: bold;text-align: center;color: #993300;;">57</td><td style="font-weight: bold;text-align: center;color: #993300;;">33</td><td style="font-weight: bold;text-align: center;color: #993300;;">48</td><td style="font-weight: bold;text-align: center;color: #993300;;">37</td><td style="font-weight: bold;text-align: center;color: #993300;;">61</td><td style="font-weight: bold;text-align: center;color: #993300;;">49</td><td style="font-weight: bold;text-align: center;color: #993300;;">46</td><td style="font-weight: bold;text-align: center;color: #993300;;">38</td><td style="font-weight: bold;text-align: center;color: #993300;;">50</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="font-weight: bold;text-align: center;color: #993300;;">2/2/2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">44</td><td style="font-weight: bold;text-align: center;color: #993300;;">57</td><td style="font-weight: bold;text-align: center;color: #993300;;">35</td><td style="font-weight: bold;text-align: center;color: #993300;;">44</td><td style="font-weight: bold;text-align: center;color: #993300;;">45</td><td style="font-weight: bold;text-align: center;color: #993300;;">55</td><td style="font-weight: bold;text-align: center;color: #993300;;">30</td><td style="font-weight: bold;text-align: center;color: #993300;;">56</td><td style="font-weight: bold;text-align: center;color: #993300;;">57</td><td style="font-weight: bold;text-align: center;color: #993300;;">47</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="font-weight: bold;text-align: center;color: #993300;;">3/2/2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">36</td><td style="font-weight: bold;text-align: center;color: #993300;;">44</td><td style="font-weight: bold;text-align: center;color: #993300;;">55</td><td style="font-weight: bold;text-align: center;color: #993300;;">34</td><td style="font-weight: bold;text-align: center;color: #993300;;">62</td><td style="font-weight: bold;text-align: center;color: #993300;;">31</td><td style="font-weight: bold;text-align: center;color: #993300;;">52</td><td style="font-weight: bold;text-align: center;color: #993300;;">60</td><td style="font-weight: bold;text-align: center;color: #993300;;">30</td><td style="font-weight: bold;text-align: center;color: #993300;;">44</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="font-weight: bold;text-align: center;color: #993300;;">4/2/2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">44</td><td style="font-weight: bold;text-align: center;color: #993300;;">37</td><td style="font-weight: bold;text-align: center;color: #993300;;">61</td><td style="font-weight: bold;text-align: center;color: #993300;;">32</td><td style="font-weight: bold;text-align: center;color: #993300;;">61</td><td style="font-weight: bold;text-align: center;color: #993300;;">45</td><td style="font-weight: bold;text-align: center;color: #993300;;">35</td><td style="font-weight: bold;text-align: center;color: #993300;;">43</td><td style="font-weight: bold;text-align: center;color: #993300;;">46</td><td style="font-weight: bold;text-align: center;color: #993300;;">52</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="font-weight: bold;text-align: center;color: #993300;;">5/2/2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">44</td><td style="font-weight: bold;text-align: center;color: #993300;;">37</td><td style="font-weight: bold;text-align: center;color: #993300;;">61</td><td style="font-weight: bold;text-align: center;color: #993300;;">32</td><td style="font-weight: bold;text-align: center;color: #993300;;">61</td><td style="font-weight: bold;text-align: center;color: #993300;;">45</td><td style="font-weight: bold;text-align: center;color: #993300;;">35</td><td style="font-weight: bold;text-align: center;color: #993300;;">43</td><td style="font-weight: bold;text-align: center;color: #993300;;">46</td><td style="font-weight: bold;text-align: center;color: #993300;;">52</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="font-weight: bold;text-align: center;color: #993300;;">6/2/2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">34</td><td style="font-weight: bold;text-align: center;color: #993300;;">48</td><td style="font-weight: bold;text-align: center;color: #993300;;">47</td><td style="font-weight: bold;text-align: center;color: #993300;;">62</td><td style="font-weight: bold;text-align: center;color: #993300;;">40</td><td style="font-weight: bold;text-align: center;color: #993300;;">33</td><td style="font-weight: bold;text-align: center;color: #993300;;">62</td><td style="font-weight: bold;text-align: center;color: #993300;;">58</td><td style="font-weight: bold;text-align: center;color: #993300;;">51</td><td style="font-weight: bold;text-align: center;color: #993300;;">31</td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="font-weight: bold;text-align: center;color: #993300;;">7/2/2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">23</td><td style="font-weight: bold;text-align: center;color: #993300;;">31</td><td style="font-weight: bold;text-align: center;color: #993300;;">57</td><td style="font-weight: bold;text-align: center;color: #993300;;">37</td><td style="font-weight: bold;text-align: center;color: #993300;;">49</td><td style="font-weight: bold;text-align: center;color: #993300;;">39</td><td style="font-weight: bold;text-align: center;color: #993300;;">59</td><td style="font-weight: bold;text-align: center;color: #993300;;">30</td><td style="font-weight: bold;text-align: center;color: #993300;;">31</td><td style="font-weight: bold;text-align: center;color: #993300;;">40</td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="font-weight: bold;text-align: center;color: #993300;;">8/2/2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">43</td><td style="font-weight: bold;text-align: center;color: #993300;;">31</td><td style="font-weight: bold;text-align: center;color: #993300;;">50</td><td style="font-weight: bold;text-align: center;color: #993300;;">58</td><td style="font-weight: bold;text-align: center;color: #993300;;">46</td><td style="font-weight: bold;text-align: center;color: #993300;;">30</td><td style="font-weight: bold;text-align: center;color: #993300;;">35</td><td style="font-weight: bold;text-align: center;color: #993300;;">45</td><td style="font-weight: bold;text-align: center;color: #993300;;">48</td><td style="font-weight: bold;text-align: center;color: #993300;;">54</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="font-weight: bold;text-align: center;color: #993300;;">9/2/2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">22</td><td style="font-weight: bold;text-align: center;color: #993300;;">39</td><td style="font-weight: bold;text-align: center;color: #993300;;">44</td><td style="font-weight: bold;text-align: center;color: #993300;;">45</td><td style="font-weight: bold;text-align: center;color: #993300;;">41</td><td style="font-weight: bold;text-align: center;color: #993300;;">33</td><td style="font-weight: bold;text-align: center;color: #993300;;">62</td><td style="font-weight: bold;text-align: center;color: #993300;;">33</td><td style="font-weight: bold;text-align: center;color: #993300;;">60</td><td style="font-weight: bold;text-align: center;color: #993300;;">60</td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="font-weight: bold;text-align: center;color: #993300;;">10/2/2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">29</td><td style="font-weight: bold;text-align: center;color: #993300;;">49</td><td style="font-weight: bold;text-align: center;color: #993300;;">35</td><td style="font-weight: bold;text-align: center;color: #993300;;">58</td><td style="font-weight: bold;text-align: center;color: #993300;;">40</td><td style="font-weight: bold;text-align: center;color: #993300;;">35</td><td style="font-weight: bold;text-align: center;color: #993300;;">57</td><td style="font-weight: bold;text-align: center;color: #993300;;">31</td><td style="font-weight: bold;text-align: center;color: #993300;;">36</td><td style="font-weight: bold;text-align: center;color: #993300;;">37</td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="font-weight: bold;text-align: center;color: #993300;;">11/2/2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">43</td><td style="font-weight: bold;text-align: center;color: #993300;;">52</td><td style="font-weight: bold;text-align: center;color: #993300;;">61</td><td style="font-weight: bold;text-align: center;color: #993300;;">57</td><td style="font-weight: bold;text-align: center;color: #993300;;">61</td><td style="font-weight: bold;text-align: center;color: #993300;;">40</td><td style="font-weight: bold;text-align: center;color: #993300;;">46</td><td style="font-weight: bold;text-align: center;color: #993300;;">38</td><td style="font-weight: bold;text-align: center;color: #993300;;">34</td><td style="font-weight: bold;text-align: center;color: #993300;;">40</td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="font-weight: bold;text-align: center;color: #993300;;">12/2/2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">42</td><td style="font-weight: bold;text-align: center;color: #993300;;">50</td><td style="font-weight: bold;text-align: center;color: #993300;;">62</td><td style="font-weight: bold;text-align: center;color: #993300;;">56</td><td style="font-weight: bold;text-align: center;color: #993300;;">58</td><td style="font-weight: bold;text-align: center;color: #993300;;">50</td><td style="font-weight: bold;text-align: center;color: #993300;;">50</td><td style="font-weight: bold;text-align: center;color: #993300;;">57</td><td style="font-weight: bold;text-align: center;color: #993300;;">46</td><td style="font-weight: bold;text-align: center;color: #993300;;">32</td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="font-weight: bold;text-align: center;color: #993300;;">13-02-2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">29</td><td style="font-weight: bold;text-align: center;color: #993300;;">36</td><td style="font-weight: bold;text-align: center;color: #993300;;">39</td><td style="font-weight: bold;text-align: center;color: #993300;;">49</td><td style="font-weight: bold;text-align: center;color: #993300;;">58</td><td style="font-weight: bold;text-align: center;color: #993300;;">41</td><td style="font-weight: bold;text-align: center;color: #993300;;">34</td><td style="font-weight: bold;text-align: center;color: #993300;;">46</td><td style="font-weight: bold;text-align: center;color: #993300;;">45</td><td style="font-weight: bold;text-align: center;color: #993300;;">44</td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style="font-weight: bold;text-align: center;color: #993300;;">14-02-2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">38</td><td style="font-weight: bold;text-align: center;color: #993300;;">41</td><td style="font-weight: bold;text-align: center;color: #993300;;">31</td><td style="font-weight: bold;text-align: center;color: #993300;;">33</td><td style="font-weight: bold;text-align: center;color: #993300;;">34</td><td style="font-weight: bold;text-align: center;color: #993300;;">35</td><td style="font-weight: bold;text-align: center;color: #993300;;">35</td><td style="font-weight: bold;text-align: center;color: #993300;;">30</td><td style="font-weight: bold;text-align: center;color: #993300;;">41</td><td style="font-weight: bold;text-align: center;color: #993300;;">58</td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style="font-weight: bold;text-align: center;color: #993300;;">15-02-2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">45</td><td style="font-weight: bold;text-align: center;color: #993300;;">54</td><td style="font-weight: bold;text-align: center;color: #993300;;">47</td><td style="font-weight: bold;text-align: center;color: #993300;;">35</td><td style="font-weight: bold;text-align: center;color: #993300;;">42</td><td style="font-weight: bold;text-align: center;color: #993300;;">43</td><td style="font-weight: bold;text-align: center;color: #993300;;">61</td><td style="font-weight: bold;text-align: center;color: #993300;;">45</td><td style="font-weight: bold;text-align: center;color: #993300;;">60</td><td style="font-weight: bold;text-align: center;color: #993300;;">40</td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style="font-weight: bold;text-align: center;color: #993300;;">16-02-2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">50</td><td style="font-weight: bold;text-align: center;color: #993300;;">43</td><td style="font-weight: bold;text-align: center;color: #993300;;">58</td><td style="font-weight: bold;text-align: center;color: #993300;;">35</td><td style="font-weight: bold;text-align: center;color: #993300;;">32</td><td style="font-weight: bold;text-align: center;color: #993300;;">50</td><td style="font-weight: bold;text-align: center;color: #993300;;">45</td><td style="font-weight: bold;text-align: center;color: #993300;;">51</td><td style="font-weight: bold;text-align: center;color: #993300;;">58</td><td style="font-weight: bold;text-align: center;color: #993300;;">40</td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style="font-weight: bold;text-align: center;color: #993300;;">17-02-2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">30</td><td style="font-weight: bold;text-align: center;color: #993300;;">56</td><td style="font-weight: bold;text-align: center;color: #993300;;">33</td><td style="font-weight: bold;text-align: center;color: #993300;;">55</td><td style="font-weight: bold;text-align: center;color: #993300;;">49</td><td style="font-weight: bold;text-align: center;color: #993300;;">49</td><td style="font-weight: bold;text-align: center;color: #993300;;">36</td><td style="font-weight: bold;text-align: center;color: #993300;;">34</td><td style="font-weight: bold;text-align: center;color: #993300;;">53</td><td style="font-weight: bold;text-align: center;color: #993300;;">41</td></tr><tr ><td style="color: #161120;text-align: center;">19</td><td style="font-weight: bold;text-align: center;color: #993300;;">18-02-2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">33</td><td style="font-weight: bold;text-align: center;color: #993300;;">35</td><td style="font-weight: bold;text-align: center;color: #993300;;">49</td><td style="font-weight: bold;text-align: center;color: #993300;;">62</td><td style="font-weight: bold;text-align: center;color: #993300;;">34</td><td style="font-weight: bold;text-align: center;color: #993300;;">60</td><td style="font-weight: bold;text-align: center;color: #993300;;">41</td><td style="font-weight: bold;text-align: center;color: #993300;;">59</td><td style="font-weight: bold;text-align: center;color: #993300;;">58</td><td style="font-weight: bold;text-align: center;color: #993300;;">57</td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style="font-weight: bold;text-align: center;color: #993300;;">19-02-2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">24</td><td style="font-weight: bold;text-align: center;color: #993300;;">31</td><td style="font-weight: bold;text-align: center;color: #993300;;">60</td><td style="font-weight: bold;text-align: center;color: #993300;;">52</td><td style="font-weight: bold;text-align: center;color: #993300;;">43</td><td style="font-weight: bold;text-align: center;color: #993300;;">49</td><td style="font-weight: bold;text-align: center;color: #993300;;">33</td><td style="font-weight: bold;text-align: center;color: #993300;;">42</td><td style="font-weight: bold;text-align: center;color: #993300;;">60</td><td style="font-weight: bold;text-align: center;color: #993300;;">59</td></tr><tr ><td style="color: #161120;text-align: center;">21</td><td style="font-weight: bold;text-align: center;color: #993300;;">20-02-2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">39</td><td style="font-weight: bold;text-align: center;color: #993300;;">34</td><td style="font-weight: bold;text-align: center;color: #993300;;">37</td><td style="font-weight: bold;text-align: center;color: #993300;;">38</td><td style="font-weight: bold;text-align: center;color: #993300;;">38</td><td style="font-weight: bold;text-align: center;color: #993300;;">43</td><td style="font-weight: bold;text-align: center;color: #993300;;">54</td><td style="font-weight: bold;text-align: center;color: #993300;;">59</td><td style="font-weight: bold;text-align: center;color: #993300;;">51</td><td style="font-weight: bold;text-align: center;color: #993300;;">58</td></tr><tr ><td style="color: #161120;text-align: center;">22</td><td style="font-weight: bold;text-align: center;color: #993300;;">21-02-2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">45</td><td style="font-weight: bold;text-align: center;color: #993300;;">33</td><td style="font-weight: bold;text-align: center;color: #993300;;">44</td><td style="font-weight: bold;text-align: center;color: #993300;;">48</td><td style="font-weight: bold;text-align: center;color: #993300;;">51</td><td style="font-weight: bold;text-align: center;color: #993300;;">32</td><td style="font-weight: bold;text-align: center;color: #993300;;">48</td><td style="font-weight: bold;text-align: center;color: #993300;;">52</td><td style="font-weight: bold;text-align: center;color: #993300;;">59</td><td style="font-weight: bold;text-align: center;color: #993300;;">40</td></tr><tr ><td style="color: #161120;text-align: center;">23</td><td style="font-weight: bold;text-align: center;color: #993300;;">22-02-2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">33</td><td style="font-weight: bold;text-align: center;color: #993300;;">47</td><td style="font-weight: bold;text-align: center;color: #993300;;">52</td><td style="font-weight: bold;text-align: center;color: #993300;;">37</td><td style="text-align: center;;"></td><td style="font-weight: bold;text-align: center;color: #993300;;">59</td><td style="font-weight: bold;text-align: center;color: #993300;;">48</td><td style="font-weight: bold;text-align: center;color: #993300;;">34</td><td style="font-weight: bold;text-align: center;color: #993300;;">47</td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">24</td><td style="font-weight: bold;text-align: center;color: #993300;;">23-02-2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">31</td><td style="font-weight: bold;text-align: center;color: #993300;;">45</td><td style="font-weight: bold;text-align: center;color: #993300;;">53</td><td style="font-weight: bold;text-align: center;color: #993300;;">59</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="font-weight: bold;text-align: center;color: #993300;;">34</td><td style="font-weight: bold;text-align: center;color: #993300;;">36</td><td style="font-weight: bold;text-align: center;color: #993300;;">48</td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">25</td><td style="font-weight: bold;text-align: center;color: #993300;;">24-02-2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">49</td><td style="font-weight: bold;text-align: center;color: #993300;;">51</td><td style="font-weight: bold;text-align: center;color: #993300;;">54</td><td style="font-weight: bold;text-align: center;color: #993300;;">40</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="font-weight: bold;text-align: center;color: #993300;;">60</td><td style="text-align: center;;"></td><td style="font-weight: bold;text-align: center;color: #993300;;">31</td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">26</td><td style="font-weight: bold;text-align: center;color: #993300;;">25-02-2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">30</td><td style="font-weight: bold;text-align: center;color: #993300;;">50</td><td style="text-align: center;;"></td><td style="font-weight: bold;text-align: center;color: #993300;;">53</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="font-weight: bold;text-align: center;color: #993300;;">57</td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">27</td><td style="font-weight: bold;text-align: center;color: #993300;;">26-02-2016</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="font-weight: bold;text-align: center;color: #993300;;">42</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">28</td><td style="font-weight: bold;text-align: center;color: #993300;;">27-02-2016</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">29</td><td style="font-weight: bold;text-align: center;color: #993300;;">28-02-2016</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">30</td><td style="font-weight: bold;text-align: center;color: #993300;;">29-02-2016</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></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 />

Macro:
Code:
Sub Get_Last_Values_Across_Columns()
Dim i As Long, c As Long
Sheets("Sheet1").Range("A65536").End(xlUp).Offset(1, 0).Value = "Last Figure"
lastColumn = Range("B1").End(xlToRight).Column
For c = 2 To lastColumn
lastRow = Cells(2, c).End(xlDown).Row
i = Cells(1, 1).End(xlDown).Row
Cells(i, c).Value = Cells(lastRow, c).Value
Next c
End Sub

If using excel 2007 or greater, change the Sheets("Sheet1").Range("A65536") to Sheets("Sheet1").Range("A1048576")

Results of running macro:
<b>Excel 2003</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 /><col /><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><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;text-align: center;color: #993300;;">Date</td><td style="font-weight: bold;text-align: center;color: #993300;;">List 1</td><td style="font-weight: bold;text-align: center;color: #993300;;">List 2</td><td style="font-weight: bold;text-align: center;color: #993300;;">List 3</td><td style="font-weight: bold;text-align: center;color: #993300;;">List 4</td><td style="font-weight: bold;text-align: center;color: #993300;;">List 5</td><td style="font-weight: bold;text-align: center;color: #993300;;">List 6</td><td style="font-weight: bold;text-align: center;color: #993300;;">List 7</td><td style="font-weight: bold;text-align: center;color: #993300;;">List 8</td><td style="font-weight: bold;text-align: center;color: #993300;;">List 9</td><td style="font-weight: bold;text-align: center;color: #993300;;">List 10</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="font-weight: bold;text-align: center;color: #993300;;">1/2/2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">45</td><td style="font-weight: bold;text-align: center;color: #993300;;">57</td><td style="font-weight: bold;text-align: center;color: #993300;;">33</td><td style="font-weight: bold;text-align: center;color: #993300;;">48</td><td style="font-weight: bold;text-align: center;color: #993300;;">37</td><td style="font-weight: bold;text-align: center;color: #993300;;">61</td><td style="font-weight: bold;text-align: center;color: #993300;;">49</td><td style="font-weight: bold;text-align: center;color: #993300;;">46</td><td style="font-weight: bold;text-align: center;color: #993300;;">38</td><td style="font-weight: bold;text-align: center;color: #993300;;">50</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="font-weight: bold;text-align: center;color: #993300;;">2/2/2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">44</td><td style="font-weight: bold;text-align: center;color: #993300;;">57</td><td style="font-weight: bold;text-align: center;color: #993300;;">35</td><td style="font-weight: bold;text-align: center;color: #993300;;">44</td><td style="font-weight: bold;text-align: center;color: #993300;;">45</td><td style="font-weight: bold;text-align: center;color: #993300;;">55</td><td style="font-weight: bold;text-align: center;color: #993300;;">30</td><td style="font-weight: bold;text-align: center;color: #993300;;">56</td><td style="font-weight: bold;text-align: center;color: #993300;;">57</td><td style="font-weight: bold;text-align: center;color: #993300;;">47</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="font-weight: bold;text-align: center;color: #993300;;">3/2/2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">36</td><td style="font-weight: bold;text-align: center;color: #993300;;">44</td><td style="font-weight: bold;text-align: center;color: #993300;;">55</td><td style="font-weight: bold;text-align: center;color: #993300;;">34</td><td style="font-weight: bold;text-align: center;color: #993300;;">62</td><td style="font-weight: bold;text-align: center;color: #993300;;">31</td><td style="font-weight: bold;text-align: center;color: #993300;;">52</td><td style="font-weight: bold;text-align: center;color: #993300;;">60</td><td style="font-weight: bold;text-align: center;color: #993300;;">30</td><td style="font-weight: bold;text-align: center;color: #993300;;">44</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="font-weight: bold;text-align: center;color: #993300;;">4/2/2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">44</td><td style="font-weight: bold;text-align: center;color: #993300;;">37</td><td style="font-weight: bold;text-align: center;color: #993300;;">61</td><td style="font-weight: bold;text-align: center;color: #993300;;">32</td><td style="font-weight: bold;text-align: center;color: #993300;;">61</td><td style="font-weight: bold;text-align: center;color: #993300;;">45</td><td style="font-weight: bold;text-align: center;color: #993300;;">35</td><td style="font-weight: bold;text-align: center;color: #993300;;">43</td><td style="font-weight: bold;text-align: center;color: #993300;;">46</td><td style="font-weight: bold;text-align: center;color: #993300;;">52</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="font-weight: bold;text-align: center;color: #993300;;">5/2/2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">44</td><td style="font-weight: bold;text-align: center;color: #993300;;">37</td><td style="font-weight: bold;text-align: center;color: #993300;;">61</td><td style="font-weight: bold;text-align: center;color: #993300;;">32</td><td style="font-weight: bold;text-align: center;color: #993300;;">61</td><td style="font-weight: bold;text-align: center;color: #993300;;">45</td><td style="font-weight: bold;text-align: center;color: #993300;;">35</td><td style="font-weight: bold;text-align: center;color: #993300;;">43</td><td style="font-weight: bold;text-align: center;color: #993300;;">46</td><td style="font-weight: bold;text-align: center;color: #993300;;">52</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="font-weight: bold;text-align: center;color: #993300;;">6/2/2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">34</td><td style="font-weight: bold;text-align: center;color: #993300;;">48</td><td style="font-weight: bold;text-align: center;color: #993300;;">47</td><td style="font-weight: bold;text-align: center;color: #993300;;">62</td><td style="font-weight: bold;text-align: center;color: #993300;;">40</td><td style="font-weight: bold;text-align: center;color: #993300;;">33</td><td style="font-weight: bold;text-align: center;color: #993300;;">62</td><td style="font-weight: bold;text-align: center;color: #993300;;">58</td><td style="font-weight: bold;text-align: center;color: #993300;;">51</td><td style="font-weight: bold;text-align: center;color: #993300;;">31</td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="font-weight: bold;text-align: center;color: #993300;;">7/2/2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">23</td><td style="font-weight: bold;text-align: center;color: #993300;;">31</td><td style="font-weight: bold;text-align: center;color: #993300;;">57</td><td style="font-weight: bold;text-align: center;color: #993300;;">37</td><td style="font-weight: bold;text-align: center;color: #993300;;">49</td><td style="font-weight: bold;text-align: center;color: #993300;;">39</td><td style="font-weight: bold;text-align: center;color: #993300;;">59</td><td style="font-weight: bold;text-align: center;color: #993300;;">30</td><td style="font-weight: bold;text-align: center;color: #993300;;">31</td><td style="font-weight: bold;text-align: center;color: #993300;;">40</td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="font-weight: bold;text-align: center;color: #993300;;">8/2/2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">43</td><td style="font-weight: bold;text-align: center;color: #993300;;">31</td><td style="font-weight: bold;text-align: center;color: #993300;;">50</td><td style="font-weight: bold;text-align: center;color: #993300;;">58</td><td style="font-weight: bold;text-align: center;color: #993300;;">46</td><td style="font-weight: bold;text-align: center;color: #993300;;">30</td><td style="font-weight: bold;text-align: center;color: #993300;;">35</td><td style="font-weight: bold;text-align: center;color: #993300;;">45</td><td style="font-weight: bold;text-align: center;color: #993300;;">48</td><td style="font-weight: bold;text-align: center;color: #993300;;">54</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="font-weight: bold;text-align: center;color: #993300;;">9/2/2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">22</td><td style="font-weight: bold;text-align: center;color: #993300;;">39</td><td style="font-weight: bold;text-align: center;color: #993300;;">44</td><td style="font-weight: bold;text-align: center;color: #993300;;">45</td><td style="font-weight: bold;text-align: center;color: #993300;;">41</td><td style="font-weight: bold;text-align: center;color: #993300;;">33</td><td style="font-weight: bold;text-align: center;color: #993300;;">62</td><td style="font-weight: bold;text-align: center;color: #993300;;">33</td><td style="font-weight: bold;text-align: center;color: #993300;;">60</td><td style="font-weight: bold;text-align: center;color: #993300;;">60</td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="font-weight: bold;text-align: center;color: #993300;;">10/2/2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">29</td><td style="font-weight: bold;text-align: center;color: #993300;;">49</td><td style="font-weight: bold;text-align: center;color: #993300;;">35</td><td style="font-weight: bold;text-align: center;color: #993300;;">58</td><td style="font-weight: bold;text-align: center;color: #993300;;">40</td><td style="font-weight: bold;text-align: center;color: #993300;;">35</td><td style="font-weight: bold;text-align: center;color: #993300;;">57</td><td style="font-weight: bold;text-align: center;color: #993300;;">31</td><td style="font-weight: bold;text-align: center;color: #993300;;">36</td><td style="font-weight: bold;text-align: center;color: #993300;;">37</td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="font-weight: bold;text-align: center;color: #993300;;">11/2/2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">43</td><td style="font-weight: bold;text-align: center;color: #993300;;">52</td><td style="font-weight: bold;text-align: center;color: #993300;;">61</td><td style="font-weight: bold;text-align: center;color: #993300;;">57</td><td style="font-weight: bold;text-align: center;color: #993300;;">61</td><td style="font-weight: bold;text-align: center;color: #993300;;">40</td><td style="font-weight: bold;text-align: center;color: #993300;;">46</td><td style="font-weight: bold;text-align: center;color: #993300;;">38</td><td style="font-weight: bold;text-align: center;color: #993300;;">34</td><td style="font-weight: bold;text-align: center;color: #993300;;">40</td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="font-weight: bold;text-align: center;color: #993300;;">12/2/2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">42</td><td style="font-weight: bold;text-align: center;color: #993300;;">50</td><td style="font-weight: bold;text-align: center;color: #993300;;">62</td><td style="font-weight: bold;text-align: center;color: #993300;;">56</td><td style="font-weight: bold;text-align: center;color: #993300;;">58</td><td style="font-weight: bold;text-align: center;color: #993300;;">50</td><td style="font-weight: bold;text-align: center;color: #993300;;">50</td><td style="font-weight: bold;text-align: center;color: #993300;;">57</td><td style="font-weight: bold;text-align: center;color: #993300;;">46</td><td style="font-weight: bold;text-align: center;color: #993300;;">32</td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="font-weight: bold;text-align: center;color: #993300;;">13-02-2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">29</td><td style="font-weight: bold;text-align: center;color: #993300;;">36</td><td style="font-weight: bold;text-align: center;color: #993300;;">39</td><td style="font-weight: bold;text-align: center;color: #993300;;">49</td><td style="font-weight: bold;text-align: center;color: #993300;;">58</td><td style="font-weight: bold;text-align: center;color: #993300;;">41</td><td style="font-weight: bold;text-align: center;color: #993300;;">34</td><td style="font-weight: bold;text-align: center;color: #993300;;">46</td><td style="font-weight: bold;text-align: center;color: #993300;;">45</td><td style="font-weight: bold;text-align: center;color: #993300;;">44</td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style="font-weight: bold;text-align: center;color: #993300;;">14-02-2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">38</td><td style="font-weight: bold;text-align: center;color: #993300;;">41</td><td style="font-weight: bold;text-align: center;color: #993300;;">31</td><td style="font-weight: bold;text-align: center;color: #993300;;">33</td><td style="font-weight: bold;text-align: center;color: #993300;;">34</td><td style="font-weight: bold;text-align: center;color: #993300;;">35</td><td style="font-weight: bold;text-align: center;color: #993300;;">35</td><td style="font-weight: bold;text-align: center;color: #993300;;">30</td><td style="font-weight: bold;text-align: center;color: #993300;;">41</td><td style="font-weight: bold;text-align: center;color: #993300;;">58</td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style="font-weight: bold;text-align: center;color: #993300;;">15-02-2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">45</td><td style="font-weight: bold;text-align: center;color: #993300;;">54</td><td style="font-weight: bold;text-align: center;color: #993300;;">47</td><td style="font-weight: bold;text-align: center;color: #993300;;">35</td><td style="font-weight: bold;text-align: center;color: #993300;;">42</td><td style="font-weight: bold;text-align: center;color: #993300;;">43</td><td style="font-weight: bold;text-align: center;color: #993300;;">61</td><td style="font-weight: bold;text-align: center;color: #993300;;">45</td><td style="font-weight: bold;text-align: center;color: #993300;;">60</td><td style="font-weight: bold;text-align: center;color: #993300;;">40</td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style="font-weight: bold;text-align: center;color: #993300;;">16-02-2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">50</td><td style="font-weight: bold;text-align: center;color: #993300;;">43</td><td style="font-weight: bold;text-align: center;color: #993300;;">58</td><td style="font-weight: bold;text-align: center;color: #993300;;">35</td><td style="font-weight: bold;text-align: center;color: #993300;;">32</td><td style="font-weight: bold;text-align: center;color: #993300;;">50</td><td style="font-weight: bold;text-align: center;color: #993300;;">45</td><td style="font-weight: bold;text-align: center;color: #993300;;">51</td><td style="font-weight: bold;text-align: center;color: #993300;;">58</td><td style="font-weight: bold;text-align: center;color: #993300;;">40</td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style="font-weight: bold;text-align: center;color: #993300;;">17-02-2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">30</td><td style="font-weight: bold;text-align: center;color: #993300;;">56</td><td style="font-weight: bold;text-align: center;color: #993300;;">33</td><td style="font-weight: bold;text-align: center;color: #993300;;">55</td><td style="font-weight: bold;text-align: center;color: #993300;;">49</td><td style="font-weight: bold;text-align: center;color: #993300;;">49</td><td style="font-weight: bold;text-align: center;color: #993300;;">36</td><td style="font-weight: bold;text-align: center;color: #993300;;">34</td><td style="font-weight: bold;text-align: center;color: #993300;;">53</td><td style="font-weight: bold;text-align: center;color: #993300;;">41</td></tr><tr ><td style="color: #161120;text-align: center;">19</td><td style="font-weight: bold;text-align: center;color: #993300;;">18-02-2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">33</td><td style="font-weight: bold;text-align: center;color: #993300;;">35</td><td style="font-weight: bold;text-align: center;color: #993300;;">49</td><td style="font-weight: bold;text-align: center;color: #993300;;">62</td><td style="font-weight: bold;text-align: center;color: #993300;;">34</td><td style="font-weight: bold;text-align: center;color: #993300;;">60</td><td style="font-weight: bold;text-align: center;color: #993300;;">41</td><td style="font-weight: bold;text-align: center;color: #993300;;">59</td><td style="font-weight: bold;text-align: center;color: #993300;;">58</td><td style="font-weight: bold;text-align: center;color: #993300;;">57</td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style="font-weight: bold;text-align: center;color: #993300;;">19-02-2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">24</td><td style="font-weight: bold;text-align: center;color: #993300;;">31</td><td style="font-weight: bold;text-align: center;color: #993300;;">60</td><td style="font-weight: bold;text-align: center;color: #993300;;">52</td><td style="font-weight: bold;text-align: center;color: #993300;;">43</td><td style="font-weight: bold;text-align: center;color: #993300;;">49</td><td style="font-weight: bold;text-align: center;color: #993300;;">33</td><td style="font-weight: bold;text-align: center;color: #993300;;">42</td><td style="font-weight: bold;text-align: center;color: #993300;;">60</td><td style="font-weight: bold;text-align: center;color: #993300;;">59</td></tr><tr ><td style="color: #161120;text-align: center;">21</td><td style="font-weight: bold;text-align: center;color: #993300;;">20-02-2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">39</td><td style="font-weight: bold;text-align: center;color: #993300;;">34</td><td style="font-weight: bold;text-align: center;color: #993300;;">37</td><td style="font-weight: bold;text-align: center;color: #993300;;">38</td><td style="font-weight: bold;text-align: center;color: #993300;;">38</td><td style="font-weight: bold;text-align: center;color: #993300;;">43</td><td style="font-weight: bold;text-align: center;color: #993300;;">54</td><td style="font-weight: bold;text-align: center;color: #993300;;">59</td><td style="font-weight: bold;text-align: center;color: #993300;;">51</td><td style="font-weight: bold;text-align: center;color: #993300;;">58</td></tr><tr ><td style="color: #161120;text-align: center;">22</td><td style="font-weight: bold;text-align: center;color: #993300;;">21-02-2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">45</td><td style="font-weight: bold;text-align: center;color: #993300;;">33</td><td style="font-weight: bold;text-align: center;color: #993300;;">44</td><td style="font-weight: bold;text-align: center;color: #993300;;">48</td><td style="font-weight: bold;text-align: center;color: #993300;;">51</td><td style="font-weight: bold;text-align: center;color: #993300;;">32</td><td style="font-weight: bold;text-align: center;color: #993300;;">48</td><td style="font-weight: bold;text-align: center;color: #993300;;">52</td><td style="font-weight: bold;text-align: center;color: #993300;;">59</td><td style="font-weight: bold;text-align: center;color: #993300;;">40</td></tr><tr ><td style="color: #161120;text-align: center;">23</td><td style="font-weight: bold;text-align: center;color: #993300;;">22-02-2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">33</td><td style="font-weight: bold;text-align: center;color: #993300;;">47</td><td style="font-weight: bold;text-align: center;color: #993300;;">52</td><td style="font-weight: bold;text-align: center;color: #993300;;">37</td><td style="text-align: center;;"></td><td style="font-weight: bold;text-align: center;color: #993300;;">59</td><td style="font-weight: bold;text-align: center;color: #993300;;">48</td><td style="font-weight: bold;text-align: center;color: #993300;;">34</td><td style="font-weight: bold;text-align: center;color: #993300;;">47</td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">24</td><td style="font-weight: bold;text-align: center;color: #993300;;">23-02-2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">31</td><td style="font-weight: bold;text-align: center;color: #993300;;">45</td><td style="font-weight: bold;text-align: center;color: #993300;;">53</td><td style="font-weight: bold;text-align: center;color: #993300;;">59</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="font-weight: bold;text-align: center;color: #993300;;">34</td><td style="font-weight: bold;text-align: center;color: #993300;;">36</td><td style="font-weight: bold;text-align: center;color: #993300;;">48</td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">25</td><td style="font-weight: bold;text-align: center;color: #993300;;">24-02-2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">49</td><td style="font-weight: bold;text-align: center;color: #993300;;">51</td><td style="font-weight: bold;text-align: center;color: #993300;;">54</td><td style="font-weight: bold;text-align: center;color: #993300;;">40</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="font-weight: bold;text-align: center;color: #993300;;">60</td><td style="text-align: center;;"></td><td style="font-weight: bold;text-align: center;color: #993300;;">31</td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">26</td><td style="font-weight: bold;text-align: center;color: #993300;;">25-02-2016</td><td style="font-weight: bold;text-align: center;color: #993300;;">30</td><td style="font-weight: bold;text-align: center;color: #993300;;">50</td><td style="text-align: center;;"></td><td style="font-weight: bold;text-align: center;color: #993300;;">53</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="font-weight: bold;text-align: center;color: #993300;;">57</td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">27</td><td style="font-weight: bold;text-align: center;color: #993300;;">26-02-2016</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="font-weight: bold;text-align: center;color: #993300;;">42</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">28</td><td style="font-weight: bold;text-align: center;color: #993300;;">27-02-2016</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">29</td><td style="font-weight: bold;text-align: center;color: #993300;;">28-02-2016</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">30</td><td style="font-weight: bold;text-align: center;color: #993300;;">29-02-2016</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">31</td><td style="font-weight: bold;text-align: center;color: #993300;;">Last Figure</td><td style="font-weight: bold;text-align: center;color: #993300;;">30</td><td style="font-weight: bold;text-align: center;color: #993300;;">50</td><td style="font-weight: bold;text-align: center;color: #993300;;">54</td><td style="font-weight: bold;text-align: center;color: #993300;;">42</td><td style="font-weight: bold;text-align: center;color: #993300;;">51</td><td style="font-weight: bold;text-align: center;color: #993300;;">59</td><td style="font-weight: bold;text-align: center;color: #993300;;">60</td><td style="font-weight: bold;text-align: center;color: #993300;;">36</td><td style="font-weight: bold;text-align: center;color: #993300;;">57</td><td style="font-weight: bold;text-align: center;color: #993300;;">40</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 />
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
Faster option, which is also robust against interspersed error values...

=LOOKUP(9.99999999999999E+307,B1:B30)
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,110
Messages
5,768,153
Members
425,458
Latest member
Jaspal1996

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