How to get last numerical value from column A only?
86 Ansichten (letzte 30 Tage)
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
Weitere Antworten (1)
Steven Lord am 13 Mär. 2020
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.