S
Steven Stadelhofer
I copy pasted an Access dynaset (e.g., results of a
crosstab query) into an Excel spreadsheet. I tried to
use the function =counta(a4:z4) to count the number of
entries (nonblank) in row 4. But the result is giving me
26 because it is counting blank cells. Is there a way to
count the entries without counting the blanks or a way to
easily reformat or change the blank cells so the formula
will not count the blanks. I do not want to have to
manually delete every blank cell in a table 26 columns by
2000 rows.
Thank you,
Steve
crosstab query) into an Excel spreadsheet. I tried to
use the function =counta(a4:z4) to count the number of
entries (nonblank) in row 4. But the result is giving me
26 because it is counting blank cells. Is there a way to
count the entries without counting the blanks or a way to
easily reformat or change the blank cells so the formula
will not count the blanks. I do not want to have to
manually delete every blank cell in a table 26 columns by
2000 rows.
Thank you,
Steve