| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting a Column and taking row information with it.
Please help.
In Column "A", I have number 4567 with information pertaining to 4567 in row A5. When I try to sort Column "A" by numbers the information does not move with it. For example: A10 has number 3456 and information pertaining to 3456 is in that row. However, when I sort column "A", it DOES sort that column by numbers like I want it to. But it DOES NOT move the information with it. The information for 3456 shows the information the pertains to 4567. Does anyone know how to make this work the way I want it to.? I'm not real knowledgeable about this sort of thing, so please, is there someone out there that could walk me thru this.? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sorting a Column and taking row information with it.
Suppose you have 5 cols of data, cols A to E. Just select cols A to E, then
do the sort by col A. This should do it. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Michaela" wrote: Please help. In Column "A", I have number 4567 with information pertaining to 4567 in row A5. When I try to sort Column "A" by numbers the information does not move with it. For example: A10 has number 3456 and information pertaining to 3456 is in that row. However, when I sort column "A", it DOES sort that column by numbers like I want it to. But it DOES NOT move the information with it. The information for 3456 shows the information the pertains to 4567. Does anyone know how to make this work the way I want it to.? I'm not real knowledgeable about this sort of thing, so please, is there someone out there that could walk me thru this.? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sorting a Column and taking row information with it.
see response to your posting in Excel.misc
Please do not multipost. -- Regards Roger Govier "Michaela" wrote in message ... Please help. In Column "A", I have number 4567 with information pertaining to 4567 in row A5. When I try to sort Column "A" by numbers the information does not move with it. For example: A10 has number 3456 and information pertaining to 3456 is in that row. However, when I sort column "A", it DOES sort that column by numbers like I want it to. But it DOES NOT move the information with it. The information for 3456 shows the information the pertains to 4567. Does anyone know how to make this work the way I want it to.? I'm not real knowledgeable about this sort of thing, so please, is there someone out there that could walk me thru this.? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying forumla for vlook up but changing the column Index # | Excel Worksheet Functions | |||
| Taking a remainder amount from a column and adding it another colu | Excel Discussion (Misc queries) | |||
| Advice sought: Multiple column sorting | Excel Worksheet Functions | |||
| Taking Columns that are horizaontial into a vretical column | Excel Discussion (Misc queries) | |||
| Combining workbooks with some variable field names | Excel Discussion (Misc queries) | |||
Linear Mode
