How to pick rows after certain word

Hello,

i need to keep few specific rows after certain word from the data sheet. how can i pick those certain rows. based on these following data how can i keep all rows after Type Green. (please note Green is now in 2nd rows but this order can be change month over month so Rows# can't work and i need to do this sorted based on Type which is green in this example)

Input data

Type	Item	Exp	Income
YELLOW	A	50	100
GREEN	B	60	220
RED	C	40	540
BLACK	D	20	620

Expected Output Data

Type	Item	Exp	Income
RED	C	40	540
BLACK	D	20	620

Developer

Developer Tools

Accepted answers

alexnajm

You can use a Multi-Row formula tool to create a column to filter on - something like IF [Row-1:Type]="Green" THEN 1 ELSE [Row-1:New Field] ENDIF (make sure you name the "new column" part to whatever your column will be called)

Screenshot 2025-11-10 151718.png

jrlindem

@alexnajm 's approach is the right and most efficient solution for your need.

That said, if you're interested in a non-Multi-Row-Formula solution, you could also do it this way:

This is leveraging Row Numbers to grab only those that are greater than the row number of the "GREEN" tag.

Cheers, -Jay

All comments

alexnajm

Screenshot 2025-11-10 151718.png

jrlindem

@alexnajm 's approach is the right and most efficient solution for your need.

That said, if you're interested in a non-Multi-Row-Formula solution, you could also do it this way:

This is leveraging Row Numbers to grab only those that are greater than the row number of the "GREEN" tag.

Cheers, -Jay

kauser

@alexnajm Thanks for your help. can you help me how to pick certain rows based on certain words.

Input Data

Type	Item	Exp	Income
YELLOW	A	50	100
GREEN	B	60	220
RED	C	40	540
BLACK	D	20	620
WHITE	E	56	260
ORANGE	F	65	584
YELLOW	G	70	600
BLUE	Y	80	400

Output Data-

Type	Item	Exp	Income
GREEN	B	60	220
RED	C	40	540
BLACK	D	20	620
WHITE	E	56	260
ORANGE	F	65	584

jrlindem

How would you be identifying which words are relevant? Different every time or are they going to be a known "crosswalk" list?

kauser

@jrlindem in my example word "Yellow" will remail same as you mentioned "Crosswalk"

alexnajm

@kauser to add onto @jrlindem 's point, this is now a different question than the original ask. Please repost this as a different question with more explanation - I am going to close this one since both responses provide a solution.

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335