# 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
