Hi Nadine,
It should still work with alphanumeric data. Any chance of a sample workbook
with the formulas in there?
Regards - Dave.
Date: Sat, 7 Aug 2010 08:26:36 -0700
From: n8dine4ma...@yahoo.com
Subject: Re: $$Excel-Macros$$ Need max date
To: excel-macros@googlegroups.com
I should
about that.
From: Nadine S
To: excel-macros@googlegroups.com
Sent: Sat, August 7, 2010 8:24:16 AM
Subject: Re: $$Excel-Macros$$ Need max date
I'm getting the result #VALUE!. Could that be because what in column A in both
sheets i
I'm getting the result #VALUE!. Could that be because what in column A in both
sheets is alpha numeric?
From: Dave Bonallack
To: "excel-macros@googlegroups.com"
Sent: Fri, August 6, 2010 6:53:33 PM
Subject: RE: $$Excel-Macros$$ Need max
pivot table and I'd be done but it just won't work in this case.
>
>
> --
> *From:* Srinivasan Ethirajalu
> *To:* excel-macros@googlegroups.com
> *Sent:* Thu, August 5, 2010 7:59:53 PM
> *Subject:* Re: $$Excel-Macros$$ Need max date
>
jalu
To: excel-macros@googlegroups.com
Sent: Thu, August 5, 2010 7:59:53 PM
Subject: Re: $$Excel-Macros$$ Need max date
# Date Max of Date
1001 8/2/2010 # Total
1001 6/10/2010 1001 8/2/2010
1001 3/14/2010 2355 4/12/2010
1001 3/1/2010 5252 3/15/2010
1001 2/15/2010
1001 2/15/2
# Date Max of Date 1001 8/2/2010 # Total 1001 6/10/2010 1001
8/2/2010 1001 3/14/2010 2355 4/12/2010 1001 3/1/2010 5252 3/15/2010 1001
2/15/2010 1001 2/15/2010 2355 4/12/2010 2355 1/6/2010
5252 3/15/2010 5252 2/15/2010 5252 1/6/2010
On 8/6/10, Srinivasan Ethirajalu wrote:
>
Use pivot table, use# column in ROW area & Date in DATA area, change "Count
of Date" to "Max of Date", format the data area to date format. Then "Hide"
the grand total.
Srinivasan Ethirajalu
On 8/5/10, Nadine S wrote:
>
> Sheet 1 contains
> # Date 1001 03/01/10 5252 02/15/10 1001 02/15/1
Sheet 1 contains
# Date
1001 03/01/10
5252 02/15/10
1001 02/15/10
1001 02/15/10
1001 08/02/10
5252 03/15/10
5252 01/06/10
2355 04/12/10
1001 06/10/10
1001 03/14/10
2355 01/06/10
Sheet 2 contains
# Last Date
1001 8/2/2010
5252 3/15/2010
2355 4/12/2010
The dates in sheet 2 in yellow
