Use AutoFilter:

1. click on the headercell containing "Status" and pull-down:

Data Filter Autofilter

This will result in pull-downs for each header cell

2. click on the Status pull-down and select "review"
3. click on the Dat oull-down and select the desired date.
--
Gary''s Student - gsnu200819


"Raj" wrote:

Hi
Here is the excel data how my data is distributed.

Incident Description Status Date logged
313 XXXXX Review December 9, 2008 2:16 PM
GMT

There are thousands incidents with different status looged in these year.
Now i would like to See the no.of incidents which are in review status
logged on December 9. Can you please suggest me an array extract this data