Finding Values with Condition

  • Thread starter Thread starter Vinod Chandramouli
  • Start date Start date
V

Vinod Chandramouli

Folks I have a question. Take a look at the example below.

Column 1 Column 2 Column 3
Active A
B
C

Active A
B
C

Active A
B


Now, I have data similar to the one you see above. My requirement is
this.
till the second active under column 2. For Example, it has to search
A, B , C....If it does not find either A, B or C it should say Yes on
Column 3 (opposite to Active). If it finds that all the characters are
in place, it should say no in front of Active under Column 3.

I know that's little confusing. Here is what my result should look
like.

Column 1 Column 2 Column 3
Active A No
B
C
Active A No
B
C
Active A Yes
B


Is this possible ?? Any suggestions....??

-- Vinod Chandramouli
 
In C1, enter

=IF(A1="Active",IF(AND(B1="A",B2="B",B3="C"),"No","Yes"),"")

and copy down.
 
Bob,
Thanks for the quick response. I should have mentioned this
earlier.

1) A, B and C are not the only values that would be there in a set
2) and the values will not be in the same order.
3) I want the value Yes/No to be shown only at the first row of every
set.
4) Again a set is the range of cells from one Active(column 1) to the
next Active(column 1).
 
Wow, I just read what i wrote and i found it confusing :|.... Let me
try to be more clear....A set is the set of rows starting from Active
(Column 1) till the next Active(Column 1). It might be a set of 10
rows, or 11 or more than that...

Does that answer your question, or are you fuming with anger at this
point :D


-- vinod chandramouli
 
Back
Top