Hi Sir,
I have a challenging problem: to count the number of valid cells (i.e. non-error) below a specific cell whose name is known, but the address of this cell is not known. I attached the example here. So the task is to 1) find the address of the cell with name 'Language', 2) count the number of non-error cells below the cell 'Language' and up to the 1000th row.
To make it more interesting, please put this answer in a separate file (linked to the example file).
Thanks for your great help.
Bookmarks