Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Transferring multiple fields according to a large function
I have the following table and I have used the large formula to select the three highest scores from column 3 into a separate section of the spreadsheet. However I am trying to write a formula that will transfer the corresponding title from column 1 to go in the cell above these three values. Can anyone help?
1 2 3 a Mollification 12 48 b Cutoff 24 72 c Entitlement 20 69 d Power Orient 21 72 e Sentimentality 22 62 f Superoptimism 16 54 g CogIndolence 20 60 h Discontinuity 26 74 Last edited by shooganooga : January 11th 11 at 06:12 AM Reason: wrong title |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transferring data from multiple worksheets | Excel Worksheet Functions | |||
Transferring function results to another sheet | Excel Worksheet Functions | |||
Help with transferring data in one column to multiple columns. | New Users to Excel | |||
transferring data between multiple documents | Excel Discussion (Misc queries) | |||
Sum function on multiple date fields | Excel Worksheet Functions |