Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Hello, I am an excel beginner, and need some assistance. I don't excactly know how to explain this so I will to my best. I have info in 20 columns, I want to be able to sort it by any one of those columns and have the info that is next to it stay attached to the column next to it. For example, I have data in row 1 that are in cells A1 and B1 that are related, and row two, in cells A2 and B2 that are related, and so on for A3, B3.... If I wanted to sort by column A, I want the relevant data in B to move according to what was changed in A, and to do the same if I were to sort by B and have A stay attached. How do I do that? I hope that makes sense. Thank You. ~ Jason Gross -- Yupkwondo ------------------------------------------------------------------------ Yupkwondo's Profile: http://www.excelforum.com/member.php...o&userid=26391 View this thread: http://www.excelforum.com/showthread...hreadid=528791 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sum function question - easy? | Excel Worksheet Functions | |||
Easy formula Question | Excel Worksheet Functions | |||
Question about sorting in protected worksheet | Excel Worksheet Functions | |||
SORTING question | New Users to Excel | |||
easy question .... i think | Excel Discussion (Misc queries) |