Forum Discussion
One particular excel cell formula not auto-calculating
Hi all, First time on the community, so both excited and a bit nervous that I am putting this in the right way / place. Anyway, I have done a search for this question before, but I am not able t...
The comment by mathetes triggered my curiosity. How would you lookup the value of the last cell in a column? Created a small example as can be seen in the attached workbook. Deleted some cells to break the sequence and it works as planned. Add cells towards the bottom in column B and A1 updates perfectly. The formula is:
=INDEX(B:B,AGGREGATE(14,6,(ROW(B:B)*NOT(ISBLANK(B:B))),1),1)
Perhaps this solves your problem. If not, please upload your workbook/formula as mathetes suggested.