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 ?
09 Feb 2021 at 05:50 PM
0pnshow more
NicoleNicole
Find us on Facebook AnswertabsFind us on Facebook Answertabs
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")
10 Feb 2021 at 11:14 AM
0pnshow more
TimTim
share on facebookshare on twitter
2021 AnswerTabsTermsContact us