• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. K

    Create a dynamic range name without offset that includes rows inserted in betwee

    Hello, I have the following set of data: 1 AGENCIES 2 German Agency 1 3 German Agency 2 4 German Agency 3 .. 10 Total Germany 11 Swiss Agency 1 12 Swiss Agency 2 ... 15 Total Switzerland ETC In order to create a list in another sheet that allows me to choose any from the German...
  2. K

    HELP! Combine Large and Sum

    Im trying to get the n largest value after a sum. For example, I have: Jan Feb Mar Apr Jun Jul ... Country 1 23 31 11 43 18 9 Country 2 40 55 21 18 7 24 Country 3 14 31 45 6 29 14 ... Before I have always used lookup first and then a combination of Sum and Offset to find...
  3. K

    How to find country first, then sum several values for this country.

    I have a series of countries in cells A1:A100, each country has production for each month in columns B:M. I need a formula which sums production for a certain country (cell AA1) acumulated year to date, according to current month (1 to 12 in cell AA2). How can I do it?
  4. K

    Make a Named Range dynamic without $

    Hello, Im trying to create a dynamic named range avoiding $, but it doesnt work. The range is in another sheet, how can I make it so that when I add a row it includes it in the range making it 1 row bigger? Thank you!
  5. K

    How can I define a name for the same range in several worksheets?

    Hello! I've been subscribed to your newsletter for a few months now and I think is awesome! thank you so much for your wisdom :-) It has really helped me impress some bosses around here... I need to define the same name for the same range (A2:AF12) in 5 diferent sheets. How can I do that? Im...
Back
Top