Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
One relatively easy way to get there ..
Assuming source data starts in row2 down Put in Z2: =IF(C2="","",C2+ROW()/10^10) Leave Z1 empty Put in AA2: =IF(ROWS($1:1)COUNT($Z:$Z),"",INDEX(A:A,MATCH(SMA LL($Z:$Z,ROWS($1:1)),$Z:$Z,0))) Copy AA2 to AC2. Select Z2:AC2, copy down to cover the max expected extent of source data, eg down to AC200? Minimize/hide away col Z. Cols AA to AC will return the required auto-sort of source cols A to C (in ascending order by the ranks in col C). Lines with tied ranks will be returned in the same relative order that they appear within the source. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "SteveC" wrote: ColA ColB Columnc Col Z Col AA Col Ab Col Ac Apples Ship 3 Apples 1 Apples Train Apples Train 1 2 Apples Tree Apples Tree 2 3 Apples Ship Pears Ball 2 4 Apples Pen Pears Rock 1 Oranges Toy 1 Apples Pen 4 Orange Mack 2 Pears Sack 3 Had data is in the first 3 columns. By inputting text into cell Z1, I would like to return the rank, category and name in the Columns AA, AB and AC in order of rank. What formulas do I use in AA, AB, and AC? Thanks a lot. I know "Max" has something to do with it. Stevec |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
column chart with 3 categories | Charts and Charting in Excel | |||
Create Stacked column of multiple values across categories | Charts and Charting in Excel | |||
Column Chart - X axis too thin because of MANY categories. | Charts and Charting in Excel | |||
How to create column of ranks. | Excel Discussion (Misc queries) | |||
how do I sort a column with several categories (ie red and blue) | Excel Worksheet Functions |