how i select cell upto specific text in column

[kmahato]

column 1

xyz

abc

gjdsh

hdkj

dskjha

good

oiad

ddd

[#2]

@kmahato   how i select upto " good " from column 1

[#3]

@kmahato 

Do you mean manual selection or formula which returns the range from first cell to specific one?