morinia
asked on
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
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
HI,
pls try
=IF(COUNTIFS(A:A,A2;B:B,"C 3")=0,"No" ,"")
Regards
pls try
=IF(COUNTIFS(A:A,A2;B:B,"C
Regards
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Either my formula or Rgonzo1971's can be easily modified. Just replace the C3 in each with C1.
Open in new window
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.