| Thread | Last Post | Replies |
|
| Lost my built in menu bar in excel 3 | 05 Nov 2006 12:09 GMT | 3 |
I have lost my built in menu bar in excel 3 File-Edit-View-Insert-Format-Tools-Window-Help
|
| Tip(s) from Excel User Conference | 05 Nov 2006 03:16 GMT | 15 |
West Coast Excel User Conference October 25 2006 - October 27 2006 I know Bob U. and Jon P. were presenters. Did anyone else attend the conference?
|
| Time difference - again! | 05 Nov 2006 01:52 GMT | 2 |
Sorry I know it has been covered but nothing works for me. Maybe it's my formating. Cell A1=10am (format is '*1:30:55 PM' from the Format Cells dialogue box - Time/Type)
|
| Sum Cells Based on Condition (2 problems) | 05 Nov 2006 01:46 GMT | 3 |
I have a spreadsheet that is used to calculate a persons YTD Gross Income. The data contains the SS#, Name, Addr, HireDate, and YTD Gross. The sheet is set up as such: A B C D E
|
| Compare | 04 Nov 2006 23:15 GMT | 8 |
Ok This is the setup..... A24 -------------------------------------------------------- George Shirley
|
| Lost all my worksheet tabs on excel | 04 Nov 2006 22:36 GMT | 2 |
anybody know how to restore my worksheet tabs on excel File,Edit,View,Fomat,Tools,Data,Window,Help,
|
| smart tags | 04 Nov 2006 22:18 GMT | 3 |
my colleague and I both have Office 2003. The Smart Tags on my PC seem to be working differently to my colleagues. On mine,if any numbers have been stored as text, it flags them up with a smart tag and I can quickly convert them to numbers, however, on his PC, they are not ...
|
| How do I prevent saving an excel file if cells are blank? | 04 Nov 2006 20:40 GMT | 1 |
How do I prevent saving an excel file if cells are blank?
|
| NEWSGROUP MESSAGE URGENT | 04 Nov 2006 20:21 GMT | 1 |
I notice that Bob Philips also has a letter with more than 2.04 million lines. What has happened here to create them? Jonah
|
| Make Function ignore 0 and error values | 04 Nov 2006 20:03 GMT | 3 |
I am trying to make the average function ignore 0's and errors. The following array formula works to ignore the 0's, but I got stuck trying to make it ignore errors. =AVERAGE(IF((G3:G20)<>0,G3:G20))
|
| looking to create a time + text history when a button is clicked? | 04 Nov 2006 16:40 GMT | 1 |
I'm hoping to have a log sheet, that will record the time and write a message when a task is completed by simply clicking on a button with the same name. Similar to the History page but permanent and recording the set text each time.
|
| in Excel, how to put gridline every ten rows | 04 Nov 2006 16:07 GMT | 8 |
How can I set up the procedure (formatting, macro, whatever) to place a gridline every ten rows on my spreadsheets? Or, how can I get it to put a gridline at every TOTAL line, when I apply subtotals? I have EXCEL 97.
|
| Can't Access Paste Special Anymore | 04 Nov 2006 16:06 GMT | 5 |
I used to be able to right-click on a cell, copy then right-click on another cell and choose from a dialog box either 'all', 'formulas', 'value', 'formats', etc., but now all that comes up is a dialog box asking if I want to paste as 'Unicode Text' or 'Text'. How do I get back ...
|
| How to count occurrences where 2 columns are required to be true? | 04 Nov 2006 14:26 GMT | 1 |
I am trying to count the number of occurences when conditions in two columns are met. I can count each individual column values with =countif function. But, I can't seem to count only if a value is found in both column A and B to be true. Please see example below.
|
| Is there a better way? | 04 Nov 2006 14:13 GMT | 1 |
Not sure if there is a better way of doing this ... I have a workbook comprising several sheets. The main sheet on which I input data lists projects that are started and finished throughout the year. In simple terms, the columns are: Date Started, Project Owner, Brief
|