Finding data in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top