| Thread | Last Post | Replies |
|
| Excel | 25 Nov 2007 17:19 GMT | 6 |
I have one column in excel sheet filled in dates from 1/1/2007 till 31/12/2007 in second column sales figures for each date I want a formula to sum all sales figures in June only moth or August month Please help
|
| Remove check box that came with web page copy? | 25 Nov 2007 15:25 GMT | 2 |
When I copy a web page with a table that contains check boxes into Excel, the check boxes gets copied into the work sheet and I can't figure out how to remove them! The check box just sits there and won't be deleted, even if I delete the cell that surrounds it. The same
|
| Formula Help Please!! | 25 Nov 2007 14:54 GMT | 9 |
I have a bunch of data in excel right now, and I need help writing a formula that will automatically do subtractions. Here is an example to help explain what I mean... In column A I have 400.00. In column B I have 60.00, which means I want
|
| euro-sterling exchange rate | 25 Nov 2007 14:52 GMT | 2 |
I have a spreadsheet i use to convert pound sterling to euro's. I want the spreadsheet to automatically access the current exchange rate from the internet for pound into euros so that i can push a button that would update a cell with the current value
|
| functions | 25 Nov 2007 14:27 GMT | 5 |
a=constant suppose 600000 b is reciept c is the balance
|
| Formula Editor Result Different than the one in the Cell? | 25 Nov 2007 13:50 GMT | 1 |
I have a bit of a strange problem with Excel, in that I can't seem to tell if my formula isn't correct in concept, or if there is something wrong with Excel? So before I go in to the details of the formula, I figured I'd show
|
| suddenly I cannot open any office 2003 files | 25 Nov 2007 13:43 GMT | 1 |
I can open excel and publisher and use all functions including print. But if I save it then try to re-open, the program freezes. I know the files are good as I can access them from my laptop on a wireless network. Word will not even open - it just freezes (with an hourglass). ...
|
| Adding alpha data | 25 Nov 2007 13:04 GMT | 1 |
I have several staffplans that I use to add weekly hours worked. Is it possible to set up a formula that will add together staff names to give me a total number of times they appear within the plan?
|
| Software Malfunction | 25 Nov 2007 11:40 GMT | 1 |
When someone knows that her software is not functioning correctly, there should be an option in contacting support where the person does not have to pay to get her question answered. Microsoft could keep a database that included problem areas that are showing up in the new ...
|
| Trace Dependent - off worksheet page reference | 25 Nov 2007 10:51 GMT | 1 |
when using the 'formula auditing' toolbar 'trace dependent' button and the 'other worksheet' icon comes up to indicate a cell/s on another worksheet are dependent upon the cell chosen, does anyone know how to find the dependent cells on the other worksheets?? Knowing there is a ...
|
| Vertical to Horizontal | 25 Nov 2007 04:11 GMT | 3 |
I have headings in one column. How do I get the headings in the horizontal (one heading per column. For example: I have three heading in row a1, a2, and a3. How can I get the same headings in column A, Column B, And Column C with out cuting and pasting each one individually. ...
|
| auto fill current time | 25 Nov 2007 03:23 GMT | 3 |
I need help with this one, I can't find (figure out) the answer myself. I have a worksheet that use at work, I want to automatically place the current time into a cell, whenever I place data into the cell 3 rows up. I want this 'time cell' to automatically update every time I ...
|
| HELP Drop Down Lists | 25 Nov 2007 01:50 GMT | 4 |
Hi All, I was wondering is some one could help me out on using a dropdown list. What im trying to acheieve is that one of the work sheets contain 1000's of Items
|
| problem with drop down lists | 25 Nov 2007 01:22 GMT | 1 |
I have a workbook set up that uses drop down lists. The drop down lists are stored on last sheet of the workbook (say sheet 10 of a 10 sheet workbook). I ended up breaking up the workbook into ten different workbooks using copy and paste. In each of the workbook I copied the ...
|
| save form | 24 Nov 2007 23:02 GMT | 2 |
Hello, i have a question about the CSV(Ms-Dos) save type. When i save an xls file as the CSV form, when i open it again, it doesn't have the CSV format, but it still has the regular one. Column lines, are not being converted to " ," .Do i need to make any other adjustments ...
|