Skip to Content
avatar image
Former Member

How to count number of occurrence of a particular string in a column

Hi Experts,

I have requirement to calculate number of occurrence of a particular string in a particular column.

The Number of occurrence as given in the .txt file.

report-details.txt

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 20, 2017 at 11:02 AM

    Hi,

    Create formula

    =RunningCount([Report Name]) In ([Report RuN Date]) it will give you number of occureneces of particular string.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded