Hello, Some people have this habit ; it’s useless.
Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Jenie Envoyé : mercredi 23 février 2011 20:38 À : excel-macros@googlegroups.com Objet : RE: $$Excel-Macros$$ Macro Help - Please! Hello excel experts, what is the importance of using + in formula as shown below? I the plus sign, still the formula worked correct!!! =+IF(A5="VP","Pass",IF(A5="Step","Complete","")) =IF(A5="VP","Pass",IF(A5="Step","Complete","")) Thanks From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rohan Young Sent: Wednesday, February 23, 2011 8:15 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Macro Help - Please! HI Kamal, Please see the attachment if it helps, Regards ROHAN On Tue, Feb 22, 2011 at 6:33 PM, NOORAIN ANSARI <noorain.ans...@gmail.com> wrote: Dear Kamal, Please see attached sheet..if it help.. On Mon, Feb 21, 2011 at 11:25 PM, kamal shah <kamal...@gmail.com> wrote: Hello Excel Gurus, Need small favour from experts, I have two columns in Excel, I need a macro, where if Column A contains value as "Step", column B should populate "Complete". If column A contains VP, Column B should populate "Pass". Step Complete VP Pass Step Complete VP Pass VP Pass Step Complete VP Not Run Step Not Run VP Not Run VP Not Run Step Not Run VP Not Run Your help is highy appreciated. cheers Kamal -- ---------------------------------------------------------------------------- ------ 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 <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <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 -- Thanks & regards, Noorain Ansari -- ---------------------------------------------------------------------------- ------ 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 -- ---------------------------------------------------------------------------- ------ 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