How to determine the frequency of an exact array's values?

JohnCTX 636 Reputation points

I am having some issues with finding out the frequency of an exact array's values

Examples: Result:
[3, 6, 8, 9, 10]
[3,4, 6, 8, 9]
[3, 6, 8, 9, 10]

Results: Count of exact array's values
[3, 6, 8, 9. 10] = 2
[3, 4, 6, 8, 9] = 1

So far, I have tried Frequency, CountIFS, and CountIF functions; received errors, or inaccurate results.

Users who have happened to know Excel's formulas should be able to solve this in reply.



Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,657 questions
{count} votes

Accepted answer
  1. Emily Hua-MSFT 27,551 Reputation points


    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.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful