excel formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can any one help me on this
In sheet1 one we have
A B C
9/15/2005 cv ok
9/15/2005 cv d
9/16/2005 cv ok
9/15/2005 DV OK

In sheet2 i need data to be on that particular date's data only if it is ok
Eg: - on 15 - Sep it should 1 only if it is ok and CV

Pls help me.
 
I still don't understand in which application you need to do that, if it's
Excel, you better post this question in Excel Discussion group.
If you are using Access then create a query that will filter the records

Where [data] = #9/15/2005# And B = "ok" And C = "CV"
 
Its in excel, Thanks I wil Fwd this to Excel group

Ofer said:
I still don't understand in which application you need to do that, if it's
Excel, you better post this question in Excel Discussion group.
If you are using Access then create a query that will filter the records

Where [data] = #9/15/2005# And B = "ok" And C = "CV"


--
I hope that helped
Good luck


dj_george said:
I can any one help me on this
In sheet1 one we have
A B C
9/15/2005 cv ok
9/15/2005 cv d
9/16/2005 cv ok
9/15/2005 DV OK

In sheet2 i need data to be on that particular date's data only if it is ok
Eg: - on 15 - Sep it should 1 only if it is ok and CV

Pls help me.
Click to expand...
Click to expand...
 
Back
Top