| Thread | Last Post | Replies |
|
| what is not run | 16 Mar 2007 15:56 GMT | 1 |
why this link not run <p><a href="modele.xlt annee_2007.txt">Année 2007</a></p>
|
| VLOOKUP | 16 Mar 2007 13:44 GMT | 2 |
I would like to return one set of results using 2 lookup values. For example when looking for a certain product by location, one may find, a list that contains 10 different rows of the same product, with the quantity in each location of the product in a separate row.
|
| How can I track inventory day to day? | 16 Mar 2007 13:32 GMT | 1 |
I work for a Gutter installation company and I want to keep track of my inventory on a day to day basis. Where as I put what we have in inventory on excel then in other colums i put material used daily and when I order new material and add it to inventory, so that i can see each ...
|
| Vlookup Problem | 16 Mar 2007 13:08 GMT | 2 |
I have a spread sheet, in which Col A has names of the users and Col B has the supplier names, with whom the user work. For example: Main Sheet:
|
| Formula for Months in a Year | 16 Mar 2007 12:44 GMT | 10 |
I have 2 date fields. 1 field has a start date, the other has an end date. I need a formula that will look at each date field separately and tell me how many months are left in the year based on the year that the date field shows.
|
| Capturing date changes | 16 Mar 2007 05:12 GMT | 1 |
I have an excel spreadsheet let me set up this example: Column A Column B Client Name Date Called ABC
|
| Version conflicts | 16 Mar 2007 04:30 GMT | 3 |
I have a problem that is very unusual. In essence, one of our staff can read an excel spreadsheet, modify it, and save it, and close down, all apparently successful. The only problem is that sometimes, not all the time, when she goes to read the file she has just saved Excel ...
|
| remove all formatting | 15 Mar 2007 23:31 GMT | 3 |
I select a range of cells (or the entire worksheet) and from the right-click menu selecting "Format Cells" and then selecting a format category (General, Text, etc.), but the existing formatting remains intact. How to remove all formatting from a sheet ? ( Having every cell in ...
|
| Time | 15 Mar 2007 22:19 GMT | 12 |
I want to calculate elapsed time. Column A has a start time. Column B has an end time (which may be the following day). I want a formula for column C which will give the elapsed time. The formula =B1-A1 doesn't work Thanks.
|
| Excel loading CSV problem | 15 Mar 2007 21:35 GMT | 13 |
My workplace just upgraded the software on our computers, now my coworkers and I have trouble loading CSV files. Using Office 11, (I believe we used to use Office 10) when we load a column of data that is formatted #-#, where
|
| import nultilinkage sql table into excel | 15 Mar 2007 21:33 GMT | 3 |
Again i have problem to import my sql table from Excel 2002. I intend to import few joining table and expected a data from the joining table as a result into my excel file. How can i do that ? Using Import external data, i only can import one by one
|
| ERROR WHEN CHANGING DISKS | 15 Mar 2007 20:42 GMT | 3 |
EVERY TIME I CHANGE MY 3.5 DISKS TO ACCESS OTHER FILES, IT READS THE PREVIOUS DISK AND I LOOSE ALL INFORMATION ON THE 2ND DISK I AM TRYING TO ACCESS. ANY SUGGESTIONS? THANKS
|
| Hiding $ on a spreadsheet | 15 Mar 2007 20:32 GMT | 1 |
I want to hide all dollar amounts on a spreadsheet prior to printing. It's an estimating spreadsheet and, for one purpose, I need to print it out with only items and quantities showing - no dollar amounts. Any way to hide cells that are formatted as dollars?
|
| Functions in charts | 15 Mar 2007 20:01 GMT | 2 |
Is is possible to use functions within charts (for example, if the chart title changes based on the value in a cell)? That way, if the chart data changes, the title also changes to reflect that. Any ideas?
|
| Excel 2007 | 15 Mar 2007 20:01 GMT | 2 |
Is there a forum setup for Excel 2007 complaints? I've got a few annoying issues... 1) The longer I leave it open, the more memory it consumes and causes system slow down and erratic behavior.
|