Formula ?4240 (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 Formulas0651 (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 value2653 (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?2557 (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 Work3309 (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 expressions7341 (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??31342 (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 email5140 (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 Questions6291 (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 OFX11416 (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