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

    Excel Cartoon

    I always like when there is an Excel cartoon. A little levity for the day! http://www.dilbert.com/strips/
  2. S

    SumProduct Issue

    Why can i not seem to get the hang of it :) the condition checks itself as True before comparing with data. =SUMPRODUCT((B7:B10)*((CELL("format",C7:C10)="C2")*1)) this gives me the sum of all data not the ones where the currency format = "C2" (us dollars) What is the fix to my formula...
  3. S

    SumProduct to Count Non-Printable Characters below Code(32)

    Hi All, Luke M gave me a better and working formula to count quotes used in a range =SUMPRODUCT((ISNUMBER(FIND("""",A1:A4)))*ROW(A1:A4)) Is there anyway to make this look for all special characters below Char(32) without VBA? Basically looking to see and report if the data that a client...
  4. S

    SumProduct to get Row and Column where Text has Special Character

    I love sumproduct but have a hard time in implementation. For instance, am trying to find the row and column for any set of data that contains a special character like a single quote or double quote other invalid characters. If i put text in a1:a4 with a4 having a single quote in the text...
  5. S

    Format Cell

    Hi all, I have a cell that has data validation set to be = a list of values like this: "01008, English as a Second Language" When a user picks a value, i want the Cell to only display 01008 with formats. I want to do this because the file will be saved as Tab Delimited which should only...
  6. S

    Min with =NA() in Range = #N/A

    Hi All, I have a dynamic chart range for 2 series. The chart range 1 has data that goes back 3 years. Chart range 2 only has data for the last year. I allow users to pick how far back they want to see the chart 1 month to 36 months. So if they choose more than a years worth of data i have...
  7. S

    Formula Reference when inserting a Insert Row in Table

    Hi All, I have a chart that is based off of a table. In the table i have formulas that reference the row above to determine the starting position for this series. However, I would like the Users to have the ability to insert a row so that they can insert a series anywhere they want. I was...
  8. S

    Combine Column and Stacked Column Chart Both on Primary Axis

    Hi All, All i have read is that you cannot combine a Column and a Stacked Column on the same Excel Chart. However, I have found an example of a chart that allows this and can't figure out how they do this. At this link, if you select the "Ist" series and look at the chart type it is a...
Back
Top