: RE: $$Excel-Macros$$ Need max date
Hi Nadine,
Hopefully the attached will do what you need.
Regards - Dave.
Date: Fri, 6 Aug 2010 05:35:14 -0700
From: n8dine4ma...@yahoo.com
Subject: Re: $$Excel-Macros$$ Need max date
To: excel-macros@googlegroups.com
Thank
that.
From: Nadine S n8dine4ma...@yahoo.com
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 is alpha numeric
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
srinivasan.ethiraj...@gmail.com
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
and I'd be done but it just won't work in this case.
--
*From:* Srinivasan Ethirajalu srinivasan.ethiraj...@gmail.com
*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
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
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 n8dine4ma...@yahoo.com wrote:
Sheet 1 contains
# Date 1001 03/01/10 5252 02/15/10
# 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