| Thread | Last Post | Replies |
|
| Gantt charts | 25 Apr 2006 22:54 GMT | 1 |
Just starting to create a gantt chart. Any resource to walk you through a beginner level to more advance gantt charts ?
|
| Partial protection? | 25 Apr 2006 22:27 GMT | 2 |
I have a spreadsheet that I want to be read only. But it has a funtion in the first cell that when you click on it, it will sort for you one of 6 different ways. I can't protect the sheet cause then you can't sort. But I don't want anyone to change what's in the cells. Is ...
|
| Fix for problem opening/saving files | 25 Apr 2006 20:34 GMT | 2 |
A recent Windows update has been causing many people problems opening and saving files. See the following for possible solutions: http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=micro soft.public.word.application ...
|
| Memory failure : Getting Sum to work | 25 Apr 2006 19:35 GMT | 5 |
I added the number 200 3 times (vertical) . Got the correct answer but i can't seem to get the answer to appear in the total cell. Just the formula shows up . What am i doing wrong ?
|
| Excel function button in spreadsheet | 25 Apr 2006 19:33 GMT | 1 |
Sorry, not very efficient in Excel, but have the following problem : When clicking on a function button on an existing excel sheet, it tells me "file could not be found, check the spelling of the file name, and verify that the file location is correct...
|
| Why are columns in some Excel files numbered instead of lettered? | 25 Apr 2006 18:45 GMT | 1 |
How do I change column headings in existing files created by other people back to letters instead of numbers? As a rookie Excel user, it is a lot easier to create formulas by signifying cells with a number for the row and a letter for the column.
|
| counting no of "text" cells | 25 Apr 2006 18:33 GMT | 4 |
Apols, I've tried a number of things but cannot find the answer, all refer to numeric values, which this isn't. Have a column of 70 text cells (I've range-named it "names") I need to count the number of names, not at the bottom of the column, in a
|
| Date Sorting problem in Excel | 25 Apr 2006 18:22 GMT | 1 |
There have been many posts on this issue, but I am trying to figure out the best/simplest solution. We use a propriatary software to export a report results into Excel spread sheet.The resulting spread sheet has a TEXT/General format for all columns by default.
|
| Vlookup Question? | 25 Apr 2006 17:42 GMT | 5 |
I have the names of golfers in B2:B50. I have their scores in C2:C50. In C52 I am using the "Min" Formula to return the lowest score for the week. In C53 I would like to return the the name that coincides with the
|
| excel | 25 Apr 2006 17:26 GMT | 1 |
I need to know if there is a way to put a scroll bar with text, as a pull down menu in a cell.
|
| Password recovery - excel 2003 | 25 Apr 2006 17:24 GMT | 5 |
Hi there. I've got a couple of excel 2003 spreadsheets that have been password protected by an ex-employee and no older backups are available. Can anyone suggest some reliable software to recover them , ideally free
|
| Calculate the beginning of the week | 25 Apr 2006 16:50 GMT | 1 |
I want to have a field in excel that gives me the "week of" date. For example, today is 4/25/06. The field would show the "week of" 4/23/06 because that is the date of last Sunday.
|
| Query two fields | 25 Apr 2006 15:58 GMT | 1 |
I need to compare two addresses to see if the address 1 is contained in Address 2. If true, I do nothing, if false, I return the record/row containing the different addresses. Note: I need to complete this for a report at work today
|
| Here is fix for Windows file problems | 25 Apr 2006 15:25 GMT | 2 |
If you have installed a Windows update and started having problems opening, closing, copying files, see: http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=micro soft.public.excel.misc&mid=1fe358b1-c8eb-4217-ad2a-4b9fcf741916
|
| Numerical Value to text | 25 Apr 2006 15:24 GMT | 7 |
Ive just started working with excel sheets, literally today. I remember back in university I once made a worksheet in which numerical values (1,2,3,etc) corresponded to a text value. So 1= concept
|