'Same inputs into the frequency function results in different outputs
Most of the information is contained in the attached photo of my excel sheet. There is a breakdown of the issue there. I've narrowed down the problem to the cells highlighted in blue. Please let me know if you know what is going on here. Thank you!
I don't think I explained the frequency equation function well in the photo so here goes another try: With how I have it typed out, the frequency function should output one number for each cell it is referencing (then 1 extra value of 0 at the end that can be ignored in this use case). For the first occurrence of each number, the frequency function should output how many times that number appears in the referenced cells. For each occurrence of that number afterwards, the frequency function should output 0.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|