Hi
This formula checks data in column C (Bicycles) and returns last occurances

=INDIRECT("c"&MAX(IF(C2:C100,ROW(A2:A10))))

Apply same to Red Bicycles Blue
--
Click yes if helped
Greatly appreciated
Eva


"Kevin Barrios" wrote:

As a manufacturer, we need to keep track of what items we made, how much, and
when. So, to simplify the complex task, as we have hundreds of products over
many years, look at the example below:

A B C
1 Date Red Bicycles Blue Bicycles
2 1/3/10
3 1/4/10 12
4 1/5/10 4
5 1/6/10 2
6 1/7/10
7 1/8/10 8

So, in effect, I'd like to find out that we first made 12 Red Bicycles on
1/4/10 and that the last time we made Red Bicycles was on 1/6/10 and made 2
of them. Same thing with Blue Bicycles, first made 4 on the 5th and last
time we made blue ones was on the 8th with 8 made.

Any suggestions would be appreciated and I'll click "yes it helped" to any
of your posts that help.

-Kevin