Return a list of cell values based on criteria in other columns

Hi,

I am currently using COUNTIFS to count the number of entries in a column which match criteria in 2 or 3 other columns. Is it possible to separately also return a list of the values in the cells which match all these criteria?

I hope this makes sense.
Mike

Hello
Yes that is possible but I need to see your workbook....
So please upload the workbook or a sample workbook to get a better understanding of your problem....
You can upload by clicking on Go Advanced Button below and then clicking on the paper clip icon...

Good Morning,

Thanks for initial comments. Attached is a sample workbook based on the one I inherited and am trying to make sense of.

For example, on the KPI Analysis tab, in Cell F11, it is showing a total of 14 requests which were within target, based on the date range at the top of the tab. I would like to be able to have a separate tab which would list the Web Request Numbers relating to these 14 requests, taken from Column C on the Client 1 tab.

Obviously this list would change as the date range changes, and I would then need to duplicate it for all the clients and all the KPI results.

Any help appreciated!

Mike

Thank you for your help, exactly what I needed!

Mike

Just one more thing...

I adapted your array to suit values over 7 without any problem, but when I try to put a range in, I get a #num.

=IF(ROWS($3:3)>'KPI Analysis'!$G$11,"",INDEX('Client 1'!$C$2:$C$39,SMALL(IF('Client 1'!$A$2:$A$39="Y",IF(AND('Client 1'!$E$2:$E$39>=4,'Client 1'!$E$2:$E$39<=7),ROW('Client 1'!$A$2:$A$39)-MIN(ROW('Client 1'!$A$2:$A$39))+1)),ROWS($3:3))))

Thanks,

I was trying to set it up to give a list of Web Request Numbers which would appear in the Amber column on the KPI Analysis sheet, eg cell G11, between 4 and 7 days. (In this example the result would be 0).

True, but I am adapting the formula for each field on the KPI Analysis tab. When I move on to KPI 2, cells G30 and G36 both have results to list.

Thanks again.

Yes, I have adapted your first solution to work for the other areas of the sheet, where the search term is either less than or greater than.
It was only the Amber region, column G, where I am looking at a range, where I had the issue. Your solution in post #9 worked perfectly.

Thank you again for your help.
Mike