Search results

Thank you so much for your quick response Hui! That was very helpful :) ~ greykitten

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 r2c2, Wow, this is amazing work! It works perfectly except for two things. 1) I also have data in columns N - AS. I can't figure out what to modify in the macro to copy data found in columns N - AS in the same way that columns A - L are copied. Would that be done by changing the range...

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

Hi John, Do you know how I could adjust that formula to count the number of times that those three values appear that column? I tried this =COUNTIFS($A$2:$A$23769,{"EWS Duplicate Detection";"EWS/ANF";"EWS/RNF"},$J$2:$J$23769,"Closed") but it produced a small number nowhere near the real...

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

Thanks so much Luke! :)

Thanks Narayan. That format produces "$88.05K" when I try it. What would I change the custom format to since I just want "$88K"? What if I wanted "$88.1K"? I tried adjusting the custom format but I couldn't get it down to just "$88K". Thanks again! GK

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

By the way, this summed the entire column which was incorrect. It didn't achieve the goal of filtering by types B and E for items sold from 0 to 30 days.

Thank you eibi! :)

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

Wow, Luke, thank you so much! You are awesome :) greykitten

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

Thank you SO much Luke!!

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