+ Reply to Thread
Results 1 to 2 of 2

Trying to find multiple criteria to tag in a formula

  1. #1
    Forum Contributor
    Join Date
    11-20-2009
    Location
    Melbourne
    MS-Off Ver
    Excel 365
    Posts
    263

    Trying to find multiple criteria to tag in a formula

    Lemice kindly gave me the following formula:
    =MAX(IF(B$2:B$10=1,C$2:C$10),IF(B$2:B$10=2,C$2:C$10))
    which will give me the Maximum value in Column C if Column B cell = 1 or 2,
    I have tried this formula and it hasn't given me the exact results I want.
    If Column B = 1 and the max value is 10 and then if Column B = 2 and the max value is 12, I need a formula that will recognise both Maximum values; so I can then place my "L" in the corresponding cells for both Maximum values.
    Eg: Col B Col C Col D
    1 12 L
    2 11 L
    1 10
    2 9
    1 12 L
    To place the "L", Lemice offered another formul:
    =IF(AND($C$2=$E$2,OR($B$2=2,$B$2=1)),"L","")
    Sorry for any confusion on my previous post regarding this and I hope that there is some type of formula that can do this.
    Thank you for any help given.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Trying to find multiple criteria to tag in a formula

    Assume that the data is present from A1 to B5 cell

    In C1 Cell - Non Array Formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Drag it down..


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ 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