Most common question/answer

Jonmo1

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
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?
 
jonmo1 said:
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?
Click to expand...

This would be a good idea. A FAQ of the very common issues...
Good call.
 
Write one, and make it good. I'll make you famous.
icon12.gif


(It will be peer reviewed before we do anything with it)
 
Last edited:
jonmo1 said:
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?
Click to expand...

If you want the most common answer it's easy

A: I'm not sure sorry
 
Write one, and make it good. I'll make you famous.
icon12.gif


(It will be peer reviewed before we do anything with it)
Click to expand...

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?
 
jonmo1 said:
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?
Click to expand...

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
 
Code: 
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.
 
Oaktree said:
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!
Click to expand...

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.
 
You must log in or register to reply here.

Forum statistics

Threads
1,225,360
Messages
6,184,508
Members
453,237
Latest member
lordleo

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top