Displaying the rows counted in a countifs formula

[Bee501972]

Hi

I have created a formula using countifs. I now want to display the actual data in the rows that have been counted. Please help to suggest the function that I can use to display the actual rows in excel.

Thanks

[#2]

If you have office 365, in some cases, the function: Filter () can do exactly what you are looking for.

In this example, we have an array in Column A from numbers 1 to 36 and we have a condition greater than 10. 

So, we use the formula Filter( array , array > 10) and now it returns the values.

The filter function can accept more than one condition, for example:

Filter ( array , (array > 10) * ( array < 20) )

@Bee501972  

[#3]

thank you @alannavarro 

I have tried filter with the following formula and I keep getting an error saying I have too many arguments

Filter(sheet!$I:$I,sheet2!$B29,INDIRECT(sheet2!A29),">="&Sheet2!Q2)