+ Reply to Thread
Results 1 to 4 of 4

copy cells based on answer to formula

  1. 09-25-2014, 10:57 AM #1
    luckymusictron
    luckymusictron is offline
    Registered User
    Join Date
    09-25-2014
    Location
    Madison, WI
    MS-Off Ver
    2010
    Posts
    2

    copy cells based on answer to formula

    I'm trying to automatically copy the contents of one cell based on the formula of a different cell. Below is my example.

    I have a list of people who have raised money for a fundraiser. I have used the LARGE function to determine the 1st, 2nd, and 3rd largest fundraising amounts but I want to copy the names associated with those amounts to a different cell. Is this possible?

    Excel Question.png
    Reply With QuoteRegister To Reply
  2. 09-25-2014, 11:44 AM #2
    bbott
    bbott is offline
    Registered User
    Join Date
    05-30-2014
    Location
    Wisconsin, USA
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: copy cells based on answer to formula

    Try this in B9:

    =INDEX($A$2:$C$6,MATCH(LARGE($C$2:$C$6,ROW(A1)),$C$2:$C$6,0),COLUMN(A1))

    copy down and across as needed.
    Last edited by bbott; 09-25-2014 at 12:07 PM.
    Please 'Add Reputation' if my advice was helpful.
    Reply With QuoteRegister To Reply
  3. 09-25-2014, 11:48 AM #3
    luckymusictron
    luckymusictron is offline
    Registered User
    Join Date
    09-25-2014
    Location
    Madison, WI
    MS-Off Ver
    2010
    Posts
    2

    Re: copy cells based on answer to formula

    That's brilliant. Thank you!
    Reply With QuoteRegister To Reply
  4. 09-25-2014, 12:06 PM #4
    bbott
    bbott is offline
    Registered User
    Join Date
    05-30-2014
    Location
    Wisconsin, USA
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: copy cells based on answer to formula

    Quote Originally Posted by luckymusictron View Post
    That's brilliant. Thank you!
    You're welcome.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copy correct multiple choice answer into field based on number identifier
    By tlnllc in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-24-2014, 09:12 AM
  2. Copy correct multiple choice answer into blank field based on corresponding # identifier
    By tlnllc in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-23-2014, 08:11 PM
  3. Formula to copy and paste data in cells to other cells based on values
    By haleakala17 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-11-2012, 08:45 AM
  4. Sum based on value in another column: Copy formula in all cells.
    By ejfink11 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-26-2011, 05:01 PM
  5. change format of cells (bold, italic) based on one cell's answer
    By Jabi in forum Excel General
    Replies: 4
    Last Post: 05-25-2006, 07:35 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1