Need help in referencing

[a580688]

Hi All,

This is a bit tough for me so seeking out your help. I have the following data on sheet 3

[TABLE="width: 330"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Target Date[/TD]
[TD]Completion Date[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]May 23, 2014[/TD]
[TD]May 21, 2014[/TD]
[TD]Closed[/TD]
[/TR]
[TR]
[TD]May 16, 2014[/TD]
[TD]May 16, 2014[/TD]
[TD]Closed[/TD]
[/TR]
[TR]
[TD]June 13, 2014[/TD]
[TD]June 2, 2014[/TD]
[TD]Closed[/TD]
[/TR]
[TR]
[TD]June 13, 2014[/TD]
[TD]June 2, 2014[/TD]
[TD]Closed[/TD]
[/TR]
[TR]
[TD]May 20, 2014[/TD]
[TD]May 20, 2014[/TD]
[TD]Closed[/TD]
[/TR]
[TR]
[TD]July 8, 2014[/TD]
[TD][/TD]
[TD]In Progress[/TD]
[/TR]
[TR]
[TD]May 30, 2014[/TD]
[TD]May 30, 2014[/TD]
[TD]Closed[/TD]
[/TR]
[TR]
[TD]August 15, 2014[/TD]
[TD][/TD]
[TD]In Progress[/TD]
[/TR]
[TR]
[TD]August 15, 2014[/TD]
[TD]July 10, 2014[/TD]
[TD]Closed[/TD]
[/TR]
[TR]
[TD]September 15, 2014[/TD]
[TD] [/TD]
[TD]In Progress[/TD]
[/TR]
</tbody>[/TABLE]

I have at least 100 rows of this data. I want to show this data on another worksheet where it will pick up the date only where the Status is In Progress. It will not show me the other dates. I might have done this using a pivot table. But i want to reference this using a formula. Please help.

 

[a580688]

Thank You so much Peter, Problem Resolved. By the way I am using Excel 2010.