Most common question/answer

[Jonmo1]

Why isn't there a Sticky Thread giving examples of the most common questions and answers ? Or is there one that I can't find?

Like
How to eliminate NA from Vlookup?
How to count/sum multi criteria?
How to find last used cell?
How to lookup value in a matrix with Row and Column Variables?
How to Find Last X in Column/Row?

 

[arkusM]

Why isn't there a Sticky Thread giving examples of the most common questions and answers ? Or is there one that I can't find?

Like
How to eliminate NA from Vlookup?
How to count/sum multi criteria?
How to find last used cell?
How to lookup value in a matrix with Row and Column Variables?
How to Find Last X in Column/Row?

This would be a good idea. A FAQ of the very common issues...
Good call.

 

[Oaktree]

To be fair, Bill's podcasts (http://www.mrexcel.com/excel_video_training.html) answer most of the common questions...

They are sort of like a FAQ section by themselves!

 

[NateO]

Write one, and make it good. I'll make you famous.

(It will be peer reviewed before we do anything with it)

 

[xyzabc198]

Why isn't there a Sticky Thread giving examples of the most common questions and answers ? Or is there one that I can't find?

Like
How to eliminate NA from Vlookup?
How to count/sum multi criteria?
How to find last used cell?
How to lookup value in a matrix with Row and Column Variables?
How to Find Last X in Column/Row?

If you want the most common answer it's easy

A: I'm not sure sorry

 

[Jonmo1]

Write one, and make it good. I'll make you famous.

(It will be peer reviewed before we do anything with it)

Alright, It's ON !!

I'll start working on it right now.

Anybody out there have suggestions for common problem/solutions to add to it?

 

[xyzabc198]

Alright, It's ON !!

I'll start working on it right now.

Anybody out there have suggestions for common problem/solutions to add to it?

Add a basic guide to Conditional formats and formula's and how to access conditional formats and stuff for the very basic beginners...Also maybe common mistakes to avoid

 

[mattrx731]

Anybody out there have suggestions for common problem/solutions to add to it?

The few ways to clean/speed up code.... select/screen updating...etc.

I'm looking forward to seeing the end result.

 

[xyzabc198]

The following statement is True
The above statement is False[/quote]
 
WOW thats confusing :eeek:

 

[arkusM]

To be fair, Bill's podcasts (http://www.mrexcel.com/excel_video_training.html) answer most of the common questions...

They are sort of like a FAQ section by themselves!

I like Bills Pod casts, glad they are flash now, my work system does not like QT.

A suggestion for this above link; It would be nice if they were categorized, to make finding info/tips easier. As is stands there is just a massive list of topics, and if you don't know what you are looking then it could be difficult, thinking from a complete newbie's perspective.

Cheers.