Marc
Member
Registered: 11th Aug 02
Location: York
User status: Offline
|
Well Microsoft Works actually, but near enough the same!
I have a spreadsheet with 2 columns. I have column A in alphabetical order and column B correspondes to each entry in Column A.
My question is, how do I update Column A and still have the correct corresponding entry in Column B?
I have done it before, I'm sure I have but I can't figure out how to do it. 
|
Robbo
Member
Registered: 6th Aug 02
Location: London
User status: Offline
|
lookup table i would imagine
|
Sam
Moderator
Premium Member
Registered: 24th Dec 99
Location: West Midlands
User status: Offline
|
Do you mean you have two identical columns?
If so, something like =A1 for the first cell in the second column, then drag the corner down to fill the other cells?
Probably not explaining this right 
|
Marc
Member
Registered: 11th Aug 02
Location: York
User status: Offline
|
No, I have a list in column A and the list in column B correspondes with the data in A. So If I arrange A alphabetically it means everything in B is no longer in the correct order.
|
Robbo
Member
Registered: 6th Aug 02
Location: London
User status: Offline
|
lookup table
|
Marc
Member
Registered: 11th Aug 02
Location: York
User status: Offline
|
Sorry Orrob, I'm not sure what you mean.
|
Ojc
Member
Registered: 14th Nov 00
Location: Reading: Drives : Clio 197
User status: Offline
|
Are you joking? Highlight both columms and sort by whatever columm you want and it will keep the two side by side.
|
Marc
Member
Registered: 11th Aug 02
Location: York
User status: Offline
|
FFS! I was only sorting column A.
I knew it was really simple but I just couldn't figure it out 
|
dannymccann
Member
Registered: 9th Aug 06
Location: Doddington, Lincolnshire
User status: Offline
|
You can just sort column A, it will ask if you want to expand the selection, you press Yes 
|
