Identify rows based on conditions

[reincarnation.x]

Hi, I am trying to identify pairs in a worksheet of unsorted data. Within my worksheet, there should be a pair of rows that have the same value in Column E. In addition, within each pair, one row must have the text "Done" in Column C and the other row must have the text "Cancelled" in Column C.

How can I identify rows that do not fulfil both the conditions above?

Please help!!! Thank you so much!

[Jakobshavn]

What is the last column you are using?

[reincarnation.x]

The last column I am using is Column E.

So something like this

Column A Column B Column C Column D Column E
1 ABC Done DEF 230
2 ABC Cancelled DEF 230
3 ABC Done DEF 493
4 ABC Done DEF 766
5 ABC Cancelled DEF 766

How do I flag out number 3?

[FDibbins]

Hi and welcome to the forum

Try this, copied down...

=IF(AND(OR(C1="Done",C1="Cancelled"),COUNTIF($E$1:E1,E1)>1),"Yes","No")
You can replace the Yes/No with whatever you want