Solved

How to find the number of occurrence of a particular value in the excel sheet?

  • 11 October 2023
  • 1 reply
  • 23 views

Userlevel 3
Badge

I need to find the count or number of occurrence of particular value from the excel sheet. I have used the constraint on the value to find the count. However, it is always returning 0 or 1. And not returning the correct data.

 

image

[Originally asked and solved on Support Hub]

icon

Best answer by Community Administrator 11 October 2023, 10:31

View original

1 reply

Userlevel 4
Badge +2

I believe #1 comes into picture when instanced based on the wanna indentify instanced based on constraints.

So #1 represent first instance based on the given constraint. But, to count the result, #1 is not needed.

Reply