chequer
Board Regular
- Joined
- Oct 10, 2004
- Messages
- 62
test sort.xls | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | |||
1 | 6 | pig | c | 6 | pig | c | |||||||||
2 | 1 | rat | e | 1 | rat | e | |||||||||
3 | 8 | dog | h | 8 | dog | h | |||||||||
4 | 5 | fox | o | 5 | fox | o | |||||||||
5 | 3 | owl | f | 3 | owl | f | |||||||||
6 | 7 | hen | d | 7 | hen | d | |||||||||
7 | 4 | egg | r | 4 | egg | r | |||||||||
8 | 2 | cat | p | 2 | cat | p | |||||||||
Sheet1 |
In a worksheet, I have a range of data K1:M8, containing data, this data has been generated byK1 = A1, L1 = B1, =M1 = C1
After selecting the whole range I can't get it to sort by selecting, Sort by Colum K3, or by heading 6, that in the program contains velocities.( 1451.01235,1347.34568) etc...)
Would this be on account of the columns containing formulas?
I found out that I can do it by highlighting the whole range, K1:M8, then click K1l, and select Copy, then click on the same cell again and select Paste special/Values.
As this program will be used by members, whose computer knowledge is zilch this would be too complicated. Is there a more simple method it could be done
Going into hospital. Will reply to answers about next weekend, 16th. Sep 2006