=ISNUMBER
Hi!
I am trying to figure out the proper way to incorporate =ISNUMBER into my formula. I keep getting errors and can't figure out how quite to frame it in. I have a flag but I do not want it to flag blanks or text. I only want to flag duplicate numbers.
=IF(COUNTIFS([Site ID]:[Site ID], [Site ID]@row) + COUNTIFS([Device ID]:[Device ID], [Site ID]@row) + COUNTIFS([License ID]:[License ID], [Site ID]@row) > 1, 1)
Best Answers
-
My apologies. I must have missed that update.
=IF(ISNUMBER([Site ID]@row), IF(COUNTIFS([Site ID]:[Site ID], [Site ID]@row) + COUNTIFS([Device ID]:[Device ID], [Site ID]@row) + COUNTIFS([License ID]:[License ID], [Site ID]@row) > 1, 1))
-
Happy to help. 👍️
Answers
-
Try this:
=IF([Site ID]@row <> "", IF(COUNTIFS([Site ID]:[Site ID], [Site ID]@row) + COUNTIFS([Device ID]:[Device ID], [Site ID]@row) + COUNTIFS([License ID]:[License ID], [Site ID]@row) > 1, 1))
-
Hi Paul,
That works for blanks but I also do not want it to flag if there is text in the field. Only numbers.
Thank you!
-
My apologies. I must have missed that update.
=IF(ISNUMBER([Site ID]@row), IF(COUNTIFS([Site ID]:[Site ID], [Site ID]@row) + COUNTIFS([Device ID]:[Device ID], [Site ID]@row) + COUNTIFS([License ID]:[License ID], [Site ID]@row) > 1, 1))
-
That worked! Thank you!!
-
Happy to help. 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!
