Share your favourite posts

[Jon von der Heyden]

Hi

I've just been browsing my library of favourites. I have a fair few in there but it could do with some more. Only too often do I browse this site with a particular search parameter, now I'm hoping to learn more cool tricks by visiting your top 5 favourite MrExcel posts:

Here are my (current) favourite 5:

Richard Schollar demonstrates VBA method to delete rows in a range based on a criteria.

Damon Ostrander's UDF to generate random numbers between x and y and yet exclude numbers in a specified range.

How to consolidate multiple workbooks into a singular workbook with multiple sheets.

Barry Houdini's explanation of how to use SUMPRODUCT() to calculate variable rates and commissions.

Barry Houdini's explanation on how to return the week number in a tax year.

Best Regards
Jon

 

[NateO]

Dang nab-it! I didn't make the top 5?! What you want me to talk about? Put me in coach, I can play!

With respect to the following:

Barry Houdini's explanation of how to use SUMPRODUCT() to calculate variable rates and commissions.

No disrespect to Barry, he's a very appreciated and respected member here, but be careful with this one. I've noticed that you have cited Barry as the author of the following:

http://www.mcgimpsey.com/excel/variablerate.html

Just to be sure, the author is actually John McGimpsey, Microsoft Excel MVP.

 

[Jon von der Heyden]

Arrr never mind Nate I sure you make many other's top 5

I think your posts are typically around topics well beyond my current capabilities. :wink:

You are absolutely right, thanks for the correction.

Jon

 

[NateO]

No worries, I was kidding around about my posts...

I like this thread though, it might give us some ideas/good reading.

My top five can be found in here, somewhere:

http://www.mrexcel.com/board2/viewforum.php?f=13

But I suspect it's missing a couple... :wink:

 

[Greg Truby]

Dang nab-it! I didn't make the top 5?! ...Put me in coach, I can play!
~Nate

Not to worry, lad. You show up on one of my all time favorites. Nate and I had some nice back and forth going on and I learned a thing or two. And then we got humbled because neither of us fancy-pants hotshots thought to ponder the idea that what the OP was calling dashes were, in fact, zeros formatted as dashes.

 

[NateO]

Wow, three years ago.

Interesting to look back and note how my coding style/preferences have changed over the years...

Okay, in good faith, I've tried recreate 5 posts/threads that impacted me:

Dennis' post on trouble shooting ADODB:

http://www.mrexcel.com/board2/viewtopic.php?p=316665#316665

I was using this yesterday while querying a closed CSV file with ADODB (very fast/slick):

For i = 0 To cn.Errors.Count - 1
    With cn.Errors(i)
        Debug.Print "Error " & CStr(i), "Description " & .Description, _
            "Number " & CStr(.Number), "NativeError " & CStr(.NativeError), _
            "Source " & .Source, "SQLState " & .SqlState
    End With
Next i

Actually, I had no ADO connection errors, so I never really did test this rewrite...

Dan's Outlook post/thread:

http://www.mrexcel.com/board2/viewtopic.php?t=8251

Aladin's post on depedant data validation cells:

http://www.mrexcel.com/board2/viewtopic.php?p=154#154

Andrew Poulsom shows me to think outside of the box (and not to underestimate the mysterious powers of SumProduct()):

http://www.mrexcel.com/board2/viewtopic.php?p=267491#267491

rrdonutz showed me something I didn't think was possible, summing numbers in a string:

http://www.mrexcel.com/board2/viewtopic.php?p=248645#248645

So there's five.

What post had the biggest impact on me, as an aspiring Excel user?

Look no further than Ivan F Moala's post, right here:

http://www.mrexcel.com/board2/viewtopic.php?p=3124#3124

That for me was an eye-opener, the imagined ceiling had been removed, the sky had become the limit!

This is outside the scope of this thread, but while we're at it, here's a humourous thread I took part in:

http://www.mrexcel.com/board2/viewtopic.php?p=68090#68090

BANG! Right between the eyes!

 

[Richard Schollar]

My favourite is by Barry and it's on ExcelForum not here (and a really recent one to boot!):

http://www.excelforum.com/showpost.php?p=1836814&postcount=7

His date formulas are, for me, the dog's testicles.

 

[NateO]

Dare I ask...

Richard, aren't these generally discarded?

 

[barry houdini]

My favourite is by Barry

who's this daddylonglegs geezer??

 

[NateO]

Not to worry, lad. You show up on one of my all time favorites. Nate and I had some nice back and forth going on and I learned a thing or two.

That's a pretty wild thread now that I reread that, Greg! All sorts of different, moving parts to be found there. Thanks for the ping!

Have nice weekend everyone, I'm off to watch NCAA Midnight Madness!!