According to your sample, I suggest you try the formula =SUM(N(EXACT($A$1:$A$3,E1)))
, Exact function would determine the whether array values are same.
Any misunderstanding, please let me know.
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.