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

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

1. 27,551 Reputation points
2021-01-14T08:27:33.927+00:00

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.