I have a list of values in $A:$A and a corresponding list of values in let's say $B:$B. At another sheet I would like to get a list of all those values which meet a certain criteria...something like countif..
For example in a and in b I have the following:
in sheet2 I want to have now as a result in a column A called FC the following:
and in the column B called HC the following: