$$Excel-Macros$$ currencies

2013-10-10 Thread Krishnaraddi V. Madolli
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

RE: $$Excel-Macros$$ currencies

2013-10-10 Thread Krishnaraddi V. Madolli
, priti verma pritiverma1...@gmail.commailto:pritiverma1...@gmail.com wrote: Hi Krishnaraddi, Please see the attachment. On Thu, Oct 10, 2013 at 6:53 AM, Krishnaraddi V. Madolli krishnaraddi.mado...@asia.xchanging.commailto:krishnaraddi.mado...@asia.xchanging.com wrote: Hi Experts, Please find

$$Excel-Macros$$ Fiscal Period calculation

2013-07-31 Thread Krishnaraddi V. Madolli
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

RE: $$Excel-Macros$$ Fiscal Period calculation

2013-07-31 Thread Krishnaraddi V. Madolli
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

RE: $$Excel-Macros$$ Fiscal Period calculation

2013-07-31 Thread Krishnaraddi V. Madolli
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

$$Excel-Macros$$ group dates into months

2013-07-05 Thread Krishnaraddi V. Madolli
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

$$Excel-Macros$$ Intersection of points in graph

2013-06-26 Thread 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

RE: $$Excel-Macros$$ Intersection of points in graph

2013-06-26 Thread Krishnaraddi V. Madolli
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

$$Excel-Macros$$ Charts

2013-06-25 Thread Krishnaraddi V. Madolli
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

$$Excel-Macros$$ Macro running time

2012-09-26 Thread Krishnaraddi V. Madolli
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

RE: $$Excel-Macros$$ Macro running time

2012-09-26 Thread Krishnaraddi V. Madolli
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

$$Excel-Macros$$ Pyramid Chart

2012-09-24 Thread Krishnaraddi V. Madolli
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

$$Excel-Macros$$ Copy excel files from different folders

2012-08-29 Thread Krishnaraddi V. Madolli
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

RE: $$Excel-Macros$$ Copy excel files from different folders

2012-08-29 Thread Krishnaraddi V. Madolli
://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.commailto:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Krishnaraddi V. Madolli Sent: 29 August 2012 7:43

RE: $$Excel-Macros$$ Sheet To WB

2012-08-27 Thread Krishnaraddi V. Madolli
[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 krishnaraddi.mado

RE: $$Excel-Macros$$ Sheet To WB

2012-08-27 Thread Krishnaraddi V. Madolli
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

RE: $$Excel-Macros$$ Sheet To WB

2012-08-27 Thread Krishnaraddi V. Madolli
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

RE: $$Excel-Macros$$ Count Based on Date Time

2012-08-20 Thread Krishnaraddi V. Madolli
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

RE: $$Excel-Macros$$ Count Based on Date Time

2012-08-20 Thread Krishnaraddi V. Madolli
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

RE: $$Excel-Macros$$ Some Help

2012-07-24 Thread Krishnaraddi V. Madolli
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

RE: $$Excel-Macros$$ regarding ratio

2012-07-19 Thread Krishnaraddi V. Madolli
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

RE: $$Excel-Macros$$ Need formula to take out total number of boy and girl

2012-07-12 Thread Krishnaraddi V. Madolli
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