Hi,

You need to look at Advanced Filtering in Excel's help. For me to walk you
through it would be cumbersome and confusing. But I just tried it and it
took me a couple of minutes to set up. If I understand your requirement I
got the results you were looking for.

If this helps, please press Yes,
John

"Modawg" wrote:

Hi,

I am trying to pull information from an array that contain these
information. I need to be able to pull the information if the status is
'OPEN' along with the module name and start date. However, I can't do a sort
because these modules are in separate projects which are right on top of each
other, so to sort would throw everything else off. I tried using vlookup in
array form, which kind of worked but it lagged the entire worksheet to almost
unbearable lengths and it did not update automatically. Is there some vba
code or some other way to do it? Pivot tables are also very difficult to use
in this case because there are many hidden columns of calculations between
each requirement I need to pull out

Status Module Start Date
Open B 8/12
Close A 8/15
Open C 8/11
Open B 8/12

Thanks