Help with Excel
#1
Help with Excel
Dont know if what I want to do is possible but here goes:-
Along the top of the spreadsheet I have data in columns A,B,C,D,E they are customer addresses eg.
.......... A.........................B....................... C
----------------------------------------------------
1.|.....NAME..........|........123............|... ADDRESS
----------------------------------------------------
2.|.....NAME..........|........999............|... ADDRESS
----------------------------------------------------
3.|.....NAME..........|........555............|... ADDRESS
In column A I have their name, column B is the numerical order in which they belong, column C,D,E is their address.
I need to be able to put them in numerical order using the data in column C.
Using the ascending/decending function If I put column C into numerical order the rest of the information in the remaining columns becomes wrong as it no longer relates to the customer it used to.
How do I get the information into numerical order ?
Along the top of the spreadsheet I have data in columns A,B,C,D,E they are customer addresses eg.
.......... A.........................B....................... C
----------------------------------------------------
1.|.....NAME..........|........123............|... ADDRESS
----------------------------------------------------
2.|.....NAME..........|........999............|... ADDRESS
----------------------------------------------------
3.|.....NAME..........|........555............|... ADDRESS
In column A I have their name, column B is the numerical order in which they belong, column C,D,E is their address.
I need to be able to put them in numerical order using the data in column C.
Using the ascending/decending function If I put column C into numerical order the rest of the information in the remaining columns becomes wrong as it no longer relates to the customer it used to.
How do I get the information into numerical order ?
Last edited by zesty; 16 April 2005 at 04:02 PM.
#4
Originally Posted by DJ Dunk
Ctrl-A to select all cells, Data, Sort, Sort By Column C.
It will sort keeping the rows intact. Is this what you mean ?
It will sort keeping the rows intact. Is this what you mean ?
Yes keeping the rows intact is what I want thankyou.
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM
bluebullet29
General Technical
9
05 October 2015 02:17 PM