I would like to do this with a formula instead of VBA if possible. I have a single column of data that is being calculated. I would like to find the last cell that has a value in it. The problem is that every other cell as you go down the column will be blank, even though there is a formula in each cell. It would look kind of like this:
1 Value
2
3 Value
4
5 Value
6
7 Value
8
9
10
So for the range of A1 to A10, I need a formula to tell me that A7 is the last one with a value. As you can see I can't just look for the first blank because that would be A2.
Any help would be greatly appreciated.
Thanks,
Dave
1 Value
2
3 Value
4
5 Value
6
7 Value
8
9
10
So for the range of A1 to A10, I need a formula to tell me that A7 is the last one with a value. As you can see I can't just look for the first blank because that would be A2.
Any help would be greatly appreciated.
Thanks,
Dave