Excel Help

[brandonhop33]

Is there a formula to get the last number in a column?

I have some info about teams streaks and I want to be able to get the current streak in a cell at the top.

 

[goodcall]

not exactly sure what you mean, but you can get the last character in a certain cell (A1 here) by typing:

=right(A1,1)

to convert it to a usable number, wrap it in value()

=value(right(A1,1))

 

[brandonhop33]

Thanks but I guess I need to explain myself better.

How do I get the last number in this column

Column A
1
2
3
0
1
2
0
1
2
3
4
5


Tomorrow it could be 6 or 0, how do I have a cell up top always having hte last number?