Finding Data in a range
 

I have a range of data that lists the names of items and also the date that
that item was inspected. For example Strawberries are listed numerous times
with the date that they were inspected, the same with other fruits.

I would like to find out how many times Strawberries were entered into the
database and what the last date was where they were inspected. I know that I
can use the "countif" fuction to return the number of times that the item was
inspected, but I am having a hard time returning the cell that has the date
of the last time the strawberries were inspected.

Is there some find function that can keep track of the "countif" function
and return the value of a cell next to the last "count"?

Thanks in advance.

Finding Data in a range
 

Try this...

Items in the range A1:A10
Dates in the range B1:B10

Use this array formula** :

=MAX(IF(A1:A10="Strawberries",B1:B10))

Format as DATE

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)


--
Biff
Microsoft Excel MVP


"Southwick" wrote in message
...
I have a range of data that lists the names of items and also the date that
that item was inspected. For example Strawberries are listed numerous
times
with the date that they were inspected, the same with other fruits.

I would like to find out how many times Strawberries were entered into the
database and what the last date was where they were inspected. I know
that I
can use the "countif" fuction to return the number of times that the item
was
inspected, but I am having a hard time returning the cell that has the
date
of the last time the strawberries were inspected.

Is there some find function that can keep track of the "countif" function
and return the value of a cell next to the last "count"?

Thanks in advance.

Finding Data in a range
 

Awesome. Thank you. It worked.

"T. Valko" wrote:

Try this...

Items in the range A1:A10
Dates in the range B1:B10

Use this array formula** :

=MAX(IF(A1:A10="Strawberries",B1:B10))

Format as DATE

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)


--
Biff
Microsoft Excel MVP


"Southwick" wrote in message
...
I have a range of data that lists the names of items and also the date that
that item was inspected. For example Strawberries are listed numerous
times
with the date that they were inspected, the same with other fruits.

I would like to find out how many times Strawberries were entered into the
database and what the last date was where they were inspected. I know
that I
can use the "countif" fuction to return the number of times that the item
was
inspected, but I am having a hard time returning the cell that has the
date
of the last time the strawberries were inspected.

Is there some find function that can keep track of the "countif" function
and return the value of a cell next to the last "count"?

Thanks in advance.

Finding Data in a range
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Southwick" wrote in message
...
Awesome. Thank you. It worked.

"T. Valko" wrote:

Try this...

Items in the range A1:A10
Dates in the range B1:B10

Use this array formula** :

=MAX(IF(A1:A10="Strawberries",B1:B10))

Format as DATE

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)


--
Biff
Microsoft Excel MVP


"Southwick" wrote in message
...
I have a range of data that lists the names of items and also the date
that
that item was inspected. For example Strawberries are listed numerous
times
with the date that they were inspected, the same with other fruits.

I would like to find out how many times Strawberries were entered into
the
database and what the last date was where they were inspected. I know
that I
can use the "countif" fuction to return the number of times that the
item
was
inspected, but I am having a hard time returning the cell that has the
date
of the last time the strawberries were inspected.

Is there some find function that can keep track of the "countif"
function
and return the value of a cell next to the last "count"?

Thanks in advance.