$$Excel-Macros$$ Pivot table problem
Hi all I have attached a file containg pivot table with some data. I have two qurries 1. I want to put a foruma next to pivot table and want to copy and paste all formula to all rows but its taking freezing cells by default. If data quatity is high than how could i put the formula in all cells. 2. if i able to put formula in all cells then when i click on plus sign and open it i.e. if i click on Arind then when it open all cells in Arind the formula got the error #REF! how could i make the formula to sick there. Regards, Deepak Rawat -- -- 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 Pivot table problem.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Re: How to attach?
I also have the same problem. Whenever I reply to any post, I don't get option to upload a fine in post. -- -- 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
$$Excel-Macros$$ In Excel 2003 and in Excel 2002, you are prompted to save the changes when no changes were made
When you open a workbook and then close it with out making any changes, you are prompted as follows: Do you want to save the changes to Filename.xls? Microsoft Excel recalculates formulas when opening files last saved by an earlier version of Excel. How to get rid of this problem File is uploaded on the below link http://www.sendspace.com/file/ztjm60 Can any one please help me out. Regards Rahul -- -- 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
Re: $$Excel-Macros$$ In Excel 2003 and in Excel 2002, you are prompted to save the changes when no changes were made
Hi Rahul, Which version of Excel are you using? Regards Andy On Sat, Aug 7, 2010 at 5:08 PM, rahul axyin.ra...@hotmail.com wrote: When you open a workbook and then close it with out making any changes, you are prompted as follows: Do you want to save the changes to Filename.xls? Microsoft Excel recalculates formulas when opening files last saved by an earlier version of Excel. How to get rid of this problem File is uploaded on the below link http://www.sendspace.com/file/ztjm60 Can any one please help me out. Regards Rahul -- -- 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
Re: $$Excel-Macros$$ In Excel 2003 and in Excel 2002, you are prompted to save the changes when no changes were made
By default, Microsoft Office Excel 2003 and Microsoft Excel 2002 recalculate files that were last saved in an earlier version of Excel. This ensures that any improvements made to the Excel calculation engine are applied to all formulas in the workbook. To prevent Excel 2003 or Excel 2002 from automatically recalculating workbooks saved in earlier versions, follow these steps: 1. On the *Tools* menu, click *Options*. *NOTE*: The *Options* command is only available when a workbook is open. If it is not available, click *New* on the *File* menu, and then click *Blank Workbook* in the *New Workbook* task pane. 2. Click the *Calculation* tab. Under *Calculation*, click *Manual*. Click to clear the*Recalculate before save* check box. 3. Click *OK*. Regards, Andy On Sat, Aug 7, 2010 at 5:52 PM, Aindril De aind...@gmail.com wrote: Hi Rahul, Which version of Excel are you using? Regards Andy On Sat, Aug 7, 2010 at 5:08 PM, rahul axyin.ra...@hotmail.com wrote: When you open a workbook and then close it with out making any changes, you are prompted as follows: Do you want to save the changes to Filename.xls? Microsoft Excel recalculates formulas when opening files last saved by an earlier version of Excel. How to get rid of this problem File is uploaded on the below link http://www.sendspace.com/file/ztjm60 Can any one please help me out. Regards Rahul -- -- 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
$$Excel-Macros$$ Help for Pick data from access to Excel
**Dear All, I need your help I have some Mobile nos in 'a' colmn ..and that mobile no related other information is availble in MS-Access table (data volume is 6lac) Mobile No Name Add1 Add2 Add3 Alternate no 123456 325641 267789 325641 Please suggest me any macro and coding.. Thanx in Advance.. Umesh M. -- -- -- 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
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.
Re: $$Excel-Macros$$ Need max date
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
RE: $$Excel-Macros$$ In Excel 2003 and in Excel 2002, you are prompted to save the changes when no changes were made
Hi I am using excel 2007 Regards Rahul Date: Sat, 7 Aug 2010 17:52:16 +0530 Subject: Re: $$Excel-Macros$$ In Excel 2003 and in Excel 2002, you are prompted to save the changes when no changes were made From: aind...@gmail.com To: excel-macros@googlegroups.com Hi Rahul, Which version of Excel are you using? Regards Andy On Sat, Aug 7, 2010 at 5:08 PM, rahul axyin.ra...@hotmail.com wrote: When you open a workbook and then close it with out making any changes, you are prompted as follows: Do you want to save the changes to Filename.xls? Microsoft Excel recalculates formulas when opening files last saved by an earlier version of Excel. How to get rid of this problem File is uploaded on the below link http://www.sendspace.com/file/ztjm60 Can any one please help me out. Regards Rahul -- -- 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
RE: $$Excel-Macros$$ In Excel 2003 and in Excel 2002, you are prompted to save the changes when no changes were made
Hi I have already tried the below steps but every time i reopen excel 2007 the option in step no. 2 automatically gets resetted Regards Rahul Date: Sat, 7 Aug 2010 17:55:17 +0530 Subject: Re: $$Excel-Macros$$ In Excel 2003 and in Excel 2002, you are prompted to save the changes when no changes were made From: aind...@gmail.com To: excel-macros@googlegroups.com By default, Microsoft Office Excel 2003 and Microsoft Excel 2002 recalculate files that were last saved in an earlier version of Excel. This ensures that any improvements made to the Excel calculation engine are applied to all formulas in the workbook. To prevent Excel 2003 or Excel 2002 from automatically recalculating workbooks saved in earlier versions, follow these steps: On the Tools menu, click Options. NOTE: The Options command is only available when a workbook is open. If it is not available, click New on the File menu, and then click Blank Workbook in the New Workbook task pane. Click the Calculation tab. Under Calculation, click Manual. Click to clear theRecalculate before save check box. Click OK. Regards, Andy On Sat, Aug 7, 2010 at 5:52 PM, Aindril De aind...@gmail.com wrote: Hi Rahul, Which version of Excel are you using? Regards Andy On Sat, Aug 7, 2010 at 5:08 PM, rahul axyin.ra...@hotmail.com wrote: When you open a workbook and then close it with out making any changes, you are prompted as follows: Do you want to save the changes to Filename.xls? Microsoft Excel recalculates formulas when opening files last saved by an earlier version of Excel. How to get rid of this problem File is uploaded on the below link http://www.sendspace.com/file/ztjm60 Can any one please help me out. Regards Rahul -- -- 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
RE: $$Excel-Macros$$ Need max date
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
Fwd: $$Excel-Macros$$ Question asked in Interview...
Hello Friends, Waiting for reply Regards, Vijay -- Forwarded message -- From: Vijay Kr. Aggarwal vjaggarwal2...@gmail.com Date: Fri, Aug 6, 2010 at 10:18 AM Subject: $$Excel-Macros$$ Question asked in Interview... To: excel-macros@googlegroups.com Hi, Please check attached file. Kindly provide answers through macro and functions. Regards, Vijay Kumar Aggarwal 048542 -- -- 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 Question Asked in Interview.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ trying to hire someone very very proficient in excel
i need help on a project to convert complex spreadsheets into a more efficient model. pls advise if anybody available ASAP. We could discuss the payment offline. Thanks -- -- 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
$$Excel-Macros$$ Need to remove Alt + Enter
I often receive a file that has extra Alt+Enter in it which makes the cells long and therefore the files long. Is there anyway I can remove these? The # rows is 700+ - it can vary. Thanks. -- -- 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