Hello
I wish to count blank cells, presumably using =COUNTBLANK but I wish to only count the blanks prior to the final column with a value in.
So for example
Row 2's last value is in column AO, so I wish to count the number of blanks between A and AO... despite there being further blanks after AO... I do not wish for these to be included.
Row 3's last value is in AE... so similarly I only wish for the blanks prior to AE to be counted.
This is a 2000+ row spreadsheet and each row may have a different last value point...
Thanks in advance
I wish to count blank cells, presumably using =COUNTBLANK but I wish to only count the blanks prior to the final column with a value in.
So for example
Row 2's last value is in column AO, so I wish to count the number of blanks between A and AO... despite there being further blanks after AO... I do not wish for these to be included.
Row 3's last value is in AE... so similarly I only wish for the blanks prior to AE to be counted.
This is a 2000+ row spreadsheet and each row may have a different last value point...
Thanks in advance