Finding Data in a range

[Southwick]

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.

 

[T. Valko]

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)

 

[Southwick]

Awesome. Thank you. It worked.

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)

 

[T. Valko]

You're welcome. Thanks for the feedback!