Pulling rows above and below a certain column value

In my dataset I am trying to create a list of rows adjacent (both above and below) the row where a columns cells has a specific value i.e.

C1 C2 C3 C4

13 10 -4 12

12 14 -3 15

14 34 0 18

15 12 1 12

12 13 5 21

From this dataset I would want to get the row with 0 in column C3, and then the two adjacent rows (the row before and after)

So it should look like:

C1 C2 C3 C4

12 14 -3 15

14 34 0 18

15 12 1 12

I need to do this for anytime I have a 0 in column C3, any ideas?

Predictive Analysis

Accepted answers

patrick_digan

@JWO221 I would use a multi-row formula tool to flag the fields you want, and then filter them.

Community 2021-06-09.yxmd

All comments

patrick_digan

@JWO221 I would use a multi-row formula tool to flag the fields you want, and then filter them.

Community 2021-06-09.yxmd

JWO221

Yes, worked perfectly! Thank you!

GIS_User01

Hi! I have a very similar situation. Only difference is that I am looking for a value above 15 (instead of 0) and I am wanting to flag 20 rows prior to the occurrence and 20 rows after the occurrence (instead of 1 row prior and 1 row after). How would I change my syntax to achieve this?

Christina_H

@GIS_User01 It's possible to use the same method for your situation, but you would need to check 41 rows every time rather than 3. Here's what I would do instead:

If you want to flag the rows rather than filter you just need to change the last few tools, formula and summarize rather than filter and unique would do it.

Multi rows.yxmd

jourdan_17

If I'm looking for a row containing a string what would the formula look like?

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335