I have a range of values spread across in rows from A to AA. some cells are empty and some are not. and the cells that are not empty have unordered values. Is there a way to calculate the range between the first cell and last cell which have values? I hope explanation is good. I can do this with extra tables/ cells etc. but would it be possible to do this with a tricky formula? please. thanks. I posted an example image. In the first I would like to know the range between cell Y and cell E. and in the second row, it is between cell x and cell B.
Last edited: