+ Reply to Thread
Results 1 to 2 of 2

Find Cells in Array and Return Value Next to It

Hybrid View

  1. #1
    Registered User
    Join Date
    02-08-2013
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2013
    Posts
    12

    Find Cells in Array and Return Value Next to It

    I am making a Workout log spreadsheet (attached). On my front page, I have the maximum weight lifted for an exercise which was found using a LARGE function with an array from another sheet that lists the workout results by day. I would like to find the largest weight lifted in that array, and display the value of the cell directly to the left (which contains the repetitions of the weight lifted). HOWEVER, that weight may have been lifted many times on different days, so, I would like to display the largest result. (For example, if someone lifts 250 pounds 10 times on monday, 15 times on wednesday, and 25 times on friday, then it would display "25" because it is the largest value of any cell that is directly to the left of a cell containing "250"). I have attached my spreadsheet for reference.

    The Cell with the LARGEST weight is displayed in the bar under "BEST PERFORMANCES", and the cell that should display the largest Repetition found should be directly below it.PIKE Fit Club Exercise Log.xlsx

  2. #2
    Registered User
    Join Date
    02-08-2013
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2013
    Posts
    12

    Re: Find Cells in Array and Return Value Next to It

    bump. Any help would be greatly appreciated!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1