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