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

Recent content by questio

  1. Q

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

    Oops, yes! I am so grateful for all the input as i am now getting to use more and more array formulas though they are a bit slower for large quantity of data, but are great fun. the forum here gives such "kicks" in to trial out new approaches. As I read in some other posts, yes, it is very...
  2. Q

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

    Thanks! It seems that you definitely need to use the formula "SMALL" to gather the first value bigger that "0" which means that the results will be sorted! :) Good gymnastic of teh brain! Danièle
  3. Q

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

    Hi Hui! I just wanted the values listed. The sorting was the only way I could think of to get rid of the zeros. The only "must" was to get rid of what is not needed,i.e. the zeros! :) Danièle
  4. Q

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

    Hi Hui! I just wanted the values listed. The sorting was the only way I could think of to get rid of the zeros. The only "must" was to get rid of what is not needed,i.e. the zeros! :) Danièle
  5. Q

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

    Hi Hui! All I would like is to be able to line up the results of the array in a column so that only the real values are lined up rather than all the values (real values and False or null values) of the array. I want the cells that should be filled from entries from the array to look like the...
  6. Q

    What is this type of char called? And how do I do it?

    I think they are the Marimekko charts. Check Jon Peltier site as he has an add in for those charts. http://peltiertech.com/Utility/MarimekkoUtility.html
  7. Q

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

    Thanks Hui and Sajan, I am still not clear I think in describing what I am looking for though both replies opened new view for me. The formula I wrote was to be able to list in each column the samples in column A that had resulted in result X, Y or Z in column. There are no other results...
  8. Q

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

    Thanks Narayan! I am really sorry to have been so unclear. I also apologise for sending the file with the dots as those were only placed to show that the values can go further down, but I do not use them normally. I realise how confusing my question and my file was! I was not clear when I said...
  9. Q

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

    Thanks Hui! That will allow me to follow all everywhere rather than cram my brains with very strange passwords... Thanks!
  10. Q

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

    I realised Luke had taken the time to help loading files, and i had missed it! I hope I managed OK, This shoudl be the link to the sample workbook. https://www.dropbox.com/sh/i5i5m45dt4zghdv/pzMgjGDPP5/array%20reduction.xlsm Thank you! Danièle
  11. 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...
  12. Q

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

    THANK YOU! Sorry for the delay in replying! I could get the answer from the forum at my work place but could not reply as I forgot my password! It was on my computer at home which had a few glitches but as you can see is back working. First and foremost, Thanks! Hui, your answer "hung up"...
  13. Q

    Thanks to HUI !

    Thanks Hui for such precision in every explanation and taking time to even think out all possible pitfalls in such a careful manner. Thanks to all contributors too who day in day out come to teh resue in a very friendly site! You do contribute enormously to our excel addiction.... :) Danièle
  14. Q

    Hello .. Introduce yourself

    I am religiously following the Chandoo.org site and usually can get pretty much most answers from this site! I have been following since the "Dilbert" days and am awed still (and will always) by all the help, the patience to help all of us lost souls. Thanks! Danièle
  15. 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