| Thread | Last Post | Replies |
|
| Subtracting | 09 Dec 2006 13:21 GMT | 2 |
Have two rows of statistics. Would like to subract the smaller cell from the larger cell, AND have the difference show up in the column with the largest number. Example 50 ( would like this cell to remain empty)
|
| Border Thickness | 09 Dec 2006 10:23 GMT | 3 |
With 2003, how can I reduce the point size of cell borders? In a form I created, the bottom border is the underline for the cell, and it is too thick in comparison with the underline function.
|
| Formula Question | 08 Dec 2006 23:38 GMT | 4 |
I have a in Col A a list of strings which are either 2 or 3 digit characters, and I would like to break them apart and put them in the 3 adjacent columns. AK
|
| Delete comments | 08 Dec 2006 23:26 GMT | 3 |
I have an excel document that contains some comments that I need to delete. However, when I attempt to delete them Excel locks up. Does anyone know why this is and how to stop it from locking up? Thank you in advance, Tony
|
| Using INDIRECT | 08 Dec 2006 23:17 GMT | 1 |
I have a spreadsheet with multiple references to an external sheet located on a website. Every one of these cells has the line something like: ='http://webpage.aspx/[EXCELBOOK]FirstPage!$A$1'
|
| MODE | 08 Dec 2006 22:52 GMT | 4 |
XL2002 SP3 Win XP HE i have a problem with MODE function which seems to return an incorrect value.
|
| PIVOT TABLE - GRAND TOTAL COLUMN | 08 Dec 2006 21:34 GMT | 1 |
I am unable to get the the grand total column on the right as shown below. I checked the 'Table Options' and the 'Grand totals for columns' is checked. So I am notsure what else to check. Thanks SJ Data
|
| Excel 4.0 Macro (XLM) Users - Your help is needed | 08 Dec 2006 21:08 GMT | 2 |
The Excel product team is gathering data on how people are using the Excel 4.0 macro language at the present time. If you or someone you know continues to use the Excel 4.0 macro language in current versions of Excel, we would appreciate it if you send a response for these ...
|
| Text Formula Question | 08 Dec 2006 20:26 GMT | 1 |
In COL A, I have a list of 2 and 3 digit charactors. I would like to seperate each string into the three adjacent columns. KQ AJs
|
| VB Wait | 08 Dec 2006 19:42 GMT | 2 |
Hi All (again), I now am faced with trying to make my macro wait for the new page to finish loading when an option is selected. My macro looks like this:
|
| Function doesn't run | 08 Dec 2006 19:27 GMT | 3 |
In my spreadsheet, I have the following function =VLookup(K16, zips, 2) However, instead of returning a result, the function remains in the cell. How do I fix this problem?
|
| Hidden Cell/Ranges Calculations | 08 Dec 2006 17:01 GMT | 1 |
Am using excel 2002 SP3, whenever I used Sum or Autosum function in range, it's still calculating and including my hidden rows & columns. Is there any way, options, add-ins or settings that can help me eliminate and exclude those hidden cells in my calculations? Any help will be ...
|
| Excel (Office 2007 B2TR) -- Password Protecting A Sheet -- Character Limit ? | 08 Dec 2006 17:01 GMT | 3 |
I have used really long passwords in Excel (Office 2007 BETA). My passwords are longer than 32 characters but not more than 64 characters. Two issues with B2TR seem to have occurred:
|
| Assigning a template to an existing file? | 08 Dec 2006 15:42 GMT | 5 |
Hi. I've got a bad feeling about this one. I have a .xls file that was exported from OpenOffice. As such, it lists no base template. I would like to assign my normal book.xlt to the file, but it
|
| Data searching | 08 Dec 2006 15:14 GMT | 3 |
I have run into a bit of a problem. I have a list of data in 2 columns. Column A are truck codes which are repetative and column B are time to which they receive the delivery docket. My question/problem is this... what formula would be the one to give me the last timestamp a ...
|