Forum Discussion

Simonpease's avatar
Simonpease
Copper Contributor
Apr 18, 2019
Solved

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

Resources