skip to next cell if no value is found

[AirCav]

I have two columns one with numbers and the other names. Based on a criteria
that is met, I want to display the names of those who meet the criteria in
another column sorted and skipping the cells that did not meet the criteria.