you can use whole "# & Date"  columns for in preparing pivot table....



On 8/6/10, Nadine S <n8dine4ma...@yahoo.com> wrote:
>
>  Thank you but a pivot table won't work for me.  It needs to be a formula
> in the particular cell all the way down the row of data.  I wish I could use
> the pivot table 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   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 <srinivasan.ethiraj...@gmail.com> 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 <n8dine4ma...@yahoo.com> wrote:
>>>
>>>  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 are what I need a max formula for.
>>>
>>> I need to find the last/latest/largest (whatever term you want to use)
>>> date that corresponds to the number to the left of the date field.  So the
>>> last date for 1001 is 8/2.  Anyone have any ideas how to write this?  Thanks
>>> so much.
>>>
>>>
>>>
>>> --
>>>
>>> ----------------------------------------------------------------------------------
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com/
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com/
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com/
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> HELP US GROW !!
>>>
>>> We reach over 7000 subscribers worldwide and receive many nice notes
>>> about the learning and support from the group.Let friends and co-workers
>>> know they can subscribe to group at
>>> http://groups.google.com/group/excel-macros/subscribe
>>>
>>
>>
>>
>> --
>> Srinivasan Ethirajalu,
>> +919840544295
>
>
>
>
> --
> Srinivasan Ethirajalu,
> +919840544295
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
>
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
Srinivasan Ethirajalu,
+919840544295

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Reply via email to