Re: $$Excel-Macros$$ Need Help for Macro or Formula
Thanks Harry i want formula for Column D. the formula what i have mention in email needs to be enhance or change 1. if for code in column A, status in column C is Paid,Not Paid,Awaiting then Final Status should be Not to process in column D 2. if for code in column A, status in column C is only paid then findal status should be process in column D 3. there is one blank row after each unique code in column A i hope i have clear my query. On Sat, May 15, 2010 at 10:28 AM, harpreetgujral harpreetguj...@gmail.comwrote: Hi Mahesh, You wrote: *Dear All * *for attach sheet i need formula or macro, I will appreciate any help on this. 1.if for code in column A ,status in column C is paid then D column status should be process 2.if status in column C is not paid or awaiting then D column status should be not to process 3. there is blank line between two codes in column A below mention formula not working. =IF(A3=,,IF(C3=Paid,Process,Not to process)) * In the attached sheet, first two points have been closed. 3) point is not clear at all. Syntax of the If formula is as follows: =IF(Condition,Statement if condition is true,statement if condition is false) If you can throw some more light on what do you want to achieve, then may be we can help you Thanks Harry -- -- 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 6,800 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 6,800 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 Help for Macro or Formula
Enter Following Formula in Cell D2 =IF(C2=Paid,Process,IF(C2=,,(Not to Process))) Regards Jagjeet SIngh On May 14, 8:55 pm, Mahesh parab mahes...@gmail.com wrote: Dear All for attach sheet i need formula or macro, I will appreciate any help on this. 1.if for code in column A ,status in column C is paid then D column status should be process 2.if status in column C is not paid or awaiting then D column status should be not to process 3. there is blank line between two codes in column A below mention formula not working. =IF(A3=,,IF(C3=Paid,Process,Not to process)) -- -- 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 athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 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 athttp://groups.google.com/group/excel-macros/subscribe Sample sheet.xls 26KViewDownload -- -- 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 6,800 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$$ Ms Office 2007 Certification
Dear All, I wish to get Certification in Ms Office 2007 (Ms Word, Ms Excel, Ms Outlook, Ms Powerpoint, Ms Access). How do i prepare for it. Any how I am almost familiar with all the advance options of Ms Word and Ms Excel but still would prefer to take up a preparation and wish to score the HIGHEST in the test. Any one of you if already been certified in this please share your experience and score secured in the test. Reach me at my mail id or give me your contact info so that i can have voice chat at your free time. Your ideas and suggestions will be highly appreciated. Regards Ahmed Bawazir -- -- 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 6,800 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$$ vlookup with 2 criteria
use vlookup ( match ,,,) funtion or sumproduct or array formula On Mon, May 10, 2010 at 8:10 PM, Sandeep Kumar Maurya sandymau...@gmail.com wrote: Hi nino, check my reply in the $$Excel-Macros$$ Maximum Date problem. Thanks Regards Sandeep On Sun, May 9, 2010 at 1:12 PM, Ravi Megharaj ravi.megha...@gmail.com wrote: You can concatenate Column A and Column B to get the unique value. Then do a vlookup to get the exact value. Once performing this operation, you can delete the concatenated column. Hope this helps Ta Ravi On Sun, May 9, 2010 at 12:04 PM, madhu nair madhuna...@gmail.com wrote: send a sample sheet buddy On Sun, May 9, 2010 at 12:07 AM, nino nki...@gmail.com wrote: hi, does anyone have idea or solution to solve search over 2 columns range where both criteria needs to be met. e.g. if you have database with 3 columns. column A is account, column B is cost centar and column C is value. I would like to search for value of specific account for specific cost center. vlookup can find the value for specific account, but sa,e account occurs on multiple cost centres. thx. nino -- -- 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 6,800 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 -- Thanks, Madhu Nair -- -- 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 6,800 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 6,800 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 6,800 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 -- Manoj -- -- 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 6,800 subscribers worldwide and receive many nice notes about
$$Excel-Macros$$ Please suggest
Hi All, I am Sandeep one of the group member like you, I am living in West Delhi Uttam Nagar wanted to Learn VBA( Macros ), Access and SQL. if you know abt any institute, any faculty, any good book or any thing which help to learn this Please Reply the mail or may ID sandeepxxxku...@gmail.com -- Thanks Regards: ╚►♥ѕαη∂єєρ♥◄╝ -- -- 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 6,800 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$$ VBA Coaching Instiute In New Delhi
If u really interested in learning VBA better to googling yield a good result. Coaching won't benefit you go through some e books and join any forum related with VBA. You will learn a lot. Rgds, Aligahk06 On May 8, 3:03 pm, deepak kumar deepaktheind...@gmail.com wrote: Hi All, Please let me know if anyone knows any VBA coaching institute in New Delhi... Thanks Deepak Kumar -- --- --- 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 athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 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 athttp://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 6,800 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$$ Do not request or provide copyrighted eBook in group.
Yeah Ayush had said is true. On Sat, May 15, 2010 at 10:41 AM, Ayush jainayus...@gmail.com wrote: Dear Group, Please do not send any request of copyrighted material in group. Any ebook/material which is copyrighted should not be shared in forum as it is a loss for the owner of that item. You are always welcome to share thoughts, idea , queries, tips and tricks in group. They are not copyrighted at all :) I hope you understand the same. Any such message again could lead to termination from the group membership. Keep Posting. Best regards, Ayush Jain Group Owner -- -- 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 6,800 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 6,800 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