Data Sorting Issues

G

GDBR

New Member
Joined
Sep 8, 2009
Messages
25
Hey Guys,

I'm having some issues trying to sort out some data. I have another computer program that creates a .csv file of drill holes which I manually add into excel (shown in red). I then use a formula to break the list into particular Hole ID and its associated depth (shown in blue). The issue I'm having is getting the hole ID and depths for B,C,D,.... holes to align with holes of similar ID.


<table border="0" cellpadding="0" cellspacing="0" height="674" width="576"><tbody><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt; width: 37pt;" height="20" width="49"> <table border="0" cellpadding="0" cellspacing="0" width="795"><col style="width: 37pt;" width="49"> <col style="width: 58pt;" width="77"> <col style="width: 63pt;" width="84"> <col style="width: 53pt;" width="71"> <col style="width: 62pt;" width="82"> <col style="width: 48pt;" width="64"> <col style="width: 36pt;" width="48"> <col style="width: 48pt;" span="2" width="64"> <col style="width: 48pt;" width="64"> <col style="width: 48pt;" span="2" width="64"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl74" style="height: 15pt; width: 37pt;" height="20" width="49">ID</td> <td class="xl74" style="width: 58pt;" width="77">NORTHING</td> <td class="xl74" style="width: 63pt;" width="84">EASTING</td> <td class="xl74" style="width: 53pt;" width="71">COLLAR RL</td> <td class="xl74" style="width: 62pt;" width="82">HOLE DEPTH</td> <td class="xl74" style="width: 48pt;" width="64">AZIMUTH</td> <td class="xl74" style="width: 36pt;" width="48">ANGLE</td> <td style="width: 48pt;" width="64">
</td> <td style="width: 48pt;" width="64">A</td> <td style="width: 48pt;" width="64">
</td> <td style="width: 48pt;" width="64">B</td> <td style="width: 48pt;" width="64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl74" style="height: 15pt;" height="20">A100</td> <td class="xl74" align="right">760834.138</td> <td class="xl74" align="right">6425367.277</td> <td class="xl74" align="right">426.35</td> <td class="xl74" align="right">16.66</td> <td class="xl74" align="right">0</td> <td class="xl74" align="right">-90</td> <td>
</td> <td>A100</td> <td align="right">16.66</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl74" style="height: 15pt;" height="20">A101</td> <td class="xl74" align="right">760826.215</td> <td class="xl74" align="right">6425363.008</td> <td class="xl74" align="right">426.53</td> <td class="xl74" align="right">16.54</td> <td class="xl74" align="right">0</td> <td class="xl74" align="right">-90</td> <td>
</td> <td>A101</td> <td align="right">16.54</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl74" style="height: 15pt;" height="20">A102</td> <td class="xl74" align="right">760818.293</td> <td class="xl74" align="right">6425358.738</td> <td class="xl74" align="right">426.53</td> <td class="xl74" align="right">16.24</td> <td class="xl74" align="right">0</td> <td class="xl74" align="right">-90</td> <td>
</td> <td>A102</td> <td align="right">16.24</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl74" style="height: 15pt;" height="20">A103</td> <td class="xl74" align="right">760810.37</td> <td class="xl74" align="right">6425354.468</td> <td class="xl74" align="right">426.35</td> <td class="xl74" align="right">15.75</td> <td class="xl74" align="right">0</td> <td class="xl74" align="right">-90</td> <td>
</td> <td>A103</td> <td align="right">15.75</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl74" style="height: 15pt;" height="20">A104</td> <td class="xl74" align="right">760802.447</td> <td class="xl74" align="right">6425350.198</td> <td class="xl74" align="right">426.17</td> <td class="xl74" align="right">16.27</td> <td class="xl74" align="right">0</td> <td class="xl74" align="right">-90</td> <td>
</td> <td>A104</td> <td align="right">16.27</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl74" style="height: 15pt;" height="20">A105</td> <td class="xl74" align="right">760794.525</td> <td class="xl74" align="right">6425345.928</td> <td class="xl74" align="right">425.95</td> <td class="xl74" align="right">17.1</td> <td class="xl74" align="right">0</td> <td class="xl74" align="right">-90</td> <td>
</td> <td>A105</td> <td align="right">17.1</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl74" style="height: 15pt;" height="20">A106</td> <td class="xl74" align="right">760786.602</td> <td class="xl74" align="right">6425341.658</td> <td class="xl74" align="right">425.77</td> <td class="xl74" align="right">17.97</td> <td class="xl74" align="right">0</td> <td class="xl74" align="right">-90</td> <td>
</td> <td>A106</td> <td align="right">17.97</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl74" style="height: 15pt;" height="20">A107</td> <td class="xl74" align="right">760778.679</td> <td class="xl74" align="right">6425337.389</td> <td class="xl74" align="right">425.58</td> <td class="xl74" align="right">18.46</td> <td class="xl74" align="right">0</td> <td class="xl74" align="right">-90</td> <td>
</td> <td>A107</td> <td align="right">18.46</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl74" style="height: 15pt;" height="20">A108</td> <td class="xl74" align="right">760770.757</td> <td class="xl74" align="right">6425333.119</td> <td class="xl74" align="right">425.38</td> <td class="xl74" align="right">18.96</td> <td class="xl74" align="right">0</td> <td class="xl74" align="right">-90</td> <td>
</td> <td>A108</td> <td align="right">18.96</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl74" style="height: 15pt;" height="20">A109</td> <td class="xl74" align="right">760762.834</td> <td class="xl74" align="right">6425328.849</td> <td class="xl74" align="right">426.08</td> <td class="xl74" align="right">19.79</td> <td class="xl74" align="right">0</td> <td class="xl74" align="right">-90</td> <td>
</td> <td>A109</td> <td align="right">19.79</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl74" style="height: 15pt;" height="20">A110</td> <td class="xl74" align="right">760754.911</td> <td class="xl74" align="right">6425324.579</td> <td class="xl74" align="right">424.69</td> <td class="xl74" align="right">18.38</td> <td class="xl74" align="right">0</td> <td class="xl74" align="right">-90</td> <td>
</td> <td>A110</td> <td align="right">18.38</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl74" style="height: 15pt;" height="20">A111</td> <td class="xl74" align="right">760746.989</td> <td class="xl74" align="right">6425320.309</td> <td class="xl74" align="right">424.47</td> <td class="xl74" align="right">18.16</td> <td class="xl74" align="right">0</td> <td class="xl74" align="right">-90</td> <td>
</td> <td>A111</td> <td align="right">18.16</td> <td>
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl74" style="height: 15pt;" height="20">B100</td> <td class="xl74" align="right">760841.704</td> <td class="xl74" align="right">6425361.111</td> <td class="xl74" align="right">426.82</td> <td class="xl74" align="right">17.14</td> <td class="xl74" align="right">0</td> <td class="xl74" align="right">-90</td> <td>
</td> <td>
</td> <td>
</td> <td>B100</td> <td align="right">17.14</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl74" style="height: 15pt;" height="20">B101</td> <td class="xl74" align="right">760834.445</td> <td class="xl74" align="right">6425357.219</td> <td class="xl74" align="right">426.74</td> <td class="xl74" align="right">16.77</td> <td class="xl74" align="right">0</td> <td class="xl74" align="right">-90</td> <td>
</td> <td>
</td> <td>
</td> <td>B101</td> <td align="right">16.77</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl74" style="height: 15pt;" height="20">B102</td> <td class="xl74" align="right">760826.523</td> <td class="xl74" align="right">6425352.949</td> <td class="xl74" align="right">426.75</td> <td class="xl74" align="right">16.47</td> <td class="xl74" align="right">0</td> <td class="xl74" align="right">-90</td> <td>
</td> <td>
</td> <td>
</td> <td>B102</td> <td align="right">16.47</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl74" style="height: 15pt;" height="20">B103</td> <td class="xl74" align="right">760818.6</td> <td class="xl74" align="right">6425348.68</td> <td class="xl74" align="right">426.94</td> <td class="xl74" align="right">16.34</td> <td class="xl74" align="right">0</td> <td class="xl74" align="right">-90</td> <td>
</td> <td>
</td> <td>
</td> <td>B103</td> <td align="right">16.34</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl74" style="height: 15pt;" height="20">B104</td> <td class="xl74" align="right">760810.677</td> <td class="xl74" align="right">6425344.41</td> <td class="xl74" align="right">426.59</td> <td class="xl74" align="right">15.66</td> <td class="xl74" align="right">0</td> <td class="xl74" align="right">-90</td> <td>
</td> <td>
</td> <td>
</td> <td>B104</td> <td align="right">15.66</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl74" style="height: 15pt;" height="20">B105</td> <td class="xl74" align="right">760802.755</td> <td class="xl74" align="right">6425340.14</td> <td class="xl74" align="right">426.47</td> <td class="xl74" align="right">16.53</td> <td class="xl74" align="right">0</td> <td class="xl74" align="right">-90</td> <td>
</td> <td>
</td> <td>
</td> <td>B105</td> <td align="right">16.53</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl74" style="height: 15pt;" height="20">B106</td> <td class="xl74" align="right">760794.832</td> <td class="xl74" align="right">6425335.87</td> <td class="xl74" align="right">426.22</td> <td class="xl74" align="right">17.69</td> <td class="xl74" align="right">0</td> <td class="xl74" align="right">-90</td> <td>
</td> <td>
</td> <td>
</td> <td>B106</td> <td align="right">17.69</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl74" style="height: 15pt;" height="20">B107</td> <td class="xl74" align="right">760786.909</td> <td class="xl74" align="right">6425331.6</td> <td class="xl74" align="right">425.95</td> <td class="xl74" align="right">18.69</td> <td class="xl74" align="right">0</td> <td class="xl74" align="right">-90</td> <td>
</td> <td>
</td> <td>
</td> <td>B107</td> <td align="right">18.69</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl74" style="height: 15pt;" height="20">B108</td> <td class="xl74" align="right">760778.987</td> <td class="xl74" align="right">6425327.33</td> <td class="xl74" align="right">425.67</td> <td class="xl74" align="right">18.88</td> <td class="xl74" align="right">0</td> <td class="xl74" align="right">-90</td> <td>
</td> <td>
</td> <td>
</td> <td>B108</td> <td align="right">18.88</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl74" style="height: 15pt;" height="20">B109</td> <td class="xl74" align="right">760771.064</td> <td class="xl74" align="right">6425323.061</td> <td class="xl74" align="right">425.42</td> <td class="xl74" align="right">18.98</td> <td class="xl74" align="right">0</td> <td class="xl74" align="right">-90</td> <td>
</td> <td>
</td> <td>
</td> <td>B109</td> <td align="right">18.98</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl74" style="height: 15pt;" height="20">B110</td> <td class="xl74" align="right">760763.141</td> <td class="xl74" align="right">6425318.791</td> <td class="xl74" align="right">426.59</td> <td class="xl74" align="right">20.19</td> <td class="xl74" align="right">0</td> <td class="xl74" align="right">-90</td> <td>
</td> <td>
</td> <td>
</td> <td>B110</td> <td align="right">20.19</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl74" style="height: 15pt;" height="20">B111</td> <td class="xl74" align="right">760755.219</td> <td class="xl74" align="right">6425314.521</td> <td class="xl74" align="right">424.78</td> <td class="xl74" align="right">18.39</td> <td class="xl74" align="right">0</td> <td class="xl74" align="right">-90</td> <td>
</td> <td>
</td> <td>
</td> <td>B111</td> <td align="right">18.39</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl74" style="height: 15pt;" height="20">B112</td> <td class="xl74" align="right">760748.327</td> <td class="xl74" align="right">6425310.983</td> <td class="xl74" align="right">424.74</td> <td class="xl74" align="right">18.36</td> <td class="xl74" align="right">0</td> <td class="xl74" align="right">-90</td> <td>
</td> <td>
</td> <td>
</td> <td>B112</td> <td align="right">18.36</td> </tr> </tbody></table></td><td class="xl72" style="width: 58pt;" width="77">
</td><td class="xl72" style="width: 63pt;" width="84">
</td><td class="xl72" style="width: 53pt;" width="71">
</td><td class="xl72" style="width: 62pt;" width="82">
</td><td class="xl72" style="width: 48pt;" width="64">
</td><td class="xl72" style="width: 36pt;" width="48">
</td><td style="width: 48pt;" width="64">
</td><td style="width: 48pt;" width="64">
</td><td style="width: 48pt;" width="64">
</td><td style="width: 48pt;" width="64">

</td><td style="width: 48pt;" width="64">
</td><td style="width: 48pt;" width="64">
</td><td style="width: 48pt;" width="64">
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
What I'm going for is having the data sorted like this;

A100 16.7 B100 17.7 C100 17.9
A101 17.1 B101 17.8 C101 18.8

Any help would be great.

</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td><td align="right">
</td><td>
</td><td>
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td><td align="right">
</td><td>
</td><td>
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td><td align="right">
</td><td>
</td><td>
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td><td align="right">
</td><td>
</td><td>
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td><td align="right">
</td><td>
</td><td>
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td><td align="right">
</td><td>
</td><td>
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td><td align="right">
</td><td>
</td><td>
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td><td align="right">
</td><td>
</td><td>
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td><td align="right">
</td><td>
</td><td>
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td><td align="right">
</td><td>
</td><td>
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td><td align="right">
</td><td>
</td><td>
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td><td align="right">
</td><td>
</td><td>
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td><td align="right">
</td><td>
</td><td>
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td align="right">
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td align="right">
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td align="right">
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td align="right">
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td align="right">
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td align="right">
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td align="right">
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td align="right">
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td align="right">
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td align="right">
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td align="right">
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td align="right">
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td align="right">
</td></tr><tr style="height: 15pt;" height="20"><td class="xl72" style="height: 15pt;" height="20">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td class="xl72" align="right">
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td align="right">
</td></tr></tbody></table>
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
622
smozgur
smozgur
E
  • Question Question
VBA code clean up
Replies
9
Views
580
mumps
mumps
D
  • Question Question
Problems Encountered When Generating VBA Excel Charts with 15-Minute Interval Data.
Replies
0
Views
366
dilshod_k
D
E
  • Question Question
VBA for Web Scraping help
Replies
0
Views
921
epactheactor
E
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
2K
CrashOD
C

Forum statistics

Threads
1,224,574
Messages
6,179,626
Members
452,933
Latest member
patv

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