$$Excel-Macros$$ Hi
this is crazy you should check the out http://www.business15canews.net/work/?read=5074813 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ HELLO
this is intense you should check this out http://www.business15nanews.net/biz/?page=0655543 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
RE: $$Excel-Macros$$ Count intial #NA in a row using excel function
Thank you Asa, I to needed this information, most kind. Best Regards. Mr Michael Brumby Diese Email und samtliche beigefugten Anhange sind vertraulich zu behandeln und sind vor Veroffentlichung geschutzt. Informieren Sie den Absender bitte umgehend und loschen Sie diese Nachricht mit allen beigefugten Anhangen, falls Sie nicht der vorgesehene Empfanger sind. Der Inhalt dieser Email darf nicht an oder von dritten weitergeleitet, veroffentlicht, verwendet, oder kopiert werden, oder durch jegliches Medium gespeichert werden. --- On Sat, 21/4/12, Asa Rossoff a...@lovetour.info wrote: From: Asa Rossoff a...@lovetour.info Subject: RE: $$Excel-Macros$$ Count intial #NA in a row using excel function To: excel-macros@googlegroups.com Date: Saturday, 21 April, 2012, 0:30 Hello Divaker! You provided very little information about your need. My reading of the subject line of your message (Count initial #NA in a row…) leads me to believe you would like a formula that: 1. Finds the first appearance of #NA in the sequence of cells. 2. Counts the number of #NAs from that point that are in one uninterrupted sequence. 3. Ignores all other #NAs in the range. Here is a formula for the above: =INDEX(FREQUENCY(IF(ISNA($A$1:$L$1),COLUMN($A$1:$L$1)),IF(NOT(ISNA($A$1:$L$1)),COLUMN($A$1:$L$1))),MATCH(TRUE,FREQUENCY(IF(ISNA($A$1:$L$1),COLUMN($A$1:$L$1)),IF(NOT(ISNA($A$1:$L$1)),COLUMN($A$1:$L$1)))0,0)) Enter with CSE (ctrl-shift-enter) - array formula. Something tells me it could be done with a shorter formula, but this is the best I've got for you at the moment :) See Attached sample, or the same via Google Docs: https://docs.google.com/open?id=1nXP7jG6Obg1IHKhSr28outPlddX6zMKW3lWSd-I9_XA (@ GDocs, FileDownload or FileExport to Google Spreadsheet) Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Divaker Pandey Sent: Friday, April 20, 2012 4:36 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Count intial #NA in a row using excel function Hi Expert, Please see attached sheet. Divaker -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Excel Puzzle
Rajan, A most excel-ant game, thank you for sharing. Kind Regards. Michael Brumby Diese Email und samtliche beigefugten Anhange sind vertraulich zu behandeln und sind vor Veroffentlichung geschutzt. Informieren Sie den Absender bitte umgehend und loschen Sie diese Nachricht mit allen beigefugten Anhangen, falls Sie nicht der vorgesehene Empfanger sind. Der Inhalt dieser Email darf nicht an oder von dritten weitergeleitet, veroffentlicht, verwendet, oder kopiert werden, oder durch jegliches Medium gespeichert werden. From: Rajan_Verma rajanverma1...@gmail.com To: excel-macros@googlegroups.com Sent: Fri, 22 July, 2011 15:32:33 Subject: $$Excel-Macros$$ Excel Puzzle Hope you will like it, J -- -- 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ CURSOR GOES TO PARTICULAR CELL WHEN I START THE FILE
C P SAVLA You don't need a macro for this, just make sure that the cell is selected when you save the file and it will open in the same cell when you next open the file... Kind regards Michael UK From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of big smile Sent: 02 September 2010 05:28 To: EXCEL MACRO GROUP Subject: $$Excel-Macros$$ CURSOR GOES TO PARTICULAR CELL WHEN I START THE FILE Respected Excel Guru's How to make the macro so that When ever i start the file my cursor goes into that particular cell only. For EX. Sheet 2 - A494 etc. The purpose behing this is ex. i have set the target of achieving certain amount -- so how much still pending to achieve. Thanks have a nice day. C P SAVLA -- -- 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 __ Information from ESET Smart Security, version of virus signature database 5417 (20100902) __ The message was checked by ESET Smart Security. http://www.eset.com -- -- 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$$ Microsoft Most Valuable Professional (MVP)
Team, I agree, come on team, we have enough members and it's a great idea Kind regards to everyone in our group and don't forget to vote... Michael Brumby Kent, UK From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Vinod N Sent: 19 July 2010 09:51 To: excel-macros Subject: $$Excel-Macros$$ Microsoft Most Valuable Professional (MVP) Hi Team, How about nominating Ayush, Dilip, Ankur and Dave for Microsoft MVP... http://mvp.support.microsoft.com/gp/mvpnominate -- Thanks and Regards Vinod N http://cavinod.blogspot.com/ -- -- 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 __ Information from ESET Smart Security, version of virus signature database 5293 (20100719) __ The message was checked by ESET Smart Security. http://www.eset.com -- -- 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$$ How we can open 2007 file in 2003.
Team, Send file to a friend who has 2007 and ask them to save it in 2003 format but remember some of the effects will be lost as 2003 may not be able to do everything that 2007 can. Hope this helps. Michael From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Vijay Aggarwal Sent: 15 July 2010 13:38 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ How we can open 2007 file in 2003. Hi All, If I am receiving a file in excel 2007 (***.xlsx) then how can I open that file in excel 2003 (***.xls). 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 __ Information from ESET Smart Security, version of virus signature database 5281 (20100715) __ The message was checked by ESET Smart Security. http://www.eset.com -- -- 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