Favorite Message Board Topics

On December 8-9, 2007, Suat Ozgur spent the weekend updating the MrExcel Message Board from a phpbb system to a vbulletin system.

On Monday, December 10, many people were getting their first look at the new board and Richard Schollar asked, "what happened to my favorites list?"

It turns out that out of 60,000 members at the board, there were about 300 who were using a feature to mark their favorite posts. Richard explained that his favorites list was a veritable reference guide on Excel and Excel VBA.

As Suat was recovering the favorites from the old board to add them to the new board, I asked for a complete list of everyone's favorites. I ran some pivot tables in Excel to try to find the consensus favorites. Which topics kept showing up again and again on many different people's lists of favorites.

There are four different lists on this page:

List 1 are topics that appeared on anywhere from 6 to 42 different member's favorites list.
List 2 are topics that appeared on 2 of the MrExcel MVP's lists.
Lists 3 and 4 are other cuts of the data.

Favorite Message Board Topics

List 1

List 2

List 3

List 4