• Status: Solved
• Priority: Medium
• Security: Public
• Views: 56

# Putting a value of "NO" in a column based on the values in two other columns

Experts,

I am trying to identify Id's (column A) that have no status (Column B) equal to "C3".   The file is sorted by ID.  If there is an ID with no "C3" found in Column "B" I would like to put a "NO' in column "C" as indicated in rows 31 and 32.

Can someone help me with th formula to do this.
paid.xls
0
morinia
• 2
• 2
1 Solution

Tech FreelancerCommented:
in cell C2, type this formula
``````=if(B2="C3","","No")
``````

Then copy and paste that formula down the c column.

What this does:
If cell B2 equals the status text "C3", then leave C3 blank.  If not, put No.

Hope this is what you want.
0

Commented:
HI,

pls try

=IF(COUNTIFS(A:A,A2;B:B,"C3")=0,"No","")

Regards
0

Rgonzo1971,

It worked perfectly except I found out the value in "W" can be "C2", "C3" or C4".    Can this  be modified to check for a value other than "C1"  instead of looking for "C3".

I am sorry I asked the wrong question, I just found out the other values could be in the column.
0

Commented:
pls try

IF(COUNTIFS(A:A,A2;B:B,"<>C1")=0,"No","")
0

Tech FreelancerCommented:
Either my formula or Rgonzo1971's can be easily modified.  Just replace the C3 in each with C1.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.