Sorting a Column and taking row information with it.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort column and take row info with it. 4
Creating a list of job numbers, missing out irrelevant items 9
Returning multiple indices for a lookup 4
Add a string to a cell 2
Sorting data in one sheet 8
find all same numbers in a column without dropdown listing 3
Wanted to show formula result, not formula. How??? 5
How do I get the last number from a specific column 6

Back
Top