Mar 20 2019 02:02 AM
Mar 20 2019 02:02 AM
Dear Experts,
Help please! Thank you in advance.
In the spreadsheet attached:
Row 1 notes different tram numbers
Column A notes distance travelled.
Columns B onwards has "1"s in rows noting where failures have occurred at corresponding distances, as per Column A.
I want to calculate the deltas only between the "1"s in each column. For example, in Column B there are four "1"s. There should be 3 corresponding deltas. Is there a way to do this, using arrays perhaps?
Many thanks.
Mar 20 2019 02:09 AM
Mar 20 2019 02:09 AM
For clarity, I should add the deltas must be of the distances in Column A.