Skip to main content
Super User

Return to Answer

Post Timeline

added 165 characters in body
Source Link
Excellor
Excellor
  • 725
  • 5
  • 11

You can do =COUNTIF(A1, B1)

Or if you want to return True or False do: =IF(COUNTIF(A1, B1) = 1, TRUE, FALSE)

Or as suggested by FlexYourData: =COUNTIF(A1, B1)=1 , even shorter, this will also return TRUE or FALSE

You can do =COUNTIF(A1, B1)

Or if you want to return True or False do: =IF(COUNTIF(A1, B1) = 1, TRUE, FALSE)

You can do =COUNTIF(A1, B1)

Or if you want to return True or False do: =IF(COUNTIF(A1, B1) = 1, TRUE, FALSE)

Or as suggested by FlexYourData: =COUNTIF(A1, B1)=1 , even shorter, this will also return TRUE or FALSE

Source Link
Excellor
Excellor
  • 725
  • 5
  • 11

You can do =COUNTIF(A1, B1)

Or if you want to return True or False do: =IF(COUNTIF(A1, B1) = 1, TRUE, FALSE)