Hi,

In Sheet1, data i have

A B
EMPCODE AMT

F001 2
F001 3
F001 0
F001 0


WITH USE OF THIS DATA I REQUIRED RESULT IN SHEET2 , COUNT OF ZERO IN
SHEET2

SHEET 2
A B
EMPCODE COUNT OF ZERO

F001 2


REGARDS,

DEEN