Excel Question

Imposter

Ok this seems like it should be simple to do but I can't get it to work!

I have an excel spreadsheet. It has a column of numbers. I want to get the last number in that column and use that number in a different cell. The column is not a fixed length. So how do I do it?

I can get the index of the last element using COUNT(C2: C100) which returns the number of columns that have values in them. As there is always a value in this column I use this number and add 1. Thus giving me the column index. But how do I use that value (assume it's in a cell X1) in the reference to the other cell. Something like '=C(X1)' (Where X1 is say 17 and '=C17' would work) but obviously that doesn't work .

sidekick

Perhaps a wild shot but have you tried using the INDIRECT function?

Returns the reference specified by a text string. References are immediately evaluated to display their contents. Use INDIRECT when you want to change the reference to a cell within a formula without changing the formula itself.

Imposter

Thank you. That does the trick nicely.