I was recently contact by a regular ExcelWithMonarch.com reader, Nigel Winton of England, who relayed how he used Monarch to create an interesting solution to a challenge given to him by a co-worker.
Here’s his story…
I have one person who is always requesting something new. You know the type: flexible goal posts with no fixed abode.
Recently […]

read more from this topic.....

I was watching a music documentary on television recently, and one of the comments made really, um, struck a chord with me.
The interviewee in one particular segment was talking about how the introduction of music video in the 1980’s changed the industry, and how the careers of talented musicians such as Supertramp arguably ended almost […]

read more from this topic.....

You can save yourself a lot of manual editing, or even copying and pasting, in Excel by using the search and replace (Ctrl-h) feature. This will replace all occurrences of one value, or even a part of a formula, with a different value.
Say you defined a lookup range improperly, setting the rightmost column to H, […]

read more from this topic.....