Join us June 17–18 for a deep dive into Copilot Control System—live expert-led sessions and Q&A on data security, agent lifecycle, adoption, and more! Learn more >

Forum Discussion

Emu2024

Copper Contributor

Mar 26, 2024

Formula help please

I need a formula that will flag "NOT OK" if Column A unique materials have multiple revisions in Column B. If there is only one revison in Column B, return as "OK

Formulas and Functions

2 Replies

Detlef_Lewin
Silver Contributor
Mar 26, 2024
Emu2024
Try this:
=IF(COUNT(UNIQUE(FILTER($B$4:$B$15,$A$4:$A$15=A4)))=1,"OK","NOT OK")
- Emu2024
  Copper Contributor
  Mar 26, 2024
  It worked. Thank you so very much, I have been struggling so much with this one.