Skip to Content
0

Count of Match pattern string in a column

May 25, 2017 at 05:48 AM

21

avatar image

I have following output I need count

EmpId Employee Type

Q12 Assistant;General

Q13 General

Q14 Assistant;NonGenral;General

Here I need output count as from above column

General 3

Assistant 2

Non General 1

Please suggest any solution

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Gopinath Thangaraj May 25, 2017 at 09:37 AM
0

Found the solution:

=count([EmpId] where (Match([Employeetype];"*General*")))

Now you will get the count for general as 3.,like this we have do for other values in column LOV's

Share
10 |10000 characters needed characters left characters exceeded