How to get last numerical value from column A only?

I have a CSV, I want to get the first and last value from column A.

I found the first value, which is: First = P(1);

i cant seem to get the last value, I tried: Last = P(end);

I get the last value from Column E instead of A

Answer 1

[Fangjun Jiang]

P(1,end) would be it.

[isamh]

i tried that as well but it's not right

[isamh]

nevermind got it, it's: P(end,1);

[Fangjun Jiang]

:) You got it right

Answer 2

[Steven Lord]

When you index into an array with just one index, you're using a technique called linear indexing. This basically treats your array like it was one long vector, as described in the "Indexing with a Single Index" section on this documentation page. You want to perform subscripted indexing, as Fangjun Jiang suggested and as the "Indexing with Element Positions" section on that documentation page states. That section mentions the end keyword will will be very useful in keeping your code generalized. This avoids hard-coding in the size of a particular array, letting your code automatically handle different sized inputs without needing modification.