Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have spreadsheet of several columns and rows. I have taken the row of
totals and moved them to a new column in a sorted order using (=SMALL) statistical function. The problem is I don't know how to obtain the row headings and match them up to the new column of ordered numbers. As an example below, does anyone know how to match the row names to the new column of numbers. john pat bob new column 13 22 14 16 01 10 14 33 02 12 05 44 ------------------ 16 44 33 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hyperlinks not moving with cells when data is sorted | Excel Worksheet Functions | |||
Can three separate sections of rows be sorted in the same order? | Excel Worksheet Functions | |||
Comments not moving when columns are sorted | Excel Discussion (Misc queries) | |||
series order - sorted? | Charts and Charting in Excel | |||
Why must the table for Vlookup be sorted in ascending order? | New Users to Excel |