Hi all,
just wondering if I can arrange numbers in a coloum in a sequence if for
example they are entered as 134526, 146352, 123456 and rearrange them in
order of 123456, 134526, 146352 and so on.
Thanks
Joe
Joe --
Select the range you want to sort, and then click Datagt;Sort. If you have a
table of multiple columns and you want to keep the rows intact, select the
entire table first, then do Datagt;Sort. You'll get a window asking which
columns you want to sort by, and whether increasing or decreasing.
HTH
quot;Joequot; wrote:
gt; Hi all,
gt; just wondering if I can arrange numbers in a coloum in a sequence if for
gt; example they are entered as 134526, 146352, 123456 and rearrange them in
gt; order of 123456, 134526, 146352 and so on.
gt;
gt; Thanks
gt; Joe
Thank You very much pdberger it seems to be working, I hope it will work on
the sheet that I want to sort
Regards
Joequot;pdbergerquot; wrote:
gt; Joe --
gt;
gt; Select the range you want to sort, and then click Datagt;Sort. If you have a
gt; table of multiple columns and you want to keep the rows intact, select the
gt; entire table first, then do Datagt;Sort. You'll get a window asking which
gt; columns you want to sort by, and whether increasing or decreasing.
gt;
gt; HTH
gt;
gt; quot;Joequot; wrote:
gt;
gt; gt; Hi all,
gt; gt; just wondering if I can arrange numbers in a coloum in a sequence if for
gt; gt; example they are entered as 134526, 146352, 123456 and rearrange them in
gt; gt; order of 123456, 134526, 146352 and so on.
gt; gt;
gt; gt; Thanks
gt; gt; Joe
- Dec 18 Mon 2006 20:34
Arrange numbers in a sequence
close
全站熱搜
留言列表
發表留言