MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register
Articles (79182) |<First << Prev /7919 Next>> Last >|
 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

(0.46 seconds)