Hi,

I have below data with me, i have 4 columns where the "no of days" for
Employee ID (under a particular manager ID) is coming with -ve value as well
as with +ve value.

The "no of days" are automatically coming whether it is -ve or +ve comes in
the report in column "D".

I want a formula in column "E" where it will find for me the Emp ID having
+ve value that is offsetting with the same Emp ID having the -ve value

Manager Empl ID no of days -ve value comment
ID
454 12121 5 No
454 12121 15 No
454 12121 -5 Yes
454 12121 4 No
454 12121 -4 Yes
454 12121 10 No
878 45464 14 No
878 45464 -2 Yes
878 45464 2 No


Regards,
rkp