Mar 18 2018
08:37 AM
- last edited on
Jul 25 2018
11:23 AM
by
TechCommunityAP
Mar 18 2018
08:37 AM
- last edited on
Jul 25 2018
11:23 AM
by
TechCommunityAP
Hello -
I want to count number of blank cells till last non empty cell in a column but could not figure out how to do this, can you please help?
When I use Countblank formula, it takes an argument as range which should be known in the beginning itself which is a problem because then it becomes manual work to mention the range everytime as my column data (number of rows) can change many times, and different columns can have different number of rows.
Is there a way to mention end limit of the range as row number of last non empty cell in that column?
Thank you in advance,
Saurabh Khanna.
Dec 05 2018 02:40 AM
it is because you are probably using Excel 2010 which does not have IFNA function.
SO i replaced is with IF ISNA
like this
it is again with Control shift enter. see attached
=IF(ISNA(COUNTBLANK(A3:INDEX(A3:A1048576,MATCH(2,1/(A3:A1048576<>""))))),0,COUNTBLANK(A3:INDEX(A3:A1048576,MATCH(2,1/(A3:A1048576<>"")))))
Dec 05 2018 02:48 PM
You may change IFNA on IFERROR
Dec 06 2018 10:49 PM
Dec 06 2018 10:49 PM