Formula ? 4 240 (6/3/2010 4:55:15 PM)
Hi, anyone who know the solution below ? Start Date End Date 01.01.10~31.12.10 01.01,11~31.12.11 1)01/10/09 31/01/10 days ? ...
Utf

Pivot Table Formulas 0 651 (6/6/2010 2:17:48 PM)
I need to create a variance formula for the data selected in a pivot table. My problem is that the data is coming in from one column and I don't know how to distinquish the data by year in the formula. I ...
Utf

blank cells having no value 2 653 (6/6/2010 12:46:34 PM)
Hi, though this is Steve's account it is his wife Val writing with my problem. Back in the old days of DOS there was a function which allowed you to set all blank cells as blank - that is = not having a valu...
Steve

How to determine the value? 2 557 (6/6/2010 5:17:38 AM)
Does anyone have any suggestions on how to determine the value within lists? For example, [1] There is a given date in cell A1, 06-Jun without concerning year, I would like to determine the value within co...
Utf

No formulas Work 3 309 (6/5/2010 4:04:36 AM)
For some reason none of hte formula in a spreadsheet are working. The spreadsheet is on a netowrk and when others open it, the formulas work. When I open the spreadsheet on a simple addition formula I get...
Utf

Nested AND OR expressions 7 341 (6/5/2010 6:44:24 PM)
HI I need to express something in VBA , and am having trouble with it. I need to say this : IF E1 CONTAINS "1bx" OR "2bx" OR "3bx" AND J1 =11 THEN PUT 1 , OTHERWISE PUT J1 Can someone assist w...
Colin

Help! how to cross - data with excel?? 3 1342 (6/6/2010 8:13:07 AM)
Hi, I'm required to present some info at my work, using two excel files. This is the task: File 1, has ID numbers in column A, and column B is blank. File 2, has ID numbers in column C and column D has ...
Utf

Split report for email 5 140 (6/1/2010 7:56:01 AM)
I have a report that contains a number of columns - and where the report contains a number of lines for a range of 'cost centres'. The report has the cost centre title in one column (say B) and then a number...
Utf

Formula Questions 6 291 (6/5/2010 2:40:05 PM)
Having trouble with formulas. I have two work sheets. Work sheet1 is a work order. Work sheet2 is what needs to be done by a certain date. What I need to do is type in a date in work sheet 1. At that point ...
Utf

Converting XLS file to QIF or to OFX 1 1416 (6/6/2010 3:18:20 AM)
How do I safely and securely convert an excel file (xls) to a QIF or OFX file? ...
Utf