MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How do I recursively find non-blank values in a column?


Posted by Glen on July 12, 1999 1:35 PM

I am trying to walk through a spreadsheet column and do things based on values in the column. In other words. It's easy to find blank values, but how do I find non-blank values if the values are non-standard (i.e., anything can be in the cell)?

This is really finding the values you would find using the COUNTA() function.


Posted by George on July 22, 1999 8:05 PM

Glen - Two things come to mind:
1.)Auto Filter has a drop down box that will select all non blank cells

2.)The isblank argument might work for what you are trying to do.

Posted by Ivan Moala on July 28, 1999 1:37 AM


Glen
you have probably answered it as you say you can
easily find blank cells. If this is so then the other cells must be Non Blank. from there it is
a matter of setting the criteria for what you want
to evaluate using If Then and/or case select to do
the fuction of evaluating what it is you want.


hope this is of further assistance


Ivan