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

    How to remove null values from an array that is created by an array formula.

    Hi! I tried to find a descriptive title for a problem that has been nagging me for a while. If I use an array formula of the type If I have 2 columns a and B with A B 1 X 2 X 3 Z 4 Y 5 X and I want to make a table with X,Y,Z with the results being the...
  2. Q

    use indirect to refer to named range in an excel formula.

    Good evening! I have been trying to understand why the following formula does not work as I have used it successfully for named ranges, and it is the only way I know to refer to a range name where teh name is in another cell. in A, B, C, I have ranges that are dynamic and are called AA, BB...
Back
Top