+ Reply to Thread
Results 1 to 5 of 5

maxif equivalent function

  1. #1
    Forum Contributor
    Join Date
    01-06-2011
    Location
    cleveland
    MS-Off Ver
    Excel 2007
    Posts
    225

    maxif equivalent function

    attached is a sample of a problem i am working on.

    i have a range of numbers that i have ranked in a tier system (column d). the process behind that is not important, but for each row, i need to return the highest value for the range of the entire tier data set for the values listed in column a.

    so in this example: the 2 rows in tier 1 would each return 39 (the highest value of those two) in column e. the rows in tier 2 would each return 14 in column e, and so forth for the rest of the tiers.

    can anyone point me in the right direction? these values will not often be ordered ascending like this
    Attached Files Attached Files

  2. #2
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: maxif equivalent function

    Try: =MAX(IF($D$2:$D$60=D2,$A$2:$A$60))

    In E2 confirmed cith Ctrl+Shift+Enter as it's an array formula and copied down.

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

  3. #3
    Forum Contributor
    Join Date
    01-06-2011
    Location
    cleveland
    MS-Off Ver
    Excel 2007
    Posts
    225

    Re: maxif equivalent function

    this returns 61.99 (the max for the ENTIRE spreadsheet) for each individual cell unfortunately. this at least gives me a start though, so thank you for your time

  4. #4
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: maxif equivalent function

    Did you confirm the formula with Ctrl+Sift+Enter rather than just Enter?

    Dom

  5. #5
    Forum Contributor
    Join Date
    01-06-2011
    Location
    cleveland
    MS-Off Ver
    Excel 2007
    Posts
    225

    Re: maxif equivalent function

    oh thank you that was my mistake. thank you very much this works perfectly

+ 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