Apr 18 2019 09:35 AM
Hello,
I am new to creating custom functions, and I was wondering if there was a way to create a Function that could Identify how many times a single data value repeats itself in a column, by counting how many times the value shows up in a Column?
Example:
Say I have a column with a Random number of Apples. Peaches, and Bananas, but I need to know how many of each I have, so I put in my formula in the neighboring column, and it counts how many times it finds the values in the said neighboring column.
it would look something like once finished:
Please let me know if anyone has an idea of how to create this.
Thank you,
Simon Pease
Apr 18 2019 09:59 AM - edited Apr 18 2019 10:43 AM
SolutionApr 18 2019 10:01 AM
Did not work sadly :(
Apr 18 2019 10:45 AM
Apr 18 2019 10:51 AM
Apr 18 2019 09:59 AM - edited Apr 18 2019 10:43 AM
Solution
Untested.
=COUNTIF(B$2:B2,B2)
EDIT: Replaced semicolon with comma.