How to pick rows after certain word

[kauser]

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

[alexnajm · Accepted solution]

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)

[jrlindem · Accepted solution]

@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.