Excel Tips
CountIf or SumIf in Excel with Two Conditions »
July 5, 2002
For a SUMIF or COUNTIF formula with 2 conditions, you need to use an array formula.
Numeric Chart Series Captions »
July 2, 2002
Excel makes it very easy to get a default chart up and running.
Macro When Excel Cell Changes »
June 25, 2002
Excel to run a macro every time a value changes in the Excel spreadsheet.
June 11, 2002
I need to import a file daily. I'd like to add the file each day to an existing Excel workbook and have the worksheet named for the d/m/y.
June 4, 2002
I have imported a file into Excel. The zip code is broken into 2 cells. The 5 digit part of the zip code is in column E, the 4 digit part of the zip code is in column F. I need to join them into a single cell.
May 28, 2002
Search a column and highlight red the cells that contain today's date.
Increment a Counter Everytime a Userform is Opened »
May 25, 2002
How to increment a number by one each time the user form is opened.