Excel Tips
Number Format to Hide Zeroes »
October 22, 2001
When I copy cells to a another page, then I link them, I get zeroes in the empty cells were there is no data.
October 21, 2001
Let's say you have a thousand-line table. With clever subtotaling, you create a 30-line summary. You want to copy this summary onto a worksheet containing other information.
October 18, 2001
How can I open a workbook in VBA choosing from a list?
Naming a Worksheet as the Value of a Target Cell »
October 16, 2001
How can I change the name of the worksheet only, with text located in cell A1?
Use a CSE Formula (Array Formula) to Perform Super-Calculations on Data »
October 16, 2001
Use array formulas (CSE Formula) to perform super-calculations in Microsoft Excel. A single array formula can replace 5000 other formulas, but only if you know the secret keystrokes. Let MrExcel demystify these powerful Excel formulas.
October 15, 2001
I have a column of numbers that I want to add. But I want subtotals for each person who may have more than one number.
Text Value Response to Input »
October 15, 2001
Your ace pitcher starts to look weary in the 6th inning and then gets in trouble in the 7th inning. Can you show me a formula in Excel to tell if I should pull him out of the game?
Automatically Get the Date and Time »
October 15, 2001
Is there a way to get the date and time automatically by creating a formula?