+ Reply to Thread
Results 1 to 3 of 3

Array Formula with multiple criteria

  1. #1
    Forum Contributor
    Join Date
    08-22-2011
    Location
    Texas, United States
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    516

    Array Formula with multiple criteria

    Hi all,

    My problem is hard to explain so i will give you a few scenarios and any help is greatly appretiated, Thanks

    Column A-----ColumnB-----ColumnC------ColumnD
    5604-------------1--------------1--------------0
    5604-------------1--------------1--------------0
    5604-------------1--------------1--------------0
    5604-------------1--------------1--------------0
    5604-------------1--------------1--------------0
    5604-------------1--------------1--------------0
    5605-------------500-----------100-----------1
    5605-------------1--------------1--------------1
    5605-------------500-----------500-----------1
    5605-------------500-----------250-----------1
    5605-------------1--------------1--------------1
    5606-------------500-----------100-----------0
    5606-------------1000----------500-----------0
    5606-------------100-----------250-----------0
    5606-------------500-----------1000----------0
    5606-------------250-----------500-----------0


    What I am looking for is the formula for column D. What it is doing is breaking up the data for column A and comparing it. So if Column A is 5604 then look at column B, if column B is all 1's or they are all numbers other than 1, then look at Column C and if that is all 1's or all numbers other than 1 then put a 0 otherwise put a 1. Basically if the numbers in A match and the numbers in Column B and C are not all 1's or numbers other than 1, then put a 1 otherwise put a 0. I believe the only way to accomplish this is an array, but i am not sure how to formulate it. Any help would be greatly appretiated. Thanks

  2. #2
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    Re: Array Formula with multiple criteria

    Are the values ever less than 1?
    Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.

  3. #3
    Forum Contributor
    Join Date
    08-22-2011
    Location
    Texas, United States
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    516

    Re: Array Formula with multiple criteria

    well the value is really -1, there are no values less than -1, but they can range from -1 to infinity discretely.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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