View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BKO BKO is offline
external usenet poster
 
Posts: 15
Default 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.