Results 1 to 9 of 9

Find the MAX value of changing sets

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-11-2011
    Location
    Frederick, MD, USA
    MS-Off Ver
    Excel 2007
    Posts
    125

    Find the MAX value of changing sets

    I've been fiddling with how to do this for a coupe of hours, to no avail. Time to ask the experts!

    Given three columns (SET, SAMPLE, and SIZE), I'd like a formula in a fourth column that give the maximum value of SIZE for all rows that match both SET and SAMPLE. There's got to be a simple way to do this, but my brain just isn't functioning at 100% today.

    My only real restriction is that it must be a formula, not VBA or anything.

    Example datasheet attached.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. changing alternatives in different sets
    By anmol786 in forum Excel General
    Replies: 0
    Last Post: 01-13-2015, 05:51 AM
  2. Replies: 6
    Last Post: 12-09-2013, 07:46 AM
  3. Replies: 1
    Last Post: 07-22-2010, 08:39 AM
  4. Replies: 2
    Last Post: 01-08-2008, 06:16 PM
  5. changing between sets of data
    By crowner in forum Excel General
    Replies: 3
    Last Post: 05-05-2007, 09:43 AM
  6. 27 sets of data. Need to find zero in each set
    By Cygnusx1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-09-2005, 01:05 PM

Tags for this Thread

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