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

JohnCTX 636 Reputation points
2021-01-14T00:18:17.853+00:00

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.

Regards,

JohnCTX

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
    2021-01-14T08:27:33.927+00:00

    @JohnCTX

    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.

    56561-capture26.jpg

    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