Only 1 Week Left: $1400 of Prizes
THIS CONTEST CONCLUDED 11/30/2008. Thanks to everyone for entering. Don’t worry… There’s still time to enter for chances to win some of the $1400 in prizes (including Excel Consulting, Office 2007, an iPod Shuffle and Cash). Sign up for our email feed or write a post about the contest. It’s that easy. Click Here for [...]
What Version Of Excel Do You Use?
We just closed our first poll on Excel Hints after receiving over 100 votes. Thanks to everyone who participated. The results were pretty much as expected. We asked users of the site which version of Excel they were currently using. I expected the results be lean more towards Excel 2003 still, since it seemed to [...]
Find the 2nd Largest Value in a Range
Excel provides an easy way to list the k-th (first, second, third, etc.) largest number in a range. We’ll also take a look at the opposite situation where you want to find the 2nd smallest value in a range, for example. Large & Small Formulas So let’s go ahead and take a look at the [...]
Contest Update: Enter Now!
THIS CONTEST CONCLUDED 11/30/2008. Thanks to everyone for entering. There are 3 weeks left in our first contest giveaway (ends November 30th, 2008), so get your entries in now. The contest is gaining momentum and we are very pleased with the number of entries so far. 105 new Subscribers since the start of the [...]
Using the Status Bar to Display Messages
Excel provides an easy way to show the end user messages about the status of a macro that is running. This can be a useful way of updating users, especially during long running macros, as to the status of the routine. Some users need updates from the system to let them know that the program [...]
