Multiple cells containing multiple specific text

[Gwill1983]

Hi all,

I am trying to add a summary screen to one of my workbooks to make it a little clearer to those who assess the data, but don't enter it.

My tab for the raw data is called 'Ongoing' and the tab that I am trying to return the data to is called 'Summary'

In essence, I am trying to get a table to the summary tab to show all entries in the ongoing tab that have been requested, but not confirmed.

So... I want to return cells in column D if the cell in column I says Yes but the cell in column K says No.

Any idea of the formula that I need, and the best way to set this as the number of entries returned will be constantly fluctuating!

Any help will be welcomed.

Thanks

Chris

 

[mole999]

name your data in a range, then used the named range in a pivot table