Forum Discussion

rcriceinc's avatar
rcriceinc
Copper Contributor
May 20, 2017
Solved

Identify ID's meeting multiple criteria (Condition#1: Corn,Tomato - Cndition#2 starts with "P"

This is probably easier than I think but at 4:30 in the morning not thinking clearly.   Test#1 = ID = "Corn" and "Tomato" Test #2 = ID = (starts with "P") Both test conditions should return a ...
Formulas & Functions
Show and Tell
  • Logaraj Sekar's avatar
    Logaraj Sekar
    May 21, 2017

    Hi, rcriceinc

     

    For Test Condition 1, apply Detlef_Lewin 's formula

     

    =IF(SUM(COUNTIFS([ID],[@ID],[Condition],{"Tomato";"Corn"}))>1,"T","F")

    For Test Condition 2, use this.

     

    =IF(COUNTIFS([ID],[@ID],[Condition],"P*")>=1,"T","F")

    Hope both will solve your problem.

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
May 20, 2017

Hello

 

=OR(A2="Corn",A2="Tomato")
=LEFT(A2)="P"