A
Art
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
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