Recent content by kaushik03

Dear PCosta, Truly appreciate your time and effort in helping me on this. Please note that, the position of the message should not be static. It should be in accordance with the position of fireworks explosion (on the tip of the fireworks). Essentially, the co-ordinates of the message should...

Dear All, I was looking at Chandoo's fireworks explosion workbook and was trying to customize it. http://chandoo.org/wp/2014/07/17/fireworks-chart-video-tutorial/ What I am trying to achieve is to have a short text message (let's say : crossed X Million etc.) appear at the end of each random...

can someone please address this problem?

Hi all, I am trying to find the top occurrence in a column with multiple values in a cell. Let me explain what I want. In the attached file(with sample data), 1. Column B contains some entries which I am trying to find the top occurrence from, basis the criteria in column A and C 2. Let me...

Hi guys!!! Thanks all for your help. @Mike: It works like a charm!!! Hats off to you man!! May I please request you to explain me (with a short write up) how the formula works. Looking forward to your explanation.. Many thanks dude!!

Hi All, I have text string as follows in column A (cell A1 and A2): standard_units_mth_01_2013 standard_units_mth_02_2013 What I want in col B (in cell B1 and B2) are: Jan-13 Feb-13 Could you please get me the formula for the same? Regards, Kaushik

can someone of you please address this?

Hi all, I am working on a project where in I am automating the process of updating the ppt from excel (looping through slides and updating text in the shapes, underlying chart data, table etc). Let me give you a bit of background before getting into the real problem: 1)I am copying excel data...

Hi friends... Can someone of you help me in making a simple bullet chart for showing target v/s sales! Attached here is the sample data. Looking forward to your reply!! Regards, Kaushik

Hi Mrslikethesoup, I understand the example given in the Customer List sheet but having hard time in understanding your example in Map sheet. Could you plz answer my below questions: What is the criteria to get the corresponding unit on the 'Map' sheet? What is the relation with map and the...

Hi all, What I am trying to do here is: I have a date stored at A1 in "MM/D/YYYY" format (e.g., 10/1/2013 = October,1, 2013). Date format at A1 will always be fixed. Now the same date is stored in many places across the worksheets of this workbook. I want to run a macro which should check...

It worked...thanks Narayan.....you are brilliant... But just curious...earlier I did the same without declaring the variable type and it worked...could you please explain me the logic behind! Regards, Kaushik

Hi all, I am getting an error while doing match for date. In the workbook attached, I am trying to find the date stored in I2 in the range A1 to Z1, but getting an error.(see the code in mod1). Could you plz fix it and let me know the reason! Kaushik

Hi Ian, Could you please upload your file with sample data? Kaushik

Dear All, I am working on a userform which requires further enhancement for which I need your help. Let me first explain what this tool is doing.. Description of the tool: In the home tab if you click on ‘Click here to submit your idea’, it will open the userform( which user uses to submit...