Can anyone provide me the fomula ? Hi, I need the fomula for below scenario, A4 = start date (exp.= 01.03.2007) B4 = end date (exp. = 31.05.2012) D1 = 01.04.2007 D2= 31.03.2008 E1= 01.04.2008 E2= 31.03.2012 F1 = >31.03.2012 at D4 = fomula to get the answer of days which fall between A4 & B4? (365days) D4 = fomula to ge... 6 Jun 2010 12:44
Formula I'm in need of a formula in C1 that gives me the value of A1 divided into 60 if B1 is empty, however if B1 has a value (not zero) then C1=B1/60. THANKS. ... 6 Jun 2010 12:44
Excel 2010 I have installed Excell 2010 and now when I open the program, it opening all the excels files. It also is trying to open the other files like .doc in that same directory. How can I stop this from happening. ... 6 Jun 2010 12:44
Pivot Table Formulas 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 have put a small selection of my data below. I would like to show the variance between 2009 and 2010 for ... 6 Jun 2010 10:31
Converting xls to ofx The new iCreateOFX Basic product pages can be found at: http://icreateofx.co.uk/Convert-CSV-to-OFX ... 6 Jun 2010 09:26
Help! how to cross - data with excel?? 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 the date the person joined the company File 1 es a select grop of people (about 2500), whereas File 2 is ... 6 Jun 2010 07:16
How to determine the value? 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 column C, it should return 6 in cell A2, because 06-Jun is equal to or larger than 05-Jun and less than 21-Jun... 6 Jun 2010 09:26
Find certain "Text" in a specific coloum, add corres. values Hi, I have two coloums. One has text and the other has Values. I need excel to search through a whole coloum, and summerize the results. My coloums look like as follows A 2 B 5 A 2 The results should look like A 4 B 2 How can I achieve this? Thanks ... 6 Jun 2010 01:38
Converting XLS file to QIF or to OFX How do I safely and securely convert an excel file (xls) to a QIF or OFX file? ... 6 Jun 2010 05:07
Copying rows of data into new worksheet but placing data into colu I have a spreadsheet which contains 3375 records (Excel 2007). My quandry is the following: I need to reformat the rows into columns for each Dealer (starting a new row for the next Dealer). CURRENT SPREADSHEET: DEALER LOCATION VOLUME AMOUNT 123 Anytown, USA 155 $24,100 123 Hometown USA 145 $25,0... 6 Jun 2010 12:44
how do we get 2003 .xlb toolbars and custom macros to show in 07 I have custom macros that are saved in an .xls file under the XLStart/ folder in Excel 2003. These macros are referenced by an Excel11.xlb file that holds the toolbars. All of these automatically open because they are under the XLStart/ folder. How do I get them into Excel 2007 so they will open automaticall... 5 Jun 2010 21:19
Nested AND OR expressions 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 with some code to make this happen , please? Grateful for any help. Best Wishes ... 6 Jun 2010 07:16
formula for moving information from one sheet to another sheet I have information in column A of a task sheet. The information goes from row 1 thru 35. Column B is where I place a "x" to say the task need to be completed. Is there a formula that can check each row in column B to see if the "x" exist, until it reaches the end. If the "x" exist in any of the rows, then mov... 6 Jun 2010 01:38
Save a macro button onto a toolbar Belatedl but many thanks "trip_to_tokyo" wrote: EXCEL 2007 Try this:- 1. Office Button (top left hand corner). 2. Excel Options (lower right hand corner). 3. Customize. On the right hand side in here there is a section called:- Choose commands from: Click on t... 5 Jun 2010 13:37
Where is the number lock key on my HP Pavilion zv 6000???????? fn+num lk "Lars-Åke Aspelin" wrote: On Sat, 5 Jun 2010 00:14:32 -0700, deacongary <deacongary (a)discussions.microsoft.com> wrote: See subject question........ See pages 1-14 and 1-15 in the Maintenance and Service Guide that you can find here http://h10032.www1.hp.com/ctg/Manual/c0...
5 Jun 2010 12:31
can't "undo" to original document I accidentally hit Ctrl S and saved a document. Unfortunately, I meant to do a Save As, instead. Is there anyway to recover my original document? I haven't closed the file, yet. I know in Word you can "undo" multiple actions. Is it possible to do that in Excel, also? ... 5 Jun 2010 12:31
Formula Questions 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 the date has to find the date on work sheet2. Once the date is found the formula needs to check if anythin... 6 Jun 2010 07:16 |