=ISNUMBER

Meagan80

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)

Paul Newcome

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))

Paul Newcome

Happy to help. 👍️

Paul Newcome

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))

Meagan80

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!

Paul Newcome

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))

Meagan80

That worked! Thank you!!

Paul Newcome

Happy to help. 👍️