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$$ Need Help for Macro or Formula
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 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 Sample sheet.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Need Help for Macro or Formula
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 Sample+sheet(1).xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Need Help for Macro or Formula
check the sheet. On Fri, May 14, 2010 at 9:25 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 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 Saurabh Singh -- -- 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 Sample sheet-updtd.xls Description: MS-Excel spreadsheet