Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort column B but keep value in column A with value column B
I need to sort column B from largest to smallest, but I need the value in
column A that is paired to the value in column B to STAY WITH the value in column B once it gets sorted. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort column B but keep value in column A with value column B
Select both Col A and B Data Sort sort by Col B, and click on
'Desending. Thanks. -- when u change the way u look @ things, the things u look at change. "Madscientist29" wrote: I need to sort column B from largest to smallest, but I need the value in column A that is paired to the value in column B to STAY WITH the value in column B once it gets sorted. |
#3
|
|||
|
|||
Select the range of values in column B and click the Sort Descending icon in the Toolbar, the Sort Warning dialog box will open; select, "Expand the selection" and click the Sort button. Column A will reference the values in column B accordingly.
Last edited by GoBow777 : March 21st 08 at 08:53 PM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
my column is sorted in two sections. How do I sort entire column? | Excel Discussion (Misc queries) | |||
my column is sorted in two sections. How do I sort entire column? | Excel Discussion (Misc queries) | |||
HOW TO SORT A COLUMN THE SAME AS ANOTHER COLUMN WITH SIMILAR CONT. | Excel Worksheet Functions |