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
Bookmarks