RE: $$Excel-Macros$$ currencies

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

$$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 abo

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 it

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

$$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 reci

$$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, fo

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 if it

$$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 pleas

$$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 confidentia

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$$ 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

$$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

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.com<mailto:excel-macros@googlegroups.com> [mailto:excel-macros@googlegroups.com] On Behalf Of Krishnaraddi V. Madolli Sent: 29 August 201

$$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$$ 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$$ 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
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

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$$ 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$$ 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

Re: $$Excel-Macros$$ FW: Highlighting the Text based on the Week day.....

2012-06-11 Thread Krishnaraddi
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+ member

$$Excel-Macros$$ Gauge Chart

2012-04-23 Thread Krishnaraddi
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

$$Excel-Macros$$ Need help

2012-04-18 Thread Krishnaraddi
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

$$Excel-Macros$$ Need help

2012-04-18 Thread Krishnaraddi
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

$$Excel-Macros$$ Need help

2012-04-18 Thread Krishnaraddi
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

$$Excel-Macros$$ Need help

2012-04-18 Thread Krishnaraddi
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

$$Excel-Macros$$ Need help

2012-04-18 Thread Krishnaraddi
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

Re: $$Excel-Macros$$ Need help

2012-04-18 Thread Krishnaraddi
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

$$Excel-Macros$$ Pivot table

2012-03-21 Thread Krishnaraddi
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