Data Sorting Issues

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>
 

Some videos you may like

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

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
In another column use a formula like:

=RIGHT(A2,3)&LEFT(A2,1)

and sort on that column.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,910
Messages
5,525,587
Members
409,652
Latest member
strangelyangely

This Week's Hot Topics

Top