Values of the last date

[Bruno]

Hi, i have a sheet with tree coluns, onde for "Date", other for
"Product" and the last for "Value".
For example:

Date Product Value
01/01/09 A 100
01/02/09 B 150
01/03/09 A 120
01/04/09 B 110
01/05/09 A
10

I want to make a macro that give me the values of all produts for the
last date.

Can you help me?

Thanks

 

[Mike H]

Bruno,

What result would you expect from your sample data and why?
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Bruno]

Bruno,

What result would you expect from your sample data and why?
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

Bruno,

What result would you expect from your sample data and why?
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

well Mike, i expect that the macro give me, in a new worksheet, all
products in data (A and B) and the last price with correspondent date

Result:
Date Product Value
01/05/09 A
10
01/04/09 B 110

Bruno