Excel Tips
June 9, 2017
You need to reduce every number in an Excel column by 3 or 7 or 22 or 12%. Here are several ways that you can quickly solve this problem.
May 28, 2017
I love custom lists in Excel. They are great for the fill handle and for sorting data into a different sequence. Custom Lists should allow 254 items. But for some reason, a reader is encountering a situation where Excel is only keeping the first 38 items! We will get to the bottom of this mystery.
May 18, 2017
In today's Dueling Excel, Mike and Bill attempt to deal with Bond Dates. Say that you buy a six-month bond in the middle of the month. You need to calculate a full month's interest for months 2, 3, 4, 5, 6 but only half a month in month 1 and month 7.
May 11, 2017
How to debug an Excel VBA macro that is not working. There are amazing tools in Excel VBA that let you see the current value stored in variables as you step through code one line at a time. If you have a macro that is not working,
Workbook Opens on Missing Monitor »
May 10, 2017
An Excel workbook opens, but you can't see it! The taskbar says the workbook is open, but it is not on the screen. This recently happened to me when I opened a workbook that I last opened three years ago when I had a second monitor.
May 9, 2017
Excel VBA Macro to sort data. I don't like how the macro recorder creates extra code for sorting. Sorting in Excel VBA should be simple. One line of code, with the column to sort, which way (ascending or descending) and is there a header.
May 7, 2017
Today's trick from Lisa in Indianapolis is a faster way to filter a chart
May 5, 2017
Can Excel VLOOKUP return all results and join them with a comma in between?