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 -- ---------------------------------------------------------------------------------- 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
