Share via

The value is variate and going down to 0 in the middle, and started going up again. Is there any way to link these data to the other sheet? but only start from where the suction is 0.

Anonymous
2025-03-12T04:13:53+00:00
Timestamp Suction (kPa)
2/9/2024 14:06 4.3087003
2/9/2024 14:11 3.5827676
2/9/2024 14:16 2.4906885
2/9/2024 14:21 1.563775
2/9/2024 14:26 1.4863388
2/9/2024 14:35 0
2/9/2024 14:40 0.8869525
2/9/2024 14:45 0.4971667
2/9/2024 14:50 1.2250903
2/9/2024 14:55 2.24681
2/9/2024 15:00 3.2680045
2/9/2024 15:05 4.5603232
2/9/2024 15:10 6.0352759
2/9/2024 15:15 6.9291797
Microsoft 365 and Office | Excel | For education | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2025-03-12T05:44:04+00:00

    =FILTER(A2:B15,A2:A15>=INDEX(A2:A15,MATCH(0,B2:B15,0)))

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-03-13T06:22:55+00:00

    Fill formula down
    =IFERROR(INDEX($A$1:$A$15,MATCH(0,$B$2:$B$15,0)+ROW(A1)),"")

    =IFERROR(INDEX($B$1:$B$15,MATCH(0,$B$2:$B$15,0)+ROW(A1)),"")

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2025-03-12T14:19:15+00:00

    Thank you, it works!

    But do you have alternative method? other than using FILTER function. Because it's unavailable on 2019 version

    0 comments