Check if value exists in column more than once or twice - Excel

How can I check if value exists in the range in Excel column more than once, twice or specific fixed number of times ?
0
give a positive ratinggive a negative rating
09 Feb 2021 at 05:50 PM
Hi,

To check if value appears in a range of cells more than once, twice or certain number of times, you have to use IF and COUNTIF functions with logical operators.

This formula checks if value exists more than once:
=IF(COUNTIF(A5:A15,B5)>1,"Value is included more than once","Value is not included more than once")

And this formula checks if value appears exactly 3 times:
=IF(COUNTIF(A5:A15,B5)=3,"Value is included 3 times","Value is not included 3 times")
1
give a positive ratinggive a negative rating
10 Feb 2021 at 11:14 AM
Tim
Share on FacebookShare on TwitterShare on LinkedInSend email
x
x
2024 AnswerTabsTermsContact us