Search results

Hello Forum, I'm very new to VBA and struggling with how I alter a macro to apply formatting when the number of rows changes from month to month. I used the macro recorder on a very simple example and I found the following snippet below to find the last row. But I'm not following where I add...

Hello Forum, I just discovered VBA and I'm trying to write a conditional macro where VBA will add (x) number of rows depending on how many separate numbers appear in a specific cell. However, I can't find any postings that specifically address this scenario. I've attached a generic and...

Hello, I'm trying to use a SUMIF's formula to calculate a sum if a column contains the following values, "EWS Duplicate Detection", "EWS/ANF" or "EWS/RNF". I'm not sure if the SUMIF's formula is the right one for this because SUMIF's require that all conditions be met. The formula needs to...

Hello, I'm trying to take the difference of two values, divide that answer by 1000 to make the answer more readable and add a "K" to the end of the number to denote the number being in thousands. The answer should look like "$88K". Here is a general example of what I'm trying to produce. I...

Hello, I'm having trouble with a SUMIFS formula where I need to return a dollar value for a range between 0 and 30 days and if the customer type code is either B or E. I've tried using this formula: =SUMIFS($B$3:$B$27,$C$3:$C$27,"0 to 30 Days",$D$3:$D$27,"B")*OR($D$3:$D$27,"E") but it isn't...

Hi Chandoo Forum, I’m having trouble creating a custom number format on a two axis graph. The primary axis should run from 0 to 30,000 in increments of 10,000 in the lower half of the graph and stop showing numbers above 30,000 in the same way the secondary axis works. I tried using...

Hello Forum, I'm practicing with the skills required in a Chandoo KPI dashboard post on microcharts. When I try to replicate the microchart that is in the example file, I cannot get the "Average" data series to extend all way down to the last data point. This tutorial is found at this address...

Dear Forum, I've been practicing with a few formulas found in a Chandoo posting on how to build a KPI dashboard. In one particular tutorial post, the tutorial describes how to create conditional formatting using triangle symbols to denote percentile values. This tutorial is found here...

Hello friends, I'm working on a sales report where I rank the three products with the largest year over year increase. I've ranked them but I need a formula for the three products with ranking 1,2,3 that will retrieve the name in column B as well as the Y-Y increase in units in column I and...

Hello, A recent Chandoo post on formula forensics asked the question of how to write a formula that will average the last 3 values larger than zero. (http://chandoo.org/wp/2013/10/03/formula-forensics-no-035-average-the-last-3-values-greater-than-0/ I followed the sample file and tried...

Hello, I searched through the forum for help with the IF formula displaying text but didn't find anything on this. I want to display in a cell either,"Credit Card Sales Above 12 Month Ave by X %," or "Credit Card Sales Below 12 Month Ave by X %". I was able to get the formula close in cell...

Hi, Is VLOOKUP capable of returning a number on the contents of a particular cell instead of a particular name? I looked through various articles on Chandoo but couldn't find an answer. My VLOOKUP formula works great when I use it like this: =VLOOKUP("Juno",$B$5:$G$17,2,FALSE) to return the...

Hi, I'm trying to find the top ten largest values in a list. Currently, the formula in place retrieves the top ten items in order of lowest value. How do I modify the formula to retrieve the top ten largest numerical values in order (top item - largest value down to item with the lowest...

Hi, I'm struggling with a dynamic range graph formula. I can get it to work when the data is aligned vertically. But when I try to change the offset formula so that it reads the most recent 12 values horizontally, the formula returns an error message. It's a small problem in the formula...

Hello, I was practicing creating a multiples chart using the directions from a Chandoo post. The directions instruct the user to create an area chart and then to add the same data twice using paste special in order to create data points. I am on Excel 2010 and I tried quite a few times...

Hello, My boss wants to see 3 stacked bars (with two metrics on each) for each month. I've played with the stacked bar chart and I've only been able to show all 6 metrics on one single bar. Is there some creative way to have three stacked bars for each month on a graph?? Please see example...

Hi, I need to use the IF formula to return the name of a cell that has a certain rank. I have ten cells with text words in them and each has a rank 1-10. And I need the names to populate in a column in order of rank. I can't figure out how to write this in the syntax. I've uploaded the file...

Hi, A tutorial on how to highlight the best month in a trend chart was recently sent and I have some questions on how I would apply this to my work. For my type of analysis, the lowest monthly values are the ones I would need to highlight in the chart. Looking at the downloaded example...

I need an Excel function that will calculate a moving average on monthly data for time periods of 3,6,12 & 36 months. The average for each of these time periods must not include the current month's data. It must only include the prior 3,6,12 & 36 month data. I've been struggling with the...