![]() |
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