In the book, Excel 2000 formulas, by Walkenbach. I've been trying to use the returning nonblank cells from a range formula on page 354. Even when I use the sample file, I have not been able to reproduce the results from the sample. At best, I get the top number from the source column repeated.
I must be missing a procedure somewhere. So If someone that has used this formula, can explain the step by step procedure, many thanks by me.
I've looked in the search for prior posts for info on this, as well as other websites and books. Just too much missing information for me to set this up properly. And I don't understand the complex formula, other than changing the name of the source array.
I must be missing a procedure somewhere. So If someone that has used this formula, can explain the step by step procedure, many thanks by me.
I've looked in the search for prior posts for info on this, as well as other websites and books. Just too much missing information for me to set this up properly. And I don't understand the complex formula, other than changing the name of the source array.