Archive of Mr Excel Message Board
Back to Data in Excel archive index
Back to archive home
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.
Re: How do I recursively find non-blank values in a column?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.
Re: How do I recursively find non-blank values in a column?Posted by Ivan Moala on July 28, 1999 1:37 AM
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
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.