Forum Discussion
Solved
Formula Excel Help
Hi, I'd like to create a formula which looks at column F and if it contains words, "Jay", "Em" then to go to column B AND C and if they both state 'Complete' or 'NA' then to return words in colum...
Try this formula:
=IF(OR([@[Name]]={"Jay","Em"}), IF(SUM(COUNTIF(Table1[@[Servicing Status]:[Complaint Status]], {"Complete","NA"}))=2, "Case Closed", "Case Open"), "")
(Change Name to the real name of that column)
HansVogelaar hi, I've attached a file, the last column shows what the expected outcome should be. Hope that makes sense
The formula that I proposed appears to work:
- Ah that's great! I must have typed the formula in wrong!! Thanks so much for your help :c)