Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Finding data in Excel
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? |
#2
|
|||
|
|||
Hi Riaan
Cannot remember Lotus, but are you talking about <Ctrl <F? "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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
#6
|
|||
|
|||
I want to use this function in a macro. Autofilter will not work.
"Kassie" wrote: 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? |
#7
|
|||
|
|||
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Refresh Imported Data - Does the Excel file have to be open? | Excel Discussion (Misc queries) | |||
Linking the data from one excel to another | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |