ExcelBanter - Multiple results

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Multiple results (https://www.excelbanter.com/excel-worksheet-functions/146299-multiple-results.html)

BKO

Multiple results

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

--
There are only 10 types of people in the world:
Those who understand binary and those who don''''t.

Gary''s Student

Multiple results

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
--
Gary''s Student - gsnu200728

All times are GMT +1. The time now is 10:41 PM.