Creating a function for identifying repeated data?

New Contributor



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?



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






EDIT: Replaced semicolon with comma. 

@Detlef Lewin 

Did not work sadly :(


I amended the formula.


@Detlef Lewin 

Sweet it worked this time.


Thank you!

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies