Have you tried Data|Autofilter?

"Riaan" wrote:

Yes, I want to use find data with two or more conditions.

"Kassie" wrote:

Hi Riaan

Me again. Or are you talking about Data, Query Extract. <Ctrl<F takes
you to instances where you find a single condition. This one extracts data
to a preset area in the worksheet, based on criteria you enter in a criteria
range, using the headings from the database. You set up the criteria area,
using the headings, and with a row underneath that where you enter the
criteria. You then set up the output range, again containing the Headings,
and under that a number of rows which will be filled with data meeting the
criteria.

"Riaan" wrote:

Lotus had a data find function where you indicated criteria(Same heading as
the database - You could use more than one column) on another part of the
worksheet to search for. You selected / data, find and Lotus highlithed the
row that matches the criteria.

Is there in Excel a simular function?