Forum Discussion
Simonpease
Apr 18, 2019Copper Contributor
Creating a function for identifying repeated data?
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
4 Replies
- Detlef_LewinSilver Contributor
- SimonpeaseCopper Contributor
Did not work sadly :(
- Detlef_LewinSilver Contributor