Count employee

[jitendras]

Count employee id infront of smrm

[berlan]

If you want to count the no. of EMP ID's in Col A, try:

=COUNT(A:A)

will count the cells containing a number within the range.

[jitendras]

count as per SMRM wise how many count under smrm of employee id smrm like name jayesh javhar

[jitendras]

can anyone help me immediate its helpful for me & my work thanks in advance

[samba_ravi]

Your question has no clarity, reattach you sample file with some details and your expected result

[jitendras]

ITs example one smrm like "jayesh jhavar" how many count of emp id infront of jayesh jhavar same i want to count of emp id of each smrm


EMP ID SMRM
119626 Jayesh Jhavar
120365 Jayesh Jhavar
123415 Jayesh Jhavar
125258 Jayesh Jhavar
128849 Jayesh Jhavar
135525 Jayesh Jhavar
134727 Jayesh Jhavar
140984 Jayesh Jhavar
143281 Jayesh Jhavar
143384 Jayesh Jhavar
143942 Jayesh Jhavar
148337 Jayesh Jhavar
148340 Jayesh Jhavar