Excel formulas
Hi can any one help me on this
In sheet1 we have the data
Date Task name Remarks
9/15/2005 Incoming OK
9/15/2005 Outgoing OK
9/15/2005 Incoming Not OK
9/16/2005 Outgoing OK
9/16/2005 Outgoing OK
9/16/2005 Incoming OK
In sheet2 i need data for that particular date of that task only if it is OK
Eg: - on 15 - Sep it should 1 only one record in total if it is OK and task
is Incomig
On 16/sep it should be 2 outging and 1 incoming
Pls help me.
|