ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   About this forum (https://www.excelbanter.com/about-forum/)
-   -   Transferring multiple fields according to a large function (https://www.excelbanter.com/about-forum/267990-transferring-multiple-fields-according-large-function.html)

shooganooga

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


All times are GMT +1. The time now is 08:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com