Home

Calculations across multiple columns based on non-blanks

Deleted
Not applicable

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.

1 Reply

For clarity, I should add the deltas must be of the distances in Column A.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies