Multiple results

B

BKO

Hi everybody,

How can I create a (new) sheet showing ALL results from a datasheet meeting
a criteria(cell value),

I tried INDEX/MATCH, but got only the first found,

It should be possible somehow, But I have no clue

Thanx in advance

BTW: The datasheet is not sorted
 
G

Gary''s Student

You are correct about MATCH and VLOOKUP usually finding only the first
occurance.

The easiest thing to do is to use AutoFilter to display only the rows
meeting your criteria. Then copy/paste the visible rows into a new sheet
 
Top