Look Who it Was Random video

Excel - MapPoint Contest Results & Excel Entry Forms | St. Patrick's Day Special - Episode 716

1,068 views · Published 18 February 2009 · 3:41 · Indexed 1 November 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial:  MapPoint Contest Results & Excel Entry Forms.

Welcome back to the MrExcel netcast! I'm Bill Jelen and today is a big day in the U.S. because it's St. Patrick's Day and yesterday was Selection Sunday for the NCAA basketball pool. If you're participating in an office pool, make sure to stop by my website MrExcel.com/NCAA.html to grab one of our free Excel entry forms. You can also win some great books by playing along.

Speaking of contests, we recently had a contest where we asked viewers to send in their zip code or postal code. We had a great response with 190 entries, which is a pretty good ratio considering our podcast is watched by about 10,000 people on any given day. We used MapPoint to map out the entries and it was interesting to see the wide range of locations represented.

For those in the U.S., MapPoint did a great job mapping the zip codes, while for Canada, it was able to map the postal codes. However, for the rest of the world, we had to map to a city and country since we don't have the European version of MapPoint. Some places were easily found, while others were not due to misspellings or MapPoint not recognizing certain suburbs. But overall, we had a good representation from different countries such as Australia, England, and various states in the U.S. and Canada.

As promised, we randomly selected a winner from the 190 entries and the lucky winner is Tim from Braintree, Massachusetts with zip code 02184. Congratulations, Tim! We will be sending you a copy of MapPoint for yourself. Thank you to everyone who participated in the contest and for showing us the wide reach of our podcast.

To select the winner, we used the RAND between function in Excel, which is part of the analysis tool pack. Make sure to have this add-in selected under tools before using the function. We specified the range of numbers from 11 to 190 and it chose number 93, which corresponded to Tim's entry. Stay tuned for more Excel tips and tricks in our upcoming netcasts. Thank you for watching and we'll see you next time on the MrExcel netcast!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Today, in Episode 716 we take a look at the entries for the MapPoint contest, and also a chance to enter the MrExcel NCAA basketball game.

Table of Contents:
(00:00) Introduction and St. Patrick's Day
(00:20) NCAA Basketball Pool and Contest Deadline
(00:37) Map Point Contest Results
(01:25) Map Point Mapping Process
(02:00) Drawing the Winner
(02:44) Announcing the Winner
(03:07) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Contest deadline
European version of map point
Excel entry forms
Map point
NCAA basketball pool
Office pool
RAND between function
St. Patrick's Day
Winner of Map Point
Zip code or postal code


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152189/

More from this channel