I should have clarified that in the sample it is only numeric and it works but in my actual data it's alpha numeric. It didn't occur to me it would make a difference when I created the sample. Can I trouble you to take another look at it with alhpa numeric data in Col A? Sorry about 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? ________________________________ From: Dave Bonallack <davebonall...@hotmail.com> To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> Sent: Fri, August 6, 2010 6:53:33 PM Subject: 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 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 -- ---------------------------------------------------------------------------------- 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
