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 cou...
  • Detlef_Lewin's avatar
    Apr 18, 2019

    Simonpease 

     

    Untested.

    =COUNTIF(B$2:B2,B2)

     

    EDIT: Replaced semicolon with comma. 

Resources