How do I create a "List If" function.I need to search a database .
 

I have a database of employees listing various data points, such as, SSN,
DOB, Address, Salary, department, and "Phase". All employees go through 5
different "phases" within the organization, (i.e. New Hires, Offer Lettered,
etc.). I need a worksheet function that will go to this general database and
retrieve or "LIST" all employee names and some of their relevant data points
(i.e. address, salary) that are at a certain phase. Example, List all
employees that are "New Hires".

The LOOKUP function does not help in this effort. I would like to avoid a
manuel copy, sort and delete process from the genearl database.

You can use autofilter for this, then automate it using a macro.


Regards,

Peo Sjoblom

"Flying Solo" wrote:

I have a database of employees listing various data points, such as, SSN,
DOB, Address, Salary, department, and "Phase". All employees go through 5
different "phases" within the organization, (i.e. New Hires, Offer Lettered,
etc.). I need a worksheet function that will go to this general database and
retrieve or "LIST" all employee names and some of their relevant data points
(i.e. address, salary) that are at a certain phase. Example, List all
employees that are "New Hires".

The LOOKUP function does not help in this effort. I would like to avoid a
manuel copy, sort and delete process from the genearl database.

Hi

if the "database" is in excel, i would use autofilters. Click in the data
range, choose data / filter / autofilter ... click on the drop down arrow of
Phase and choose the phase you want.

Does this give you what you need?

If not, have a look at Data / Pivot Table & Pivot Chart Reports ...
http://peltiertech.com/Excel/Pivots/pivottables.htm
and
www.contextures.com/tiptech.html

Cheers
JulieD

"Flying Solo" <Flying wrote in message
...
I have a database of employees listing various data points, such as, SSN,
DOB, Address, Salary, department, and "Phase". All employees go through 5
different "phases" within the organization, (i.e. New Hires, Offer
Lettered,
etc.). I need a worksheet function that will go to this general database
and
retrieve or "LIST" all employee names and some of their relevant data
points
(i.e. address, salary) that are at a certain phase. Example, List all
employees that are "New Hires".

The LOOKUP function does not help in this effort. I would like to avoid a
manuel copy, sort and delete process from the genearl database.