| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I return entire row for column value returned
I am trying to return the top 3 values from a column in a worksheet to
another worksheet I am able to return the lowest value using index, match and then have been able to used the =sum(small(data),{2} for the 2nd and {3} for the 3rd. However this is only for the one cell I am ranking and want to return the entire row values as well. There are approx 10 other columns of data in the row I am wanting to return, any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
| Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| return left most part of cell | Excel Worksheet Functions | |||
| Pivot Table Zero Value | Excel Discussion (Misc queries) | |||
| How do I return an entire row of data from a reference array? | Excel Worksheet Functions | |||
Threaded Mode
