+- Online Degrees and CLEP and DSST Exam Prep Discussion (https://www.degreeforum.net/mybb)
+-- Forum: Miscellaneous (https://www.degreeforum.net/mybb/Forum-Miscellaneous)
+--- Forum: Off Topic (https://www.degreeforum.net/mybb/Forum-Off-Topic)
+--- Thread: Any Excel wizards? (/Thread-Any-Excel-wizards)
Any Excel wizards? - cinderly - 10-31-2007
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.")
Any Excel wizards? - cinderly - 10-31-2007
Never mind ... I figured it out. Nested functions - full of win.
And now I feel silly for posting a thread about this.
Any Excel wizards? - Kiwi Lover - 10-31-2007
cinderly Wrote:Never mind ... I figured it out. Nested functions - full of win.cinderly,
And now I feel silly for posting a thread about this.
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]
Any Excel wizards? - cinderly - 10-31-2007
If anyone wants the magical Excel function, let me know. It's a combination of =IF and a custom VBA formula.
Kiwi Lover Wrote:Sorry about the migraines.
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.