| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Database function criteria
In Lotus 1-2-3, you are no longer tied to a criteria range. You can embed a
formula in the criteria field. For example, if I have a database named Calendar with columns titled: Number Name Weeks I can create a function like =DGET(calendar,"name",number=4). This eliminates the necessity of creating criteria ranges. Is such a thing possible in Excel? Art |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Database Function Criteria be a Date? | Excel Worksheet Functions | |||
| strings as criteria in database function DCOUNT | Excel Worksheet Functions | |||
| Database Function Criteria Boolean Operations | Excel Worksheet Functions | |||
| Database function criteria | Excel Worksheet Functions | |||
| Function that filters a list (Database) for criteria in a range a. | Excel Worksheet Functions | |||
Threaded Mode
