Hi Nadine, It should still work with alphanumeric data. Any chance of a sample workbook with the formulas in there?
Regards - Dave. Date: Sat, 7 Aug 2010 08:26:36 -0700 From: n8dine4ma...@yahoo.com Subject: Re: $$Excel-Macros$$ Need max date To: excel-macros@googlegroups.com 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 -- ---------------------------------------------------------------------------------- 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
