Hi,

Can someone help me with this:
I have the following type of data:

Itam Tag Last Updated Date
AAA 01-Jan-09
AAB 01-Jan-09
AAC 01-Jan-09
AAA 02-Jan-09
AAD 02-Jan-09
AAF 02-Jan-09
BBA 02-Jan-09
AAA 03-Jan-09
AAD 03-Jan-09
BBB 03-Jan-09
AAD 04-Jan-09

Above is the cumulative data for daily reports (report generated on
last updated date). An item tag appears in the report it the item is
outstanding. And it will keep appearing everyday until it is fixed. I
want to compute what is the last day when the appeared in the report,
that is, if you look at item AAA, it first appeared on 1-jan-09 and it
last appeared on 3-jan-09. So, I should be able to compute the number
of days this item was outstanding.

I'll appreciate if anyone can help me with this. Thanks.

-AG

=MAX(IF(A1:A11="AAA",B1:B11,""))-MIN(IF(A1:A11="AAA",B1:B11,""))

This is an array formula that must be entered with CNTRL-SHFT-ENTER rather
than just the ENTER key.
--
Gary''s Student - gsnu200855


"AG" wrote:

> Hi,
>
> Can someone help me with this:
> I have the following type of data:
>
> Itam Tag Last Updated Date
> AAA 01-Jan-09
> AAB 01-Jan-09
> AAC 01-Jan-09
> AAA 02-Jan-09
> AAD 02-Jan-09
> AAF 02-Jan-09
> BBA 02-Jan-09
> AAA 03-Jan-09
> AAD 03-Jan-09
> BBB 03-Jan-09
> AAD 04-Jan-09
>
> Above is the cumulative data for daily reports (report generated on
> last updated date). An item tag appears in the report it the item is
> outstanding. And it will keep appearing everyday until it is fixed. I
> want to compute what is the last day when the appeared in the report,
> that is, if you look at item AAA, it first appeared on 1-jan-09 and it
> last appeared on 3-jan-09. So, I should be able to compute the number
> of days this item was outstanding.
>
> I'll appreciate if anyone can help me with this. Thanks.
>
> -AG
>
>

Many thanks both of you. That works for me.
- AG