C
carlee
I am trying to use CountA to count non blank cells. But all the cells have
embedded metadata (user name and author) in it and therefore the countA will
return total number of rows in the range. How could I could get rid of the
embedded data?.
Please see example
B C E F I J K
1 S R* R S*
2 S R* R S*
3 S S S* S
4 S S S* S
5 S* S* S* S*
6 S* S* S* S*
7 S* S* R* S*
8 S* S* R* S*
9 S* S* R* S*
10 S* S* S* S*
11 S* S* S* S*
12 I* R* R* S*
13 R* R* R* S*
14 S S S* S
15 S
16 S S* S
17 S* S* R* S*
18 S
19 S S* S
20 S* S* R* S*
21 S S S* S
22 S* S* S S*
23 S* S* S S*
24 S S S* S
CountA: 24 24 24 25 24 24 24
embedded metadata (user name and author) in it and therefore the countA will
return total number of rows in the range. How could I could get rid of the
embedded data?.
Please see example
B C E F I J K
1 S R* R S*
2 S R* R S*
3 S S S* S
4 S S S* S
5 S* S* S* S*
6 S* S* S* S*
7 S* S* R* S*
8 S* S* R* S*
9 S* S* R* S*
10 S* S* S* S*
11 S* S* S* S*
12 I* R* R* S*
13 R* R* R* S*
14 S S S* S
15 S
16 S S* S
17 S* S* R* S*
18 S
19 S S* S
20 S* S* R* S*
21 S S S* S
22 S* S* S S*
23 S* S* S S*
24 S S S* S
CountA: 24 24 24 25 24 24 24