Try Data | Filter from the menu


"Tom" wrote:

I have 2 columns (names and values). The values are either 0 or 1. I'm
looking for a formula that would give me the list (or array) of names that
have a given value. I have been trying with Index/Match but coudn't get more
than 1 match. thanks.