Prev: Crane model in Excel
Next: trying to find the previous thursday before running a macro
From: Bruno on 8 Apr 2010 04:19
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
From: Mike H on 8 Apr 2010 04:58
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
> .
>
From: Bruno on 8 Apr 2010 05:53
On Apr 8, 9:58 am, Mike H <Mi...(a)discussions.microsoft.com> 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 <Mi...(a)discussions.microsoft.com> 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
 | 
Pages: 1
Prev: Crane model in Excel
Next: trying to find the previous thursday before running a macro