One formula for a single column in Excel 2003
I am using MS Excel 2003. I have a spreadsheet with the exactly the same formula in every cell of a given column (This is possible by using the row() and the indirect() funtions). The spreadsheet is using 6000 rows. Currently, I have copied the formula into each cell. This increases the calculation time of [...]

Answer Question   |  August 18, 2011  4:54 PM
Excel 2003, Excel 2003 formulas, Excel formulas

Qmf for Windows 8.1 fp18 – date datatype from db2 z/os 8 format error in excel 2003
When I import a DB2 z/OS query result  containing date or date(timestamp) columns from QMF for WINDOWS in EXCEL 2003 using the Add-in the cells cannot be formatted. In the same column the date are displayed sometimes as dd/mm/yyyy, sometimes as nnnnn or in the previously defined format (example dd-month ) if exists. The first [...]

Answer Question   |  December 20, 2010  10:56 AM
DB2, Excel 2003, Excel 2003 formulas, QMF, QMF V8, Windows XP SP2, z/OS

How do I sort an entire state customer list by only the zips I work with?
how do I sort an entire state customer list by only the zips I work with

Answer Question   |  August 18, 2010  9:57 PM
excel, Excel 2003, Excel 2003 formulas, Excel 2003 functions

Cross associate between 2 excel 2003 files
I have a data base of 3000 products each product has a unique code followed by 5 different cells of information. I need to, on a daily basis produce a spreadsheet showing which products are used in each of 400 shops. All i want to do is type the unique code in column C on [...]

Answer Question   |  April 29, 2010  6:28 PM
Excel 2003, Excel 2003 formulas, Excel 2003 functions

Help with this Microsoft Excel 2003 formula
What formula will appear in cell C7 if the formula =B6*$B$1 is copied from cell C6 to C7?

Answer Question   |  March 2, 2009  11:53 PM
Excel 2003 formulas, Microsoft Excel 2003, Microsoft Excel 2003 formulas