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...
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 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
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 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...
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
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...
Hi All,
I am working to create a dynamic chart. I will explain my requirement by using dummy data in the file uploaded here:
http://speedy.sh/vEVqy/Chart.xlsx
I have sales for different sales executives across multiple (and different) products for 12 months (please see data from B2 to O11...
Hi All,
I am trying to build a chart to show the monthly sales trend at territory level and national lavel across three different segments.Let me explain it further to you:
1) Chart will show the trend from July to December for the segments S1, S2 and S3 for both territory and national level...
Hi all,
It's been quite a long time I have not been able to visit the forum...really missing you all wonderful people here!!!
However, I have come back with a small problem.
The output I require is explained in the workbook uploaded here:
http://speedy.sh/yfvd5/Number-Pattern.xlsx...
Hi all,
I have automated a daily report (which earlier involves some sort manual work) by which user would be able to send(through e-mail) the report to all the intended recipients on click of a button.
In addition to my code, I have taken the reference of Ron's code to send the report...
Hi all,
I have an annoying problem here.
What I am doing here is, based on criteria I am coloring the rows.
Criteria1:
Fill rows with green if due date = today (Col F contains due date) and status <> pending scoping call (Col G contains project status)
Criteria2:
Fill rows with...
Good morning all,
There was a post by "mrbilly" around 4 days ago. I provided him a solution with VBA based approach.
But before I get into the coding, I tried to resolve the problem with formula only, but I could not come up with proper formula as a solution for this problem.
Below here is...
Hi all,
Following piece of code is not working while trying to lock column
Sheet1.Range("A:A").Locked = True
After running the code, once I go back and write something in Col A, I am not being prevented from doing so..
Can you plz tell me where I am doing wrong or what needs to be done...
Hi all,
I need to assign IDs to some number pattern. Here is the sample data:
1a>>>> Alpha>> dfs
1b>>>> Alpha>> f
1c>>>> Alpha>> a
1d>>>> Alpha>> e
2a>>>> Beta>> fg...
Hi All,
Wanted to know a trick from you...
Say, from A2 to E4, I have the following data
10>>>>> 15>>>>> 20>>>>> 25>>>>> 30
50>>>>> 80>>>>> 56>>>>>...
Hi All,
I have a quick question for all of you.
I have a spreadsheet which has three tabs
Tab1: Home page
Tab2: Input data(with fixed number of columns and varied number of rows)
Tab3: dashboard (containing dynamic charts, and other reports). In tab3, data is updated according to the...
Hi All,
I want to catch errors for the following scenarios:
If same name assigned with different codes or same code assigned with different name, are considered as errors.
Code Name
1 xyz
2 mns
3 xyz
2 pqr
4 abc
5 uio
In the above data, row 1 and row 3 should be error , same for...
Hi All,
Say I have the below macro:
Sub MyMacro ()
MsgBox “Hi All”
End Sub
I want to access this macro from any computer in work station (say I have 50 computers, one for each user) whenever I open an excel application.
How to do this?
Regards,
Kaushik
Hi all,
I have come across a peculiar problem in conditional formatting.
I am fetching some numbers(%) by array formula in a column and apply conditional formatting icon set(3 traffic lights unrimmed) which works perfectly well.
in value box I have placed the numbers and in type box I...
Hi all,
I have data as follows from A1 to A6:
AA
BB
X
CC
X
DD
I want to construct a formula at B1 and drag it all the way down so that it gives me data as follows:
AA
BB
CC
DD
In a word, I want to get the list without X.
Kaushik
Hi All,
I am trying to build a project status chart for which I need your help.Here is the sample data:
http://speedy.sh/NCdy3/Project-Status-Chart-data.xlsx
Now let me explain my requirement…
Column A contains the project ID, Col B contains project lead, Col C project end date and Col D...
Hi All,
Say I have 100 cells (A1:A100) which are filled with some data. Some of these cells are filled with color (it could be any color). I want to know which are the cells filled with color and which color/colorindex it is?
I am looking for some formula based approach(no UDF).
Looking...