Values of the last date

  • Thread starter Thread starter Bruno
  • Start date Start date
B

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
 
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.
Click to expand...

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.
Click to expand...

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
 
Back
Top