Does not work, remember, the ID values occur multiple times with different conditions and I want to identify ID's only where both conditions are true, not ID's where either condition is =T. Same thing for the second one (All = "P" start).
Don't know how to be more clear. The "And" in test #1 should have been clear. Both conditions must exist before a "T" result is returned. If both conditions are not true, then return "F".
Test#1 = ID = "Corn" and "Tomato" test condition should return a "T" or "F" result (Boolean is OK)
Treat test#2 seperately using the same data.
EX:
ID#1 occurs multiple times with multiple conditions.
Return "F" unless an ID has instances with both Corn and Tomato
I think it needs an array of some kind. I submit an updated excel sample with comments add that may clarify. The basic problem with your sample is that we are not searching for a single cell value but if x instances of an ID occur, and two or more conditions are met, flag the entire ID subset as suspect "T" or "F" identifer. Thanks!
I have to give it an actual test on my daily data feed results, but using my simple test file data, looks like both formulas works perfectly, just as intended. I see no reason why it will not work equally well on my current project.
I see the trick now, putting Tomato and Corn in an array. Very neat. I need to work harder on increasing my knowledge of array usage.
