| Thread | Last Post | Replies |
|
| Comparing Columns to each other | 25 May 2007 20:17 GMT | 2 |
I had a question about comparing columns....is it possible to compare columns to each other. So, for example... Column1 Column2 Apple Orange
|
| Importing problems | 25 May 2007 20:16 GMT | 3 |
I am attempting to recreate my address book as an excel file I have the precious version in an address book program it's an address book file. Any suggestions?
|
| formula question | 25 May 2007 20:02 GMT | 3 |
I am working on a spread sheet where I am calculating the percentage of retail markdowns. I am using the formula below: =SUM((H3-J3)/H3) But, in some cases j will be empty, so I want it to use i instead. Is there
|
| loading | 25 May 2007 19:59 GMT | 2 |
in office 2007 since I installed it If I load a file by double clicking on it from within my My Documents folder Excel starts and loads an empty page. If I start Excel and then go to File/Open the Excel file loads perfectly. Does anyone have an idea as to what is happening?
|
| Time Stamp | 25 May 2007 19:51 GMT | 2 |
We are entering data in a call. We want to capture the time that the data was entered. We have tired the now() function and the today() function, but these change on recalculation. Can anyone think of a way to capture the time?
|
| How do I prevent excel from opening with a blank worksheet? | 25 May 2007 19:50 GMT | 9 |
I rarely start a new spreadsheet from scratch...most of the time I want to just open Excel, but with no blank/template loading automatically. Where do I set this switch...maybe in the Registry??! thanks in advance
|
| Help Solving a problem | 25 May 2007 19:32 GMT | 1 |
I have a total number of cubic meters (CBM), and need to figure out the best combination of shipping containers that leaves the least amount left over. Here is an example: Total CBM = 311
|
| column names | 25 May 2007 19:13 GMT | 2 |
the column names in my spreadsheet are numbers (instead of letters). how do i switch it back?
|
| Return the values for the same names across a row of data | 25 May 2007 19:04 GMT | 7 |
Microsoft 2003 - I have a row of data that contains user names. Below this row is an "x" in each cell that meets a certain critieria that I already filled out. Now I want to combine all the names in the first row so there is only one name, not multiples of the same name, and ...
|
| Macro using autofilter | 25 May 2007 18:54 GMT | 5 |
I am building a macro so that people in my organization can produce reports based on a customer satisfaction spreadsheet database. I need to be able to pull data from the customer responses based on date ranges and I am thinking that the autofilter is the best choice for this. ...
|
| Mail merge | 25 May 2007 18:53 GMT | 1 |
When I do a mail merge with postcard templates every third data line is removed. Why is this?
|
| How do I enable copy in a protected workbook? | 25 May 2007 18:39 GMT | 1 |
I have a password protected sheet in Excel 2003 with locked cells. Copy and paste is disabled but I'd like for this to remain available. How do I get both protected cells and the copy paste function to work?
|
| Conditional formatting: format when range of cells are blank | 25 May 2007 18:24 GMT | 1 |
When using the conditional formatting is there a way to determine if a range of cells are empty? Is there a way to determine if a named range is empty? As well, is there a way to use AND/OR when using conditional formatting? Chad
|
| Pivot Table #DIV/0! Error | 25 May 2007 18:21 GMT | 3 |
I created a Pivot table and set all fields to be numeric. After that I went to the Field Settings and selected AVERAGE and recieve the error #DIV/0!. Is there anyway to get around this printing?
|
| How do you stop excel removing the leading zeros in a cell? | 25 May 2007 18:16 GMT | 2 |
I need the leading zero to be actually in the cell so formatting the cell using custom or special will not work as these seem to be for display only. The cell cannot be formatted for text or you cannot put an apostrophe before the number as the spreadsheet is read into a database ...
|