Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I want to sift for one cell in a row, then have the other cells retrieved
also. Say the data table is this: A B C 1 110 8 7 2 130 11 8 3 90 5 6 In cell A20 I enter =small(A1:A3,1) In cell A21 I enter =small(A1:A3,2) In cell A22 I enter =small(A1:A3,3) Here is the result I want. A B C 20 90 5 6 21 110 8 7 22 130 11 8 So I know how to get column A, but how about the rest of the row? Thanks in advance for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Retrieve multiple data rows data from a very long list and copy t | Excel Discussion (Misc queries) | |||
Retrieve xml data from SharePoint | Excel Worksheet Functions | |||
Retrieve data | Excel Discussion (Misc queries) | |||
How can I retrieve deleted data? | Excel Discussion (Misc queries) | |||
Retrieve last cell with data | Excel Worksheet Functions |