Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Transferring data from multiple worksheets Tia Excel Worksheet Functions 0 November 17th 08 04:12 PM
Transferring function results to another sheet KaKa Excel Worksheet Functions 3 April 10th 08 10:46 PM
Help with transferring data in one column to multiple columns. Ann New Users to Excel 2 April 23rd 07 12:36 PM
transferring data between multiple documents apollotommyboy Excel Discussion (Misc queries) 0 March 8th 06 06:31 PM
Sum function on multiple date fields rbrooks Excel Worksheet Functions 1 October 28th 04 09:56 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"