| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting array formula
Check your other post, too.
driller wrote: Good day, Please help me prepare a sorted column of infos based on below (e.g) table In sheet 1 col A col B col C col D col E row 1 NAME 100 105 215 280 row 2 ABC A1 A2 row 3 CDE C1 C2 row 4 DEF X1 X3 row 5 FGH F1 F2 Result desired thru formulation In Sheet 2 (e.g) col A col B col C row 1 NAME SN SQ row 2 ABC A1 100 row 3 ABC A2 105 row 4 CDE C1 105 row 5 CDE C2 215 row 6 DEF X1 100 row 7 DEF X3 280 row 8 FGH F1 105 row 9 FGH F2 280 looking for short or long formula. TIA -- regards, -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems when sorting data containing array formulas | Excel Worksheet Functions | |||
| Array Formula | Excel Worksheet Functions | |||
| Sorting within an array | Excel Discussion (Misc queries) | |||
| meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
| Array Formula - using LEFT("text",4) in formula | Excel Worksheet Functions | |||
Hybrid Mode
