Multiple results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top