Ifs and/ or functions

[Ary]

Hi, I don’t know if this makes sense. I know little with excel formulas so I really need help for this. Thank you in advance. I want to match column A and B or find the “Due” in column B. So if transaction no. 201603001508 (Column A) has a particular “Due” (Column B) then Column D will say “YES” for all transactions with no. 201603001508. I hope you can help me with this. Thank you!!!!

 

[Joe4]

Welcome to the Board!

Place this formula in cell D2 and copy down for all rows:

=IF(COUNTIFS(A:A,A2,B:B,"Due")>0,"YES","")

 

[Ary]

=IF(COUNTIFS(A:A,A2,B:B,"Due")>0,"YES","")

Thank you so much!! Greatly appreciated ?

 

[Joe4]

You are welcome!

 

[Ary]

You are welcome!

Btw, how can put NO to the blank argument? ?

 

[Joe4]

Just put the word NO between the "", i.e.

=IF(COUNTIFS(A:A,A2,B:B,"Due")>0,"YES","NO")

 

[Ary]

Just put the word NO between the "", i.e.

=IF(COUNTIFS(A:A,A2,B:B,"Due")>0,"YES","NO")

I tried this one but it says ‘There’s problem with the formul’
=IF(COUNTIFS(A:A,A2,B:B,"Due")>0,"YES","NO")

 

[Joe4]

I tried this one but it says ‘There’s problem with the formul’
=IF(COUNTIFS(A:A,A2,B:B,"Due")>0,"YES","NO")

That formula is valid (I tested it and it works for me).

If you are getting errors, then check for the following:
1. Do you have any errors in columns A or B?
2. Do you have any merged cells in columns A or B?

 

[Joe4]

I recreated your data, and this is what it looks like for me:

 

[Ary]

I recreated your data, and this is what it looks like for me:
View attachment 58963I just realized that the error was due to typo error. ? apologies. Anyway, maybe you can help me more with this. I’m trying to copy the description to other cells with the same transaction number. Thank you for the help and patience ?