I have a column of data, including cells with blanks. I am trying to count the blanks but only want to go to the last value in the column instead of counting to the end of the spreadsheet. My formula right now is COUNTBLANK(A1:A101) and this works fine but next month I am going to get more values and the column will go down farther than A101 but I don't want to COUNTBLANKS(A:A) as this will count all the way to the end. I've used =LOOKUP(9.99999999999999E+307, A1:A9) to find the last value but what I think I really want is the cell reference of this last value so I can put it in my COUNTBLANK(A1:"cell reference function"&LOOKUP(9.99999999999999E+307, A1:A9)) however I don't know how to return the cell reference. Any help would be appreciated.
Thanks, new forum member.
Bookmarks