Most common question

[Guentjo]

Just a quick survey to get people's opinion of the most common questions on this board. my money is on "how do I do a sumif with multiple criteria?"

I think that was the question that brought me here

I bet for every post of some of these quesitons there are at least 5 people who actually use the search feature to find their answer. Maybe we should look to making a sticky with this content.

 

[Oaktree]

That's certainly up there. "What do the --'s do?" is another one...

 

[Greg Truby]

My money's on "how do I delete duplicate rows?". Perhaps it's just my perception, but it seems like I see (at least) one of those every day or two.

 

[Oaktree]

Another one: "How do I create a list of only the unique values?"

 

[lenze]

My money's on "how do I delete duplicate rows?". Perhaps it's just my perception, but it seems like I see (at least) one of those every day or two.

AMEN

lenze

 

[Smitty]

the most common questions on this board

HELP!!!!!!

I NEED HELP!!!!!!

URGENT QUESTION!!!!!!!!!!!!

PLEAZZE HELP!!!!! [sp?]

Nnnneeed I say more or do I stutter?

Although Dependent Lists does come up a bit. (Hint: #154 )

Smitty

 

[Von Pookie]

One that seems to be coming up quite a bit lately (actual text may vary): "Can I make a list in data validation and then just type a letter and it'll automatically jump to that section in the list?"

 

[XLGibbs]

I am pretty sure it is:

Thanks Aladin, your formula works great! How exactly does it work?

 

[Greg Truby]

Touché, Gibbs. I'm pretty sure a fair number of the MVP's still ask that question -- though we do tend to see if we can suss it out on our own first and then ask him if he has stumped us. Along those lines, then at least for myself, one question I frequently mutter to myself as I'm reading posts is "is there anything Tushar doesn't know about VBA"?

 

[just_jon]

Multiple returns from VLOOKUP

How do I get rid of #N/A

EDIT: Oh, yes, not to forget:

"I've got this lottery program and what I need is ..."

[ Like, y'know, the guys at CalTech/MIT haven't taken a crack at this one yet...]