RE: $$Excel-Macros$$ currencies
Thanks Ashish. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: 10 October 2013 20:46 To: excel-macros Subject: Re: $$Excel-Macros$$ currencies try this one too if thr are chances of duplicate records On Thu, Oct 10, 2013 at 6:49 PM, priti verma mailto:pritiverma1...@gmail.com>> wrote: Hi Krishnaraddi, Please see the attachment. On Thu, Oct 10, 2013 at 6:53 AM, Krishnaraddi V. Madolli mailto:krishnaraddi.mado...@asia.xchanging.com>> wrote: Hi Experts, Please find below table for name and currencies: Name Currencies Krishna USD Krishna Rs Harsha Rs Phani Euro Phani USD If name has multiple currencies I need to get answer as Multiple currency & if name has only one currency then answer should be single currency. In above scenario: Krishna - Multiple currency. Harsha - Single currency. Phani - Multiple currency. Your help is much appreciated in this rehgards. "CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you are not the intended recipient please telephone or e-mail the sender and delete this message and any attachment from your system." -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com<mailto:excel-macros%2bunsubscr...@googlegroups.com>. To post to this group, send email to excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com<mailto:excel-macros%2bunsubscr...@googlegroups.com>. To post to this group, send email to excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Regards Ashish Koul Visit My Excel Blog<http://www.excelvbamacros.com/> Like Us on Facebook<http://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897> Join Us on Facebook<http://www.facebook.com/groups/163491717053198/> P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Acknowledg
$$Excel-Macros$$ currencies
Hi Experts, Please find below table for name and currencies: Name Currencies Krishna USD Krishna Rs Harsha Rs Phani Euro Phani USD If name has multiple currencies I need to get answer as Multiple currency & if name has only one currency then answer should be single currency. In above scenario: Krishna - Multiple currency. Harsha - Single currency. Phani - Multiple currency. Your help is much appreciated in this rehgards. "CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you are not the intended recipient please telephone or e-mail the sender and delete this message and any attachment from your system." -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
RE: $$Excel-Macros$$ Fiscal Period calculation
Thanks Noorain bai. Regards, Krishnaraddi V Madolli. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 31 July 2013 17:49 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Fiscal Period calculation Dear Krishna, Try it ="Q"&INT((MONTH($A2)-1)/3)+1&"-"&TEXT($A2,"") or =LOOKUP(MONTH(A2),{1,4,7,10},{"Q1","Q2","Q3","Q4"})&"-"&TEXT($A2,"") see attachment for more clarity. On Wed, Jul 31, 2013 at 4:01 PM, Krishnaraddi V. Madolli mailto:krishnaraddi.mado...@asia.xchanging.com>> wrote: Hi Experts, Do we have excel formula to calculate Fiscal Period from the date. Ex: [cid:image001.png@01CE8E20.C5E4B1C0] Regards, Krishnaraddi V Madolli. "CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you are not the intended recipient please telephone or e-mail the sender and delete this message and any attachment from your system." -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com<mailto:excel-macros%2bunsubscr...@googlegroups.com>. To post to this group, send email to excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- With Regards, Noorain Ansari http://<http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> http://<http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com> -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com<mailto:excel-macros+unsubscr...@googlegroups.com>. To post to this group, send email to excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in
RE: $$Excel-Macros$$ Fiscal Period calculation
Thanks. Regards, Krishnaraddi V Madolli. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Gaurav Garg Sent: 31 July 2013 16:13 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Fiscal Period calculation find the formula closing date Fiscal Period 1-Jan-12 Q1-2012 =+IF(MONTH(B6)<=3,"Q1",IF(MONTH(B6)<=6,"Q2",IF(MONTH(B6)<=9,"Q3",IF(MONTH(B6)<=12,"Q4",""&"-"&YEAR(B6) 2-May-12 Q2-2012 5-Sep-12 Q3-2012 6-Oct-12 Q4-2012 1-Jan-13 Q1-2013 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com<mailto:excel-macros+unsubscr...@googlegroups.com>. To post to this group, send email to excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. "CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you are not the intended recipient please telephone or e-mail the sender and delete this message and any attachment from your system." -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Fiscal Period calculation
Hi Experts, Do we have excel formula to calculate Fiscal Period from the date. Ex: [cid:image001.png@01CE8E07.35F27340] Regards, Krishnaraddi V Madolli. "CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you are not the intended recipient please telephone or e-mail the sender and delete this message and any attachment from your system." -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. <>
$$Excel-Macros$$ group dates into months
Does anyone know how to group dates into months in a Pivot table in Excel 2003? Regards, Krishnaraddi V Madolli. "CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you are not the intended recipient please telephone or e-mail the sender and delete this message and any attachment from your system." -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
RE: $$Excel-Macros$$ Intersection of points in graph
Thanks a lot Ashish. Regards, Krishnaraddi V Madolli. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: 26 June 2013 20:48 To: excel-macros Subject: Re: $$Excel-Macros$$ Intersection of points in graph . check the attachment see if it helps On Wed, Jun 26, 2013 at 12:42 PM, Krishnaraddi V. Madolli mailto:krishnaraddi.mado...@asia.xchanging.com>> wrote: "CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you are not the intended recipient please telephone or e-mail the sender and delete this message and any attachment from your system." -- Regards Ashish Koul Visit My Excel Blog<http://www.excelvbamacros.com/> Like Us on Facebook<http://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897> Join Us on Facebook<http://www.facebook.com/groups/163491717053198/> P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com<mailto:excel-macros+unsubscr...@googlegroups.com>. To post to this group, send email to excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Intersection of points in graph
"CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you are not the intended recipient please telephone or e-mail the sender and delete this message and any attachment from your system." <> Intersection of points.xlsx Description: Intersection of points.xlsx
$$Excel-Macros$$ Charts
Hi, Is there a way to make default font for charts we prepare in excel every time. At present it is Calibri, I want to change it Century Gothic style for all the new charts I create. Regards, Krishnaraddi V Madolli. "CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you are not the intended recipient please telephone or e-mail the sender and delete this message and any attachment from your system." -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
RE: $$Excel-Macros$$ Macro running time
Thanks, I got it. 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.com<mailto:krishnaraddi.mado...@asia.xchanging.com> krishnaraddi.mado...@sedgwickcms.com<mailto:krishnaraddi.mado...@sedgwickcms.com> www.sedgwickcms.com<https://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: Vabz [mailto:v...@vabs.in] Sent: 09/26/2012 16:28 To: excel-macros@googlegroups.com Cc: Krishnaraddi V. Madolli Subject: Re: $$Excel-Macros$$ Macro running time Hi Please refer following link for more details: http://www.mrexcel.com/archive/VBA/20164.html Rgds//Vabs On Wednesday, September 26, 2012 3:40:17 PM UTC+5:30, Krishnaraddi V. Madolli wrote: Hi Experts, Can anyone let me know how populate running time of macro. Ex: If I run any macro, At the end of macro I should get how much time it took to complete macro. 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.com krishnaraddi.mado...@sedgwickcms.com www.sedgwickcms.com<https://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. Please consider the environment before printing this message "CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you are not the intended recipient please telephone or e-mail the sender and delete this message and any attachment from your system." -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. <>
$$Excel-Macros$$ Macro running time
Hi Experts, Can anyone let me know how populate running time of macro. Ex: If I run any macro, At the end of macro I should get how much time it took to complete macro. 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.com<mailto:krishnaraddi.mado...@asia.xchanging.com> krishnaraddi.mado...@sedgwickcms.com<mailto:krishnaraddi.mado...@sedgwickcms.com> www.sedgwickcms.com<https://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 "CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you are not the intended recipient please telephone or e-mail the sender and delete this message and any attachment from your system." -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. <>
$$Excel-Macros$$ Pyramid Chart
Hi All, Just want to know is there any way in excel to prepare Pyramid chart like below. If Yes please let me know how to prepare. [cid:image001.jpg@01CD9A8E.265E9A20] 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.com<mailto:krishnaraddi.mado...@asia.xchanging.com> krishnaraddi.mado...@sedgwickcms.com<mailto:krishnaraddi.mado...@sedgwickcms.com> www.sedgwickcms.com<https://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 "CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you are not the intended recipient please telephone or e-mail the sender and delete this message and any attachment from your system." -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. <><>
RE: $$Excel-Macros$$ Copy excel files from different folders
Thanks a lot. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajan_Verma Sent: 29 August 2012 19:47 To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Copy excel files from different folders You can visit here http://excelpoweruser.wordpress.com/2012/08/17/get-all-files-hyperlinks-in-excel/ Download this file Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com> [mailto:excel-macros@googlegroups.com] On Behalf Of Krishnaraddi V. Madolli Sent: 29 August 2012 7:43 To: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com> Subject: $$Excel-Macros$$ Copy excel files from different folders Hi Experts, Do we have code to extract all excel files from sub folder. Ex: In Main folder we have 20 sub folders consists of excel files. I want to extract all 20 excel files and copy them to different location. Thanks & Regards. Krishna. "CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you are not the intended recipient please telephone or e-mail the sender and delete this message and any attachment from your system." -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com<mailto:excel-macros+unsubscr...@googlegroups.com>. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com<mailto:excel-macros+unsubscr...@googlegroups.com>. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ Copy excel files from different folders
Hi Experts, Do we have code to extract all excel files from sub folder. Ex: In Main folder we have 20 sub folders consists of excel files. I want to extract all 20 excel files and copy them to different location. Thanks & Regards. Krishna. "CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you are not the intended recipient please telephone or e-mail the sender and delete this message and any attachment from your system." -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
RE: $$Excel-Macros$$ Sheet To WB
Thanks Amresh I will check this. Thanks for your valuable time. 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.com<mailto:krishnaraddi.mado...@asia.xchanging.com> krishnaraddi.mado...@sedgwickcms.com<mailto:krishnaraddi.mado...@sedgwickcms.com> www.sedgwickcms.com<https://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 Amresh Maurya Sent: 08/27/2012 18:33 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Sheet To WB Hi, use this macros also ... hope help you. Sub nee() If ThisWorkbook.Worksheets.Count > 1 Then Sheets("master").Activate For i = 2 To ThisWorkbook.Worksheets.Count Application.DisplayAlerts = False ThisWorkbook.Worksheets(2).Delete Application.DisplayAlerts = True Next End If Application.ScreenUpdating = False n = 2 m = 3 ThisWorkbook.Worksheets.Add(after:=ThisWorkbook.Worksheets(ThisWorkbook.Worksheets.Count)).Name = "Temp" For i = 1 To 223 If Sheets("master").Cells(n, 1) = Sheets("master").Cells(m, 1) Then Sheets("temp").Cells(n, 1) = "Ture" Else 'Application.DisplayAlerts = False r = Sheets("master").Cells(n, 1) 'ThisWorkbook.Worksheets(r).Delete 'Application.DisplayAlerts = True ThisWorkbook.Worksheets.Add(after:=ThisWorkbook.Worksheets(ThisWorkbook.Worksheets.Count)).Name = r t = Sheets("master").Cells(n, 1) Sheets("master").Activate nb = Sheets("master").UsedRange.Rows.Count Selection.AutoFilter ActiveSheet.Range("A1" & ":" & "M" & nb).AutoFilter Field:=1, Criteria1:=t Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Range("A1").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy Sheets(t).Cells.Range("A1") End If n = n + 1 m = m + 1 Next Application.DisplayAlerts = False ThisWorkbook.Worksheets("temp").Delete Application.DisplayAlerts = True Sheets("master").Activate Selection.AutoFilter Sheets("master").Cells.Range("A1").Select MsgBox "Done" End Sub Regards Amresh On Mon, Aug 27, 2012 at 5:41 PM, Krishnaraddi V. Madolli mailto:krishnaraddi.mado...@asia.xchanging.com>> wrote: Hi Noorain, Thanks a lot. I will change this code as per my requirements. 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.com<mailto:krishnaraddi.mado...@asia.xchanging.com> krishnaraddi.mado...@sedgwickcms.com<mailto:krishnaraddi.mado...@sedgwickcms.com> www.sedgwickcms.com<https://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> [mailto:excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>] On Behalf Of NOORAIN ANSARI Sent: 08/27/2012 17:33 To: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com> Subject: Re: $$Excel-Macros$$ Sheet To WB Dear Krishan, Please see attached workbook, I have created a compiler, which are creating workbook name wise. Hope it will help to you for your query. Please revert if it will not help to you. I will do it in your data On Mon, Aug 27, 2012 at 3:29 PM, Krishnaraddi V. Madolli mailto:krishnaraddi.mado...@asia.xchanging.com>> wrote: "CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it
RE: $$Excel-Macros$$ Sheet To WB
Hi Noorain, Thanks a lot. I will change this code as per my requirements. 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.com<mailto:krishnaraddi.mado...@asia.xchanging.com> krishnaraddi.mado...@sedgwickcms.com<mailto:krishnaraddi.mado...@sedgwickcms.com> www.sedgwickcms.com<https://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 NOORAIN ANSARI Sent: 08/27/2012 17:33 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Sheet To WB Dear Krishan, Please see attached workbook, I have created a compiler, which are creating workbook name wise. Hope it will help to you for your query. Please revert if it will not help to you. I will do it in your data On Mon, Aug 27, 2012 at 3:29 PM, Krishnaraddi V. Madolli mailto:krishnaraddi.mado...@asia.xchanging.com>> wrote: "CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you are not the intended recipient please telephone or e-mail the sender and delete this message and any attachment from your system." -- With Regards, Noorain Ansari http://<http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> http://<http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com> -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com<mailto:excel-macros+unsubscr...@googlegroups.com>. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. <>
RE: $$Excel-Macros$$ Sheet To WB
I want data for only one city in one workbook for example in attached sheet, 4 city name data is present so I want 4 separate workbooks each contains data for only one city. Hence finally I will get 4 workbooks saved based on city name. Hope I explained better. 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.com<mailto:krishnaraddi.mado...@asia.xchanging.com> krishnaraddi.mado...@sedgwickcms.com<mailto:krishnaraddi.mado...@sedgwickcms.com> www.sedgwickcms.com<https://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 NOORAIN ANSARI Sent: 08/27/2012 15:48 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Sheet To WB Dear Krishna, Please explain what you exact want. On Mon, Aug 27, 2012 at 3:29 PM, Krishnaraddi V. Madolli mailto:krishnaraddi.mado...@asia.xchanging.com>> wrote: "CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you are not the intended recipient please telephone or e-mail the sender and delete this message and any attachment from your system." -- With Regards, Noorain Ansari http://<http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> http://<http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com> -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com<mailto:excel-macros+unsubscr...@googlegroups.com>. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. <>
RE: $$Excel-Macros$$ Count Based on Date & Time
Thanks DON, Is there any Macro to do this since Data will be added to second sheet in future so. Once again thanks for your valuable time spent. 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.com<mailto:krishnaraddi.mado...@asia.xchanging.com> krishnaraddi.mado...@sedgwickcms.com<mailto:krishnaraddi.mado...@sedgwickcms.com> www.sedgwickcms.com<https://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 dguillett1 Sent: 08/20/2012 18:27 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Count Based on Date & Time See attached using sumproduct formula based on defined names Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com<mailto:dguille...@gmail.com> From: Krishnaraddi V. Madolli<mailto:krishnaraddi.mado...@asia.xchanging.com> Sent: Monday, August 20, 2012 5:46 AM To: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com> Subject: $$Excel-Macros$$ Count Based on Date & Time Hi Experts, I have attached Volume report consisting of two sheets called Volume Log & Detailed Report. >From detailed report (Sheet2) I want count on daily basis for particular day >based on Date Assigned and assigned time between 7:30AM to 5:00PM data should >come in same day. After 5 PM it should reflect in next day count. Same data has to be updated in sheet 1 (Volume Log) in first two columns with Date and numbers. Thanks in advance for your valuable time. 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.com<mailto:krishnaraddi.mado...@asia.xchanging.com> krishnaraddi.mado...@sedgwickcms.com<mailto:krishnaraddi.mado...@sedgwickcms.com> www.sedgwickcms.com<https://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 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com<mailto:excel-macros+unsubscr...@googlegroups.com>. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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 compet
RE: $$Excel-Macros$$ Count Based on Date & Time
I want count of how many assigned on that particular day based on Date Assigned column in second sheet but time should be between 7:30AM to 5:00 PM to take count of that day. Ex: how many assigned on 6th August between 7:30AM to 5:00 PM, if date is 6th and time is above 5 PM then it should come in 7th August data. 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.com<mailto:krishnaraddi.mado...@asia.xchanging.com> krishnaraddi.mado...@sedgwickcms.com<mailto:krishnaraddi.mado...@sedgwickcms.com> www.sedgwickcms.com<https://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 Kuldeep Singh Sent: 08/20/2012 16:25 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Count Based on Date & Time Hi, Kindly more explain. Regards, Kuldeep Singh On Mon, Aug 20, 2012 at 4:16 PM, Krishnaraddi V. Madolli mailto:krishnaraddi.mado...@asia.xchanging.com>> wrote: "CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you are not the intended recipient please telephone or e-mail the sender and delete this message and any attachment from your system." -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com<mailto:excel-macros+unsubscr...@googlegroups.com>. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. <>
RE: $$Excel-Macros$$ Some Help
Solution Attached. 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.com krishnaraddi.mado...@sedgwickcms.com 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. Please consider the environment before printing this message -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashjain2...@yahoo.co.in Sent: Tuesday, July 24, 2012 6:53 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Some Help We want to use data validation... Please see the attachment Ashok Maroti -- -- 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 "CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you are not the intended recipient please telephone or e-mail the sender and delete this message and any attachment from your system." -- -- 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 Ashok.xls Description: Ashok.xls
RE: $$Excel-Macros$$ regarding ratio
http://spreadsheetpage.com/index.php/tip/a_formula_to_calculate_a_ratio/ 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.com<mailto:krishnaraddi.mado...@asia.xchanging.com> krishnaraddi.mado...@sedgwickcms.com<mailto:krishnaraddi.mado...@sedgwickcms.com> www.sedgwickcms.com<https://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 19, 2012 1:35 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ regarding ratio Dear all, Please do me one favor. I tried to find out the ratio between two numbers but seems the formula isn't working. So can you please help me. Thank you 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<mailto:excel-macros@googlegroups.com> To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com<mailto:excel-macros+unsubscr...@googlegroups.com> "CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you are not the intended recipient please telephone or e-mail the sender and delete this message and any attachment from your system." -- -- 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 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.com<mailto:krishnaraddi.mado...@asia.xchanging.com> krishnaraddi.mado...@sedgwickcms.com<mailto:krishnaraddi.mado...@sedgwickcms.com> www.sedgwickcms.com<https://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 mailto:rohan.j...@gmail.com>> wrote: just correct your answer =COUNTIF($E$10:E49,"GIRL") On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल mailto: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<mailto: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<mailto: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<mailto:excel-macros@googlegroups
Re: $$Excel-Macros$$ FW: Highlighting the Text based on the Week day.....
Use =WEEKDAY(A3)=6 in conditional formating. Original message From:""Mohammed Muneer""< mmun...@ccc.com.qa >Date: 11 Jun 12 20:22:43Subject: $$ExcelMacros$$ FW: Highlighting the Text based on the Week day.To: Sorry I forgot to attaché the file… 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) Crosspromotion 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 excelmac r...@googlegroups.com To unsubscribe, send a blank email to excelmacros+unsubscribe@googlegroups.comGet Yourself a cool, short @in.com Email ID now! -- 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$$ Gauge Chart
Hi Experts, I want to learn about Gauge Chart in excel please send me training details with examples and template to work.Dear excelmacros ! Get Yourself a cool, short @in.com Email ID now! -- 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
$$Excel-Macros$$ Need help
Hi Experts, I have attached the sheet with question. I require formula which will give number to repeat 11 times and 12th numer should be next serial number which should reeat again 11 times.Dear excelmacros! Get Yourself a cool, short @in.com Email ID now! -- 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 Book1.xls Description: MS-Word document
$$Excel-Macros$$ Need help
Hi Experts, I have attached the sheet with question. I require formula which will give number to repeat 11 times and 12th numer should be next serial number which should reeat again 11 times.Dear excelmacros! Get Yourself a cool, short @in.com Email ID now! -- 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 Book1.xls Description: MS-Word document
$$Excel-Macros$$ Need help
Hi Experts, I have attached the sheet with question. I require formula which will give number to repeat 11 times and 12th numer should be next serial number which should reeat again 11 times.Dear excelmacros! Get Yourself a cool, short @in.com Email ID now! -- 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 Book1.xls Description: MS-Word document
$$Excel-Macros$$ Need help
Hi Experts, I have attached the sheet with question. I require formula which will give number to repeat 11 times and 12th numer should be next serial number which should reeat again 11 times.Dear excelmacros! Get Yourself a cool, short @in.com Email ID now! -- 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 Book1.xls Description: MS-Word document
$$Excel-Macros$$ Need help
Hi Experts, I have attached the sheet with question. I require formula which will give number to repeat 11 times and 12th numer should be next serial number which should reeat again 11 times.Dear excelmacros! Get Yourself a cool, short @in.com Email ID now! -- 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 Book1.xls Description: MS-Word document
Re: $$Excel-Macros$$ Need help
Hi Experts, I have attached the sheet with question. I require formula which will give number to repeat 11 times and 12th numer should be next serial number which should reeat again 11 times.Dear excelmacros! Get Yourself a cool, short @in.com Email ID now! -- 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 Book1.xls Description: MS-Word document
$$Excel-Macros$$ Pivot table
Hi Excel gurus, I have attached excel sheet consisting of pivot table, For second column in the attached sheet I need count. How to achieve this without using Macros. Thanks in advance. KrishDear excelmacros! Get Yourself a cool, short @in.com Email ID now! -- 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 Pivot_table.xls Description: MS-Word document