Search function...Can anybody help

[sunita_shaw]

How to search for all the start dates for Phase="Performance Testing"

Phase Start date

System Requirements Study 11-Feb-06
System testing 13-Mar-06
Test Planning 18-Mar-06
Regression Testing 07-Mar-06
Performance Testing 01-Mar-06
Performance Testing 01-Apr-06
System testing 18-Apr-06

I want to search through the entire row and then display all the start
date for Phase="Performance Testing"

Plz someone let me know

 

[Guest]

Hi

Use Data/Filter/Autofilter. This will put little arrows next to each heading
cell and enable you to click on them to select what you want displayed.
There is an intro to this feature here:
http://www.contextures.com/xlautofilter01.html

Andy.
"sunita_shaw" <[email protected]>
wrote in message
news:[email protected]...

 

[sunita_shaw]

Thanks..but i dont want to filter it... I want to have the result
something like this in a sheet so i need to perform a search

Phase Start date
Performance Testing 01-Mar-06
01-Apr-06
System testing 13-Mar-06
18-Apr-06


and so on....
can anyone help

 

[Ron Rosenfeld]

Thanks..but i dont want to filter it... I want to have the result
something like this in a sheet so i need to perform a search

Phase Start date
Performance Testing 01-Mar-06
01-Apr-06
System testing 13-Mar-06
18-Apr-06


and so on....
can anyone help

Named Ranges:

Phase = range of project phases (e.g. A2:A8)
Start_date = associated dates (e.g. B2:B8)

F1:Fn Contains the phase of interest

G1:
=IF((COUNTA(Phase)-COUNTIF(Phase,$F1)+
COLUMNS($A:A))>COUNTA(Phase),"",SMALL((
Phase=$F1)*Start_date,COUNTA(Phase)-
COUNTIF(Phase,$F1)+COLUMNS($A:A)))

This must be entered as an array-formula. So after you type or paste the
formula into the formula bar, you must hold down <ctrl><shift> while hitting
<enter>. Excel will place braces {...} around the formula.

Finally, select G1 and copy/drag down as far as required for the different
phases. Then select G1:Gn and copy drag across far enough to cover all the
start dates (e.g. perhaps to Column L)

The formula should give blanks if there is no data; and should display the
start dates in ascending order.


--ron