Hello all,
Finding the last populated cell in a column seems to be a fairly popular old post, but all of the solutions proposed have tended to rely on VB, which I am hesitant to use because I do not know (a) how to implement VB Script and (b) because this spreadsheet will be populated to hundreds of computers across the world which have highly variable configurations… However, my problem is slightly different, so I thought it worth posting.
I have a statistics table at the bottom of a large dataset. This dataset will vary in size, with users adding and subtracting data as they use it. In order for my formulae to work properly, I need to know where the last row of data is. So what I need is this: I need a method for Excel to ‘count back’ from the top of the statistics, up through the two or three blank rows and return how many rows above the last line of data sits. If it makes any difference, there will never be more than, say, 1000 rows in this given spreadsheet and the statistics table will always remain the same shape/size. I just want to be able to account for the user’s tendency to leave between 1 and 3 empty rows at the end of the dataset.
In the same vein, I would be quite happy to have a system that would count down through a column and return the first empty cell… That would do the trick to..
Grateful for any suggestions.
Best,
Max
Finding the last populated cell in a column seems to be a fairly popular old post, but all of the solutions proposed have tended to rely on VB, which I am hesitant to use because I do not know (a) how to implement VB Script and (b) because this spreadsheet will be populated to hundreds of computers across the world which have highly variable configurations… However, my problem is slightly different, so I thought it worth posting.
I have a statistics table at the bottom of a large dataset. This dataset will vary in size, with users adding and subtracting data as they use it. In order for my formulae to work properly, I need to know where the last row of data is. So what I need is this: I need a method for Excel to ‘count back’ from the top of the statistics, up through the two or three blank rows and return how many rows above the last line of data sits. If it makes any difference, there will never be more than, say, 1000 rows in this given spreadsheet and the statistics table will always remain the same shape/size. I just want to be able to account for the user’s tendency to leave between 1 and 3 empty rows at the end of the dataset.
In the same vein, I would be quite happy to have a system that would count down through a column and return the first empty cell… That would do the trick to..
Grateful for any suggestions.
Best,
Max
