I have to say I just stumbled on this thread looking for something else and found it very interesting... especially given the people on the post... a lot of whom are big time contributors to the site. I appreciate it's not been added to for some time but figured I would post anyway... I'm like that. I answered a post about a 10-pin bowling template the other day only to discover that it was posted originally in 2004 or something
I like this site a lot and the whole issue of whether OPs are investigative by nature is an interesting one... I often wonder how many really "unique" questions are asked on Mr E and how many are in truth really just minor variations to a question that's been asked here a thousand and one times before...
I suspect that if a guest/member was *really* (heavily) interested in learning the nuances of Excel for themselves and in so doing solving their own problem they could probably find something amidst the multitide of posts on this site that once broken down would allow them to adjust to suit their own needs. However, as time goes on I believe this gets more difficult because IMO Mr.E is a victim of it's own success as I think the real issue comes down to how easy/difficult it is to search the 1.5m posts and find something that is along the same lines of your requirement. The site is SO good and successful that you would have to either a) be very clever in your search criteria and/or b) have time to go through all of the posts returned... given a lot of the posts are slight variations of each other it's likely that their search method would return a LOT of results... perhaps they look at them all and think -- "jeez, I'd be better off just posting my own specifics in a new question as I don't have time to go through these..."
Let's be clear, I'm not knocking the search engine here I'm merely saying there are normally too many variables in the OPs scenario for them to find something they deem similar or the opposite, their search is too generic... without the expert knowledge it's difficult for them to ascertain as to whether or not an old post is really giving them what they need.
Fundamental point I guess is that for 95% of the time the questions are posted by people at work and most people (in my experience) by nature aren't inclined to spend hours trying to solve something they feel they can get someone else to solve in minutes.
The posts I avoid are those along the lines of:
"I got this formula from someone here a while back but I need to change it to now do this, can someone please change it ? "
This to me is where I (as someone keen to learn in general) get frustrated... the attitude of not wanting to know how something works I find difficult to grasp... ie how on earth are you comfortable using something in your job that you don't yourself understand ? The mind boggles.
In summation, this site is awesome... I am very much a contributor of the answer variety but I do ask the odd question... however just by answering questions I have in the past week been blown away by contributions from pgc01, oaktree, fazza and mikerickson to name but three... and THAT is why I love this place... That and the fact I know I am not able to generate a solution to every question posted here as I simply don't know enough... I suspect I never will.
Incidentally - I WAS looking for:
"what does Ingore List feature" do ? Presumably just PMs...