Search results

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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