Any Excel wizards?

[cinderly]

Almost four hours of searching and tweaking and my spreadsheet's still not behaving. (In my defense, I'm in Day Three of a particularly nasty migraine ...)

My Nth Instance formulas no worky -- anyone good with them?

I know this isn't an Excel Help forum, but the information on those forums haven't been exactly useful, so I'm trying a new tack.

The ultimate goal is to show all purchases for Date X (where date is dynamic and refers to the cell with value =Today() on the summary sheet). Data is pulled from multiple worksheets within the workbook where my summary resides.

Tinkering with LOOKUP to get the purchase relative to the date almost made me cry - I don't know if I'm up for this battle. Help?

(Also, I realized this morning that I now have an answer to "Why do we have to learn this?" if "this" is "Algebraic thinking.")

[cinderly]

Never mind ... I figured it out. Nested functions - full of win.

And now I feel silly for posting a thread about this.

[Kiwi Lover]

Never mind ... I figured it out. Nested functions - full of win.

And now I feel silly for posting a thread about this.

cinderly,

Don't feel silly!! I had absolutely no idea what you were talking about in that question, even if I do use Excel. So my hat's off to you for even knowing this stuff!!!

Well done,
JoAnne

P.S. Sorry about the migraines. Have you ever tried Tylenol with Codeine (need a prescription)...works great! [SIZE="1"][be quiet Basket Weaver][/SIZE]

[cinderly]

If anyone wants the magical Excel function, let me know. It's a combination of =IF and a custom VBA formula.

Sorry about the migraines. Have you ever tried Tylenol with Codeine (need a prescription)...works great! [SIZE="1"][be quiet Basket Weaver][/SIZE]

I've actually got prescriptions for both 1000 mg ibuprofen tablets (takes the edge off the various accompanying muscle aches) and Relpax, which normally works a treat.

I don't get auras, so I can usually work through a mild migraine. (There really is such a thing, although I wouldn't call it pleasant.) I just ask my coworkers to stop existing so loudly and everything's fine.

Once a year or so I get one so bad that the meds won't touch it and my cognitive functioning is more impaired than usual. So I stay home and take homeopathic full-strength Coke and Fritos (for the caffeine and salt) and use my therapeutic frozen peas in combination with my lavendar-infused eyemask.

Eventually, the barometric pressure changes or my hormones return to normal and I can function. Neurology tests have ruled out it being much else than pulling a bad lot in the genetic lottery.