how to get ascending or values in one column

Microsoft Excel 2003 (full product)
November 6, 2010 at 09:30:05
Specs: Windows XP
how to get ascending or values in one column from a full worksheet to other worksheet

pls see the below what i am having in my worksheet. and in the end i am showing what i want in bold


a b c d e f g h i J
lower
uper
60 59 58 56 52 49 48 45
1 60 29.50 29.00 28.00 26.00 24.50 24.00 22.50
2 59 30.51 29.49 28.47 26.44 24.92 24.41 22.88
3 58 31.03 30.52 28.97 26.90 25.34 24.83 23.28
4 56 32.14 31.61 31.07 27.86 26.25 25.71 24.11
5 52 34.62 34.04 33.46 32.31 28.27 27.69 25.96
6 49 36.73 36.12 35.51 34.29 31.84 29.39 27.55
7 48 37.50 36.88 36.25 35.00 32.50 30.63 28.13
8 45 40.00 39.33 38.67 37.33 34.67 32.67 32.00
9 44 40.91 40.23 39.55 38.18 35.45 33.41 32.73 30.68
10 42 42.86 42.14 41.43 40.00 37.14 35.00 34.29 32.14
11 40 45.00 44.25 43.50 42.00 39.00 36.75 36.00 33.75
12 40 45.00 44.25 43.50 42.00 39.00 36.75 36.00 33.75

***********************************************************************

1 22.50 60 45
2 22.88 59 45
3 23.28 58 45


See More: how to get ascending or values in one column

Report •

#1
November 6, 2010 at 12:12:27
First off, there is nothing in bold in your post. Click the bold tags above the reply box and place your data between them to make it bold.

Second, use the pre tags to line up your data in columns to make it easier for us to read.

The instructions for using the pre tags can be found in this How-To.

Note: You can not use the bold tags inside the pre tags.

DerbyDad03
Office Forum Moderator


Report •
Related Solutions


Ask Question