Skip to content
Archive of entries posted on

How to retire after selling one copy of a book

Amazon seller lists book at $23,698,655.93 — plus shipping http://www.cnn.com/2011/TECH/web/04/25/amazon.price.algorithm/index.html?iref=NS1 which references Amazon’s $23,698,655.93 book about flies http://www.michaeleisen.org/blog/?p=358 — Tushar Mehta

Ordinal Numbers Suffixes

Starting with Excel 2007, it is possible to specify the number format as part of conditional formatting. This note shows how to leverage that capability to add the appropriate suffix to an ordinal number (e.g., 1st, 2nd, 3rd, 4th, etc.) For a version in a page by itself (i.e., not in a scrollable iframe as […]

Extend an object’s attributes to coordinate multiple userform controls

This was motivated by a question in the mrexcel.com forum. The person asking for help had multiple comboboxes in a userform, each of which contained the same items, A through L for the purpose of this exercise. These items were sorted alphabetically. He wanted that when the user selected an item in any of the […]

Conway’s Game of Life simulation in Excel

For a version in a page by itself (i.e., not in a scrollable iframe as below) visit http://www.tushar-mehta.com/publish_train/xl_vba_cases/0906%20conways%20game%20of%20life.shtml Tushar Mehta

Banding rows in an Excel Table

For a version in a page by itself (i.e., not in a scrollable iframe as below) visit http://www.tushar-mehta.com/publish_train/xl_vba_cases/0120-1%20banded%20rows.shtml Tushar Mehta