JOKES:
F(x) walks into a bar. The barman says "I'm sorry sir, we don't cater for functions"
Why do mathematicians always confuse Halloween and Christmas?
Because 31 Oct = 25 Dec.
A mathematician and his best friend, an engineer, attend a public lecture on geometry in thirteen-dimensional space. "How did you like it?" the mathematician wants to know after the talk. "My head's spinning," the engineer confesses. "How can you develop any intuition for thirteen-dimensional space?" "Well, it's not difficult," says the mathematician "all I do is visualize the situation in n-dimensional space and then set n = 13."
A physicist, a biologist and a mathematician are sitting in a street café watching people entering and leaving the house on the other side of the street. First they see two people entering the house. Time passes. After a while they notice three people leaving the house. The physicist says, "The measurement wasn't accurate." The biologist says, "They must have reproduced." The mathematician says, "If one more person enters the house then it will be empty."
Those jokes should give you some idea of the sort of person you're dealing with...
ME:
I have a baby daughter, who makes me happy. And tired. So very, very, tired. If my responses seem abrupt, or rambling, you can thank her!
Contrary to popular belief, I do have a job. (and this is not it)
I can be contacted on roryee at gmx dot com but can't always pick up personal emails during the day. I don't respond to offsite requests to look at your questions. However, I do occasionally lose track of questions I have participated in, so if you need to give me a nudge, feel free. :)
RULES:
In my opinion, there are only 2 real rules for posting questions (these are based solely on the Excel zone, as I don't go anywhere else):
Rule 1: All the Experts at EE are volunteers. If you're nice to them, you'll get results; if you're not, you won't. (it's just common sense)
Rule 2: Help us to help you:
i) Be as clear as you can about what you need. A bit of background as well as your specific issue can be very useful.
ii) If you can post a sample workbook, it usually helps, but PLEASE remove anything confidential before posting. We need an idea of what you start with, and what outcome you want. Addendum: I don't know why people post pictures of workbooks instead - it doesn't help us. Please provide something for us to test!
iii) If you prefer a formula approach or a VBA one, please say so at the start, as it saves anyone wasting time.
iv) We ALWAYS need more information than "It doesn't work". If you get an error, tell us what it is and where it occurs, for example. The more detail , the better as a rule.
(After all, you wouldn't take your car to a garage and just say "it doesn't work. Fix it")
v) Feedback is very useful - good, bad or otherwise. It helps us to help you, and helps those who are searching the database later to know what actually worked for you.
vi) If there is something about an answer you don't understand, please ask! A solution you can learn from and adapt is always more useful to you in the long run.
vii) If someone asks you a question about what you have posted, it is in your interests to reply...
viii) Please say what version of Excel you are working with, especially if it's 2007 (or later!), which is quite different to previous versions.
FINALLY:
Please close your questions promptly and accurately, as it saves the Cleanup Volunteers unnecessary work, and adds to the knowledgebase.
Remember you can split points if more than one response was helpful.
Oh, and just be aware that some Experts are touchy about grades. Whilst we do all collaborate to get the job done (that is why we're here, after all), there is occasionally a wee bit of competitive spirit that creeps in... ;^P
While you're waiting for your solution, why not see if you can help someone else? You might be surprised at how much you know, and it's fun. (no, really!)
I am a Microsoft MVP for Excel, due to spending too much time here!
Thank you for reading - don't you have any work to do??
>8^P
Viva Las Vegas...
