Values of the last date
 

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

Values of the last date
 

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" wrote:

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
.

Values of the last date
 

On Apr 8, 9:58*am, Mike H wrote:
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" wrote:
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
.

On Apr 8, 9:58 am, Mike H wrote:
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" wrote:
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
.

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