Re: $$Excel-Macros$$ Unique list
Dear Seraj, Please check attached sheet, There is no solution in it. On Thu, Jul 12, 2012 at 9:51 AM, joseph camill joseph.cam...@gmail.comwrote: Hi Seraj, Attached is the reference sheet. Thanks, Joseph On Thu, Jul 12, 2012 at 9:15 AM, Seraj Alam seraj.ala...@gmail.comwrote: Hi, Please attach the sheet for reference... Thanks Seraj On Wed, Jul 11, 2012 at 8:41 PM, joseph.cam...@gmail.com wrote: Hi experts, The formulae provided by the members is working fine when I have data in one column. But if I have to do the same from multiple columns, then how do I do? Thanks, Joseph Sent on my BlackBerry® from Vodafone -- 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 -- Thanks Regards Seraj Alam *+91 989 130 1776* -- 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 -- 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 -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Unique list
Dear Joseph, Please try it.. Sub Unique_List_Creater() Dim i As Long Dim col As Long Dim rw As Long Dim sh As Worksheet Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Set sh = ThisWorkbook.Sheets(3) sh.Range(F2:F sh.Cells(Rows.Count, F).End(xlUp).Row). ClearContents sh.Range(F1).Value = Unique List i = sh.Cells(Rows.Count, F).End(xlUp).Row + 1 j = 2 For col = 1 To sh.Cells(1, 1).End(xlToRight).Column For rw = 2 To sh.Cells(Rows.Count, 1).End(xlUp).Row sh.Cells(rw, col).Copy sh.Cells(j, F) j = j + 1 Next rw Next col sh.Range(F2:F sh.Cells(Rows.Count, F).End(xlUp).Row).RemoveDuplicates 1 Application.ScreenUpdating = True Application.Calculation = xlCalculationAutomatic End Sub see attached sheet for reference On Thu, Jul 12, 2012 at 9:11 AM, joseph.cam...@gmail.com wrote: Hi experts, The formulae provided by the members is working fine when I have data in one column. But if I have to do the same from multiple columns, then how do I do? Thanks, Joseph Sent on my BlackBerry® from Vodafone -- 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 -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ switch on anf off calculation
Hi Don, Thanks a lot for this, Regards, Pawel From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, July 11, 2012 1:13 PM Subject: Re: $$Excel-Macros$$ switch on anf off calculation sub yourmacro() Application.Calculation=xlCalculationManual your macro Application.Calculation=xlCalculationautomatic end sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Wednesday, July 11, 2012 1:56 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ switch on anf off calculation Thanks for that but how to do this ? how to set it up, sorry but not very good at it, I've just started to learn VB. Can you help me? Thanks Pawel From: ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Wednesday, July 11, 2012 3:05 AM Subject: Re: $$Excel-Macros$$ switch on anf off calculation Use this line in your macro :- Application.Calculation=xlCalculationManual Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From: pawel lupinski lupins...@yahoo.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Wednesday, 11 July 2012 7:03 AM Subject: $$Excel-Macros$$ switch on anf off calculation Hi All, can you help me on this. I have quite large excel file, because there is a lot of calculation, I'd like to switch off excel calculation and when I'll be closing file schitch on calculation. I mean by macro (manually I know how to do this :) ) thanks a lot Pawel -- 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 -- 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 -- 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 -- 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
Re: $$Excel-Macros$$ Round The Value as User Defined.
Dear Ashish, You can also use.. *=ROUND(A2/5,0)*5 * -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, Jul 12, 2012 at 9:35 AM, Ashish Bhalara ashishbhalar...@gmail.comwrote: Dear experts, I want to round the value in following condition. If the value is 148,149,150,151,152, Output is 150. If the value is 153,154,155,156,157, Output is 155. If the value is 158,159,160,161,162, Output is 160. Kindly know me how its possible. Thanks regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- 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 -- 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$$ currency and currency Symbol
Hi Expert, Can any one provide me currency name with symbol. 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Need formula to take out total number of boy and girl
Dear all, Can you please help me to find out the total number of boy and girl ? I used countif for their grade and it worked. However, for girl and boy seggregation it isnot working. Thank you very much for the support you all have been providing. sunita -- 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 BGA.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Round The Value as User Defined.
i learn lot of command, thanks noorainansarihttp://www.noorainansari.com/ sir. On Thu, Jul 12, 2012 at 1:28 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Ashish, You can also use.. *=ROUND(A2/5,0)*5 * -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, Jul 12, 2012 at 9:35 AM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, I want to round the value in following condition. If the value is 148,149,150,151,152, Output is 150. If the value is 153,154,155,156,157, Output is 155. If the value is 158,159,160,161,162, Output is 160. Kindly know me how its possible. Thanks regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- 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 -- 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 -- *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex :Otteri, Vellore-2* -- 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$$ Need formula to take out total number of boy and girl
Dear Sunita, Find the attached sheet. Regards, Kuldeep Singh naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Thu, Jul 12, 2012 at 2:59 PM, सुनिता पौडेल tosune...@gmail.com wrote: wow thnx... is there any way to find out like in certain grade how many girl or boy studies?? Thank you On Thu, Jul 12, 2012 at 3:11 PM, Rohan Young rohan.j...@gmail.com wrote: just correct your answer =COUNTIF($E$10:E49,GIRL) On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल tosune...@gmail.com wrote: Dear all, Can you please help me to find out the total number of boy and girl ? I used countif for their grade and it worked. However, for girl and boy seggregation it isnot working. Thank you very much for the support you all have been providing. sunita -- 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 -- 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 -- 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 -- 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 BGA.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
RE: $$Excel-Macros$$ Need formula to take out total number of boy and girl
You can use COUNTIFS function. Regards, Krishnaraddi V Madolli. Data Analytics Team Sedgwick Claims Management Services, Inc. Xchanging Towers, SJR iPark, EPIP Area, Whitefield Bangalore - 560 066. India. Direct Line: +1.800.920.9657 Extn 1915 Switchboard: +90-(0)80-3054 Extn 1915 Email: krishnaraddi.mado...@asia.xchanging.commailto:krishnaraddi.mado...@asia.xchanging.com krishnaraddi.mado...@sedgwickcms.commailto:krishnaraddi.mado...@sedgwickcms.com www.sedgwickcms.comhttps://outlook.us.xchanging.com/exchweb/bin/redir.asp?URL=http://www.sedgwickcms.com | The leader in innovative claims and productivity management solutions Success is never permanent, Failure is never final, so always do not stop effort until your victory makes a history. [http://images.coolchaser.com/themes/t/404137-i311.photobucket.com-albums-kk467-volleycutiegirl-icon.png]Please consider the environment before printing this message From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ?? ? Sent: Thursday, July 12, 2012 2:59 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl wow thnx... is there any way to find out like in certain grade how many girl or boy studies?? Thank you On Thu, Jul 12, 2012 at 3:11 PM, Rohan Young rohan.j...@gmail.commailto:rohan.j...@gmail.com wrote: just correct your answer =COUNTIF($E$10:E49,GIRL) On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल tosune...@gmail.commailto:tosune...@gmail.com wrote: Dear all, Can you please help me to find out the total number of boy and girl ? I used countif for their grade and it worked. However, for girl and boy seggregation it isnot working. Thank you very much for the support you all have been providing. sunita -- 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.commailto:excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.commailto:excel-macros%2bunsubscr...@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.commailto:excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.commailto:excel-macros%2bunsubscr...@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.commailto:excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.commailto:excel-macros+unsubscr...@googlegroups.com CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged.
Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl
Hi Sunita, You can also *try.. =SUMPRODUCT(--($E$10:E49=GIRL))* On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल tosune...@gmail.com wrote: Dear all, Can you please help me to find out the total number of boy and girl ? I used countif for their grade and it worked. However, for girl and boy seggregation it isnot working. Thank you very much for the support you all have been providing. sunita -- 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 -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl
You Can also use.. *=DCOUNTA($E$9:$E$49,E9,G1:G2)* See attached sheet. On Thu, Jul 12, 2012 at 3:04 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Hi Sunita, You can also *try.. =SUMPRODUCT(--($E$10:E49=GIRL))* On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल tosune...@gmail.com wrote: Dear all, Can you please help me to find out the total number of boy and girl ? I used countif for their grade and it worked. However, for girl and boy seggregation it isnot working. Thank you very much for the support you all have been providing. sunita -- 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 -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Copy of BGA-1(DCOUNTA).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Round The Value as User Defined.
It's only my pleasure, On Thu, Jul 12, 2012 at 3:00 PM, jmothilal gjmothi...@gmail.com wrote: i learn lot of command, thanks noorainansarihttp://www.noorainansari.com/ sir. On Thu, Jul 12, 2012 at 1:28 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Ashish, You can also use.. *=ROUND(A2/5,0)*5 * -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, Jul 12, 2012 at 9:35 AM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, I want to round the value in following condition. If the value is 148,149,150,151,152, Output is 150. If the value is 153,154,155,156,157, Output is 155. If the value is 158,159,160,161,162, Output is 160. Kindly know me how its possible. Thanks regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- 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 -- 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 -- *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex :Otteri, Vellore-2* -- 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 -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl
wohoo so may options thnx guys ..it really worked out thank you so much Sunita On Thu, Jul 12, 2012 at 3:25 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: You Can also use.. *=DCOUNTA($E$9:$E$49,E9,G1:G2)* See attached sheet. On Thu, Jul 12, 2012 at 3:04 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Hi Sunita, You can also *try.. =SUMPRODUCT(--($E$10:E49=GIRL))* On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल tosune...@gmail.comwrote: Dear all, Can you please help me to find out the total number of boy and girl ? I used countif for their grade and it worked. However, for girl and boy seggregation it isnot working. Thank you very much for the support you all have been providing. sunita -- 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 -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Sumif / Sumproduct formula required.
Dear friends, I want to call a function/formula here that show me the sum of the each item separately from the given descriptions. Regards, Muneer, CC. -- 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 Book1.xls Description: Book1.xls
Re: $$Excel-Macros$$ Sumif / Sumproduct formula required.
PFA On Thu, Jul 12, 2012 at 3:53 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: see attached sheet. On Thu, Jul 12, 2012 at 3:53 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Muneer, Please use below formula =SUMPRODUCT((A2:A8=D5)*(B2:B8)) or =Sumif(A2:A8,d5,B2:B8) On Thu, Jul 12, 2012 at 3:49 PM, Mohammed Muneer mmun...@ccc.com.qawrote: ** Dear friends, I want to call a function/formula here that show me the sum of the each item separately from the given descriptions. Regards, Muneer, CC. -- 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 -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Book1(1).xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ count the name in a column
Hi Friends, Could you please help in counting the name in a column. Thanks N.Sundarvelan 9600160150 -- 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 Book2.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ count the name in a column
Dear Sundar, Please use.. =*COUNTIF(B:B,*C2*)* On Thu, Jul 12, 2012 at 4:12 PM, Sundarvelan N nsund...@gmail.com wrote: Hi Friends, Could you please help in counting the name in a column. Thanks N.Sundarvelan 9600160150 -- 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 -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Copy of Book2.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need formula
Dear Prashant, Please use =INDEX($A$2:$A$4,1) or =OFFSET($A$1,1,0) see attached sheet. On Thu, Jul 12, 2012 at 4:50 PM, Prashant Pawle ppawle.ex...@gmail.comwrote: Dear All, Need a formula for getting first text in the Range, in particular cell , sample file attached Regards, Prashant -- 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 -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Book5(Prashant).xlsm Description: Binary data
Re: $$Excel-Macros$$ Need formula
Dear noor, Please let me know the formula if first cell is empty Then it shd take next cell in array Regards, Prashant On Thu, Jul 12, 2012 at 3:23 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Prashant, Please use =INDEX($A$2:$A$4,1) or =OFFSET($A$1,1,0) see attached sheet. On Thu, Jul 12, 2012 at 4:50 PM, Prashant Pawle ppawle.ex...@gmail.comwrote: Dear All, Need a formula for getting first text in the Range, in particular cell , sample file attached Regards, Prashant -- 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 -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Need formula
Dear Prashant, You can try.. *=OFFSET($A$1,COUNTIF($A$2:$A$4,),0)* On Thu, Jul 12, 2012 at 5:04 PM, Prashant Pawle ppawle.ex...@gmail.comwrote: Dear noor, Please let me know the formula if first cell is empty Then it shd take next cell in array Regards, Prashant On Thu, Jul 12, 2012 at 3:23 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Prashant, Please use =INDEX($A$2:$A$4,1) or =OFFSET($A$1,1,0) see attached sheet. On Thu, Jul 12, 2012 at 4:50 PM, Prashant Pawle ppawle.ex...@gmail.comwrote: Dear All, Need a formula for getting first text in the Range, in particular cell , sample file attached Regards, Prashant -- 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 -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
RE: $$Excel-Macros$$ Sumif / Sumproduct formula required.
Thanx Noor for this also, But I need to change the description in same cell to get individual total. Sewage/Sweet/Garbage all this totals from one cell. Hope u understand this time. Regards, Muneer, CC... see attached sheet. On Thu, Jul 12, 2012 at 3:53 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Muneer, Please use below formula =SUMPRODUCT((A2:A8=D5)*(B2:B8)) or =Sumif(A2:A8,d5,B2:B8) On Thu, Jul 12, 2012 at 3:49 PM, Mohammed Muneer mmun...@ccc.com.qa wrote: Dear friends, I want to call a function/formula here that show me the sum of the each item separately from the given descriptions. Regards, Muneer, CC. -- 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 mailto:excel-macros%2bunsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com http://www.excelmacroworld.blogspot.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com http://www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ count the name in a column
Thanks noorain jee, its working fine! Please make me sure about crireria field why should we put c2. Regards, @Suman Send on the move with Galexy y. On Jul 12, 2012 4:15 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Sundar, Please use.. =*COUNTIF(B:B,*C2*)* On Thu, Jul 12, 2012 at 4:12 PM, Sundarvelan N nsund...@gmail.com wrote: Hi Friends, Could you please help in counting the name in a column. Thanks N.Sundarvelan 9600160150 -- 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 -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Add my Outlook id
Dear Nitin, you can join group through below link... http://groups.google.com/group/excel-macros/subscribe On Thu, Jul 12, 2012 at 5:32 PM, Nitin Updhyay nitinupadhyay2...@gmail.comwrote: Hi, Please add my mail id in your group nitin.upadh...@in.aegisglobal.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ count the name in a column
Dear Suman, Please see attached sheet, Cell C2 is criteria Field On Thu, Jul 12, 2012 at 5:30 PM, Suman ksuman1...@gmail.com wrote: Thanks noorain jee, its working fine! Please make me sure about crireria field why should we put c2. Regards, @Suman Send on the move with Galexy y. On Jul 12, 2012 4:15 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Sundar, Please use.. =*COUNTIF(B:B,*C2*)* On Thu, Jul 12, 2012 at 4:12 PM, Sundarvelan N nsund...@gmail.comwrote: Hi Friends, Could you please help in counting the name in a column. Thanks N.Sundarvelan 9600160150 -- 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 -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Copy of Book2(SUman).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Remove 0 from Whole workbook without using Macro.(Interesting)
Thanks Guru jee its great! On Thu, Jul 12, 2012 at 4:25 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Group, Please find attached screen shot, We can remove 0 from whole workbook without using any function or any Macro. See technique and revert. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- *Suman Kumar* *Mob: +91-9810333884* *RIM-+91-9555629292* -- 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.comA_html_m691da4f3.gif
Re: $$Excel-Macros$$ Add my Outlook id
Hi, Noorain I am not able to do this.. Link not working for new ID.. Please add my outlook id as well nitin.upadh...@in.aegisglobal.com On Thu, Jul 12, 2012 at 5:33 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Nitin, you can join group through below link... http://groups.google.com/group/excel-macros/subscribe On Thu, Jul 12, 2012 at 5:32 PM, Nitin Updhyay nitinupadhyay2...@gmail.com wrote: Hi, Please add my mail id in your group nitin.upadh...@in.aegisglobal.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Remove 0 from Whole workbook without using Macro.(Interesting)
Why not just elect in advanced options to NOT show zeros for the workbook? Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: NOORAIN ANSARI Sent: Thursday, July 12, 2012 5:55 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Remove 0 from Whole workbook without using Macro.(Interesting) Dear Group, Please find attached screen shot, We can remove 0 from whole workbook without using any function or any Macro. See technique and revert. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Add my Outlook id
Dear Nitin, Send a mail to group Manager Mr. Ayush Jain Email ID is :jainayus...@gmail.com nitin.upadh...@in.aegisglobal.com On Thu, Jul 12, 2012 at 5:39 PM, Nitin Updhyay nitinupadhyay2...@gmail.comwrote: Hi, Noorain I am not able to do this.. Link not working for new ID.. Please add my outlook id as well nitin.upadh...@in.aegisglobal.com On Thu, Jul 12, 2012 at 5:33 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Nitin, you can join group through below link... http://groups.google.com/group/excel-macros/subscribe On Thu, Jul 12, 2012 at 5:32 PM, Nitin Updhyay nitinupadhyay2...@gmail.com wrote: Hi, Please add my mail id in your group nitin.upadh...@in.aegisglobal.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Sumif / Sumproduct formula required.
So exactly what you are looking for? A drop down list to show the total in adjacent column? I have created a dropdown, if you looking for somthing else, then please explain a bit more On Thu, Jul 12, 2012 at 5:21 PM, Mohammed Muneer mmun...@ccc.com.qa wrote: Thanx *Noor *for this also, But I need to change the description in same cell to get individual total. Sewage/Sweet/Garbage all this totals from one cell. Hope u understand this time. Regards, Muneer, CC… see attached sheet. On Thu, Jul 12, 2012 at 3:53 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Muneer, Please use below formula =SUMPRODUCT((A2:A8=D5)*(B2:B8)) or =Sumif(A2:A8,d5,B2:B8) ** ** On Thu, Jul 12, 2012 at 3:49 PM, Mohammed Muneer mmun...@ccc.com.qa wrote: Dear friends, I want to call a function/formula here that show me the sum of the each item separately from the given descriptions. Regards, Muneer, CC. -- 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 -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com ** ** -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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
Re: $$Excel-Macros$$ Time calculation
Hi Noorain, Thanks for resolving the query. Now i got the correct result. Regards Lokesh.M On Thu, Jul 12, 2012 at 9:04 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Lokesh, Please find the attached sheet, Hope it will help to you. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, Jul 12, 2012 at 8:21 AM, Lokesh Loki lokeshsmg2...@gmail.comwrote: Hi All, Please find the attached excel sheet and i need formula for total time taken. Let me know for any clarification. Regards Lokesh.M -- 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 -- 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 -- 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$$ output of maximum number from list of combine text and number
What type of solution are you looking for? (VBA macro, Excel function) What is the source of the list? (text file, excel sheet) What do you want to do with the result? (use in macro, output to Excel worksheet) Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Ashish Bhalara ashishbhalar...@gmail.com To: excel-macros@googlegroups.com Sent: Thu, July 12, 2012 8:50:12 AM Subject: $$Excel-Macros$$ output of maximum number from list of combine text and number Dear expert, I want to get output of maximum number from the list which contain combination of text and number. I can get this by change of cell format but it is not useful for me. For example, List Nano/Ref/003 Nano/Ref/002 Nano/Ref/001 Nano/Mfg.Subv/002 Nano/Mfg.Subv/001 Fiat/Crp/002 Fiat/Crp/001 Output Nano/Ref/003 Nano/Mfg.Subv/002 Fiat/Crp/002 Thanks regards. Ashish Bhalara 9624111822 PPlease do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣ -- 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 -- 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$$ R1C1
I received a spreadsheet that is using the R1C1 reference formula. If I turn turn off the R1C1 to apply the A1 reference will that then change how the formula works? Thanks ! -- 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$$ Can´t get around a macro
I implemented this now Private Sub corrermac() Sheets(Datas).Select If Range(B1).Value = Range(C1).Value Then Call julho ElseIf Range(B2).Value = Range(C2).Value Then Call agosto End Sub Sub julho() Sheets(Dias acidente).Select Range(B2:B32).Select Selection.ClearContents Sheets(Dias acidente).Select End Sub Sub agosto() Sheets(Dias acidente).Select Range(B2:B32).Select Selection.ClearContents Sheets(Dias acidente).Select End Sub in order to delete the days of the past month and so the vlookup to clear the colors and start from 1 again Any suggestion to a more precise and clean code? thank you 2012/7/12 Jorge Marques leote.w...@gmail.com Hi guys, I have this macro I´ve made with a vlookup that one of you kindly help, I then developed a macro to everyday put a Sim in a scheduled time, and put the color green on the correspondent day and if Não puts red color, but I have a problem. The vlookup conditional formatting doesn´t work if I have numbers duplicated. How can i reset the colors when it starts a new month without having to delete the contents of cells B1 to B33 in order to start a again the calendar in sheet1? I could do a sort of if month(today()) = 7 then delete range(B1:B33) elseif month(today()) = 8 then range (B34:B63) delete, but this is coding too much for unnecessary lines, is there a way to do this and simplifying? Another think I thought is doing a vlookup of (monthtoday()). Thank you very much in advance My macro for this is: Sub acidentes() Dim RunTime2 As Date Sheets(Dias acidente).Select Cells(1, 7).Value = Cells(1, 7) + 1 RunTime2 = Now + TimeValue(00:00:10) Application.OnTime RunTime2, acidentes Cells(1, 3).End(xlDown).Offset(1, 0).Select Selection.Value = Sim For i = 1 To 550 If Cells(i, 3).Value = Sim Then Cells(i, 4).Value = Sem acidente Cells(i, 4).Interior.ColorIndex = 4 ElseIf Cells(i, 3).Value = Não Then Cells(i, 4).Value = Com Acidente Cells(i, 4).Interior.ColorIndex = 3 Cells(i, 3).Value = CA Cells(1, 7).Value = Cells(1, 7).Value - 1 Cells(1, 8).Value = Cells(1, 7).Value Cells(1, 7).Value = 0 End If Next If Range(H13).Value = stop Then Application.OnTime RunTime2, acidentes, , False End If End Sub -- 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 -- 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$$ output of maximum number from list of combine text and number
How about a macro Sub GetMaxPerCategory() Columns(e:f).ClearContents For Each c In Range(a2:a8) Name = Split(c, /)(0) / Split(c, /)(1) n = Split(c, /)(2) Set mf = Columns(e).Find(What:=Name, LookIn:=xlValues, _ LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext) If Not mf Is Nothing Then If Val(n) Cells(mf.Row, f) Then Cells(mf.Row, f) = n Else c.Offset(, 4) = Name c.Offset(, 5) = Val(n) End If Next c End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Ashish Bhalara Sent: Thursday, July 12, 2012 7:49 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ output of maximum number from list of combine text and number Dear expert, I want to get output of maximum number from the list which contain combination of text and number. I can get this by change of cell format but it is not useful for me. For example, List Nano/Ref/003 Nano/Ref/002 Nano/Ref/001 Nano/Mfg.Subv/002 Nano/Mfg.Subv/001 Fiat/Crp/002 Fiat/Crp/001 Output Nano/Ref/003 Nano/Mfg.Subv/002 Fiat/Crp/002 Thanks regards. Ashish Bhalara 9624111822 PPlease do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣ -- 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 -- 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$$ R1C1
Try it Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Sunnie Sent: Thursday, July 12, 2012 8:43 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ R1C1 I received a spreadsheet that is using the R1C1 reference formula. If I turn turn off the R1C1 to apply the A1 reference will that then change how the formula works? Thanks ! -- 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 -- 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$$ R1C1
Sunnie, Can you share spreadsheet with group as a sample. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, Jul 12, 2012 at 7:13 PM, Sunnie sunni...@gmail.com wrote: I received a spreadsheet that is using the R1C1 reference formula. If I turn turn off the R1C1 to apply the A1 reference will that then change how the formula works? Thanks ! -- 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 -- 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$$ Need formula
Hi, Use this array formula to get 1st filled cell value in a range.hope it will help you =INDEX($A$1:$A$5,LARGE(--(A1:A5)*ROW(A1:A5),SUM(--(A1:A5))),1) Priti verma From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 12 July 2012 5:15 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need formula Dear Prashant, You can try.. =OFFSET($A$1,COUNTIF($A$2:$A$4,),0) On Thu, Jul 12, 2012 at 5:04 PM, Prashant Pawle ppawle.ex...@gmail.com wrote: Dear noor, Please let me know the formula if first cell is empty Then it shd take next cell in array Regards, Prashant On Thu, Jul 12, 2012 at 3:23 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Prashant, Please use =INDEX($A$2:$A$4,1) or =OFFSET($A$1,1,0) see attached sheet. On Thu, Jul 12, 2012 at 4:50 PM, Prashant Pawle ppawle.ex...@gmail.com wrote: Dear All, Need a formula for getting first text in the Range, in particular cell , sample file attached Regards, Prashant -- 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 mailto:excel-macros%2bunsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com http://www.excelmacroworld.blogspot.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com mailto:excel-macros%2bunsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com mailto:excel-macros%2bunsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com http://www.excelmacroworld.blogspot.com www.excelmacroworld.blogspot.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
$$Excel-Macros$$ column width - Reg
Dear any one I am using sheet1 worksheet column a to n , Column width is differents based on datas. same data format different places up 20 sheets. i want align sheet 2 to 20 column width based on sheet1. Thanks with -- *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex :Otteri, Vellore-2* -- 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$$ Re: column width - Reg
Hi Mothi, Please attach your workbook, your question is not clear. regards prince On Thursday, 12 July 2012 20:48:49 UTC+5:30, mothi wrote: Dear any one I am using sheet1 worksheet column a to n , Column width is differents based on datas. same data format different places up 20 sheets. i want align sheet 2 to 20 column width based on sheet1. Thanks with -- *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex :Otteri, Vellore-2* -- 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$$ Unique list
Thanks Noorain, Can you give me a formula to retrieve this. Thanks, Joseph Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI noorain.ans...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 12 Jul 2012 11:47:55 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Unique list Dear Joseph, Please try it.. Sub Unique_List_Creater() Dim i As Long Dim col As Long Dim rw As Long Dim sh As Worksheet Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Set sh = ThisWorkbook.Sheets(3) sh.Range(F2:F sh.Cells(Rows.Count, F).End(xlUp).Row). ClearContents sh.Range(F1).Value = Unique List i = sh.Cells(Rows.Count, F).End(xlUp).Row + 1 j = 2 For col = 1 To sh.Cells(1, 1).End(xlToRight).Column For rw = 2 To sh.Cells(Rows.Count, 1).End(xlUp).Row sh.Cells(rw, col).Copy sh.Cells(j, F) j = j + 1 Next rw Next col sh.Range(F2:F sh.Cells(Rows.Count, F).End(xlUp).Row).RemoveDuplicates 1 Application.ScreenUpdating = True Application.Calculation = xlCalculationAutomatic End Sub see attached sheet for reference On Thu, Jul 12, 2012 at 9:11 AM, joseph.cam...@gmail.com wrote: Hi experts, The formulae provided by the members is working fine when I have data in one column. But if I have to do the same from multiple columns, then how do I do? Thanks, Joseph Sent on my BlackBerry® from Vodafone -- 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 -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Re: Need formula
hi Prashant, Use this =INDEX(A2:A4,MATCH(TRUE,LEN(A2:A4)0,0),1) with Ctrl+shift+enter regards prince dubey On Thursday, 12 July 2012 16:50:22 UTC+5:30, ppawle.excel wrote: Dear All, Need a formula for getting first text in the Range, in particular cell , sample file attached Regards, Prashant -- 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$$ Sumif / Sumproduct formula required.
=SUMPRODUCT((TRIM(A2:A22)={sewage,sweet,garbage})*(B2:B22)) Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Mohammed Muneer Sent: Thursday, July 12, 2012 6:51 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Sumif / Sumproduct formula required. Thanx Noor for this also, But I need to change the description in same cell to get individual total. Sewage/Sweet/Garbage all this totals from one cell. Hope u understand this time. Regards, Muneer, CC… see attached sheet. On Thu, Jul 12, 2012 at 3:53 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Muneer, Please use below formula =SUMPRODUCT((A2:A8=D5)*(B2:B8)) or =Sumif(A2:A8,d5,B2:B8) On Thu, Jul 12, 2012 at 3:49 PM, Mohammed Muneer mmun...@ccc.com.qa wrote: Dear friends, I want to call a function/formula here that show me the sum of the each item separately from the given descriptions. Regards, Muneer, CC. -- 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 mailto:excel-macros%2bunsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Re: column width - Reg
Dear Mothi, Please share sample workbook with group On Thu, Jul 12, 2012 at 9:37 PM, Prince Dubey prince141...@gmail.comwrote: Hi Mothi, Please attach your workbook, your question is not clear. regards prince On Thursday, 12 July 2012 20:48:49 UTC+5:30, mothi wrote: Dear any one I am using sheet1 worksheet column a to n , Column width is differents based on datas. same data format different places up 20 sheets. i want align sheet 2 to 20 column width based on sheet1. Thanks with -- *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex :Otteri, Vellore-2* -- 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 -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Thousand seperator in Millions
You can get this done by changing language regional settings of your PC. Thanks, Joseph Sent on my BlackBerry® from Vodafone -Original Message- From: Dileep Kumar deepuk...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 12 Jul 2012 19:30:18 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Cc: Haseeb Avarakkanhaseeb.avarak...@gmail.com Subject: $$Excel-Macros$$ Thousand seperator in Millions Hi Friends, I have a situation here, I have a data sheet coloum c contains some numbers in indian comma style but I need comma in westran style(Millions) can any one please help me... -- Regards, Dileep Kumar Kaza Duty is God Work is Worship -- 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 -- 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$$ Re: column width - Reg
Are you wanting to do this manually? or with a macro? To do it manually, 1. Select the sheets you want updated. 2. Select Sheet1 3. Right-click on the first column to change 4. Select Column Width from the menu 5. Hit OK (or change the ## and hit OK) Repeat steps 3-5 for all columns... -- If you want to use a macro: This macro will change ALL sheets to be the same column width as the sheet named Sheet1. - Option Explicit Sub Match_ColumnWidth() Dim Col, ColFirst, ColLast ColFirst = 1 ColLast = 30 ActiveWorkbook.Sheets.Select Sheets(Sheet1).Activate Application.ScreenUpdating = False For Col = ColFirst To ColLast Cells(1, Col).EntireColumn.Select Selection.ColumnWidth = Selection.ColumnWidth Next Col Application.ScreenUpdating = True Range(A1).Select End Sub - If you want only SPECIFIC sheets changed (not all sheets in the workbook) then change the following macro to include only those sheets you want to update: - Sub Match_ColumnWidth2() Dim Col, ColFirst, ColLast ColFirst = 1 ColLast = 30 Sheets(Array(Sheet1, _ Sheet2, _ Sheet3, _ Sheet4, _ Sheet5, _ Sheet6, _ Sheet7, _ Sheet8, _ Sheet9 _ )).Select Sheets(Sheet1).Activate Application.ScreenUpdating = False For Col = ColFirst To ColLast Cells(1, Col).EntireColumn.Select Selection.ColumnWidth = Selection.ColumnWidth Next Col Application.ScreenUpdating = True Range(A1).Select End Sub Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Prince Dubey prince141...@gmail.com To: excel-macros@googlegroups.com Sent: Thu, July 12, 2012 12:11:20 PM Subject: $$Excel-Macros$$ Re: column width - Reg Hi Mothi, Please attach your workbook, your question is not clear. regards prince On Thursday, 12 July 2012 20:48:49 UTC+5:30, mothi wrote: Dear any one I am using sheet1 worksheet column a to n , Column width is differents based on datas. same data format different places up 20 sheets. i want align sheet 2 to 20 column width based on sheet1. Thanks with -- J.Mothilal : Universal Computer Systems : # 16, Brindavan Complex :Otteri, Vellore-2 -- 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 -- 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