How to code if false, check next row until true condition meet?

[ahuynh]

Hi all, I need help
I have a list of roads in tab Rd List. I want to transfer this list into sheet Alpha which sort the road list in alphabetical order.
For the roads start with letter "A", I use code =IF(LEFT('Rd List'!E3,1)="A",'Rd List'!E3,offset) and stuck here. Can anyone tell me how to code if the road not start with letter "A" the move to next row until true condition meet, no blank.
The following attachment is my excel file.
Thanks

 

[pecoflyer]

With O365,the FILTER function will do this for you =FILTER('Rd List'!$E$3:$K$444;LEFT('Rd List'!$E$3:$E$444;1)="a")
Before applying it make sure all destination cells are empty, your "empty" cells are nor as empty as they seem

 

[ahuynh]

With O365,the FILTER function will do this for you =FILTER('Rd List'!$E$3:$K$444;LEFT('Rd List'!$E$3:$E$444;1)="a")
Before applying it make sure all destination cells are empty, your "empty" cells are nor as empty as they seem

Thanks bro, the Filer function works great. by the way, if I want to filter the roads begin with number such as 1st Street, 2nd Street etc., should I replace "A" by "isnumber"?

 

[pecoflyer]

Glad it helped, it is the first time I use this function.
BTW, as we are not acquainted, I would appreciate it if you restrained from calling me "bro".
This being said, check https://www.ablebits.com/office-addins-blog/2020/06/17/excel-filter-function/ for more information on the FILTER function

 

[ahuynh]

BTW, as we are not acquainted, I would appreciate it if you restrained from calling me "bro".

I deeply apologize for making you feel offensive. I didn't mean anything to offend you.