SOLVED

Creating a function for identifying repeated data?

Copper Contributor

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:

Capture.PNG

 

Please let me know if anyone has an idea of how to create this.

 

Thank you,

Simon Pease

4 Replies
best response confirmed by Simonpease (Copper Contributor)
Solution

@Simonpease 

 

Untested.

=COUNTIF(B$2:B2,B2)

 

EDIT: Replaced semicolon with comma. 

@Detlef Lewin 

Did not work sadly :(

@Simonpease 

I amended the formula.

 

@Detlef Lewin 

Sweet it worked this time.

 

Thank you!

1 best response

Accepted Solutions
best response confirmed by Simonpease (Copper Contributor)
Solution

@Simonpease 

 

Untested.

=COUNTIF(B$2:B2,B2)

 

EDIT: Replaced semicolon with comma. 

View solution in original post