how do i set 2 criterias for the DGET in excel 2002

[anon125]

DGET(wdata,"avgmax","month"=3 and "day"=5)
how do I have 2 criteria?
and do I have to have those curly brackets by typing shift or whatever?
thanks
PS the columns are called month, day, avgmax etc and the rows have every date in a year

[anon125]

I seldom use excel so I would not know how to do that.
what I wish is to enter the month and day in some cells (or use TODAY) and find the stats for that day.
thanks

[FDibbins]

I suggest that you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[anon125]

great idea thanks
see below

[anon125]

when do I have to use the ctrl? key when finishing a formula? I think it is with lists and ranges etc
thanks

[TheN]

Okay, so I created a helper column (which you can hide) to make life easier. I also took the liberty of moving your top things around so you could simply drag the formula to the right and it would fill in everything (if you so desired).

I used these formulas:

Please Login or Register  to view this content.

for the data, and

Please Login or Register  to view this content.

for your helper column.

See attached file. Hopefully it works in 2002 excel, I don't have anything that old unfortunately.

[anon125]

Thanks for trying... it said circular

[TheN]

oh, I mustn't have changed the formulas in sheet after i moved the formulas over, sorry.

copy the top formula in my post above (It's right) in the D7 cell

Please Login or Register  to view this content.

once again, sorry for the inconvenience.

[anon125]

thanks VERY much - that worked fine
see attached.
how do I convert the TODAY or NOW functions so your formula will accept their month and day numbers?
yes I changed the row numbers in your fine D7 formula copied into D8 etc.
thanks again

[JeteMc]

Try this:
1) Modify B7 to read: =MONTH(TODAY()) (change the format to general)
2) Modify B8 to read: =MONTH(NOW()) (change the format to general)
3) Modify C7 to read: =DAY(TODAY())
4) Modify C8 to read: =DAY(NOW())
Let me know if you have any questions.

[TheN]

I thought of something else that might be useful to you in this case.

You can make it so your month/day options have unique drop downs that auto-populate based on your data.

see this thread for an example.

http://www.excelforum.com/showthread...=1#post4467192

[anon125]

everything now works.
thanks guys for your help

[JeteMc]

You're Welcome and thank you for the feedback. Please take a moment to mark the thread 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.