| Thread | Last Post | Replies |
|
| Differences between Excel 2003 & 2007? | 27 Apr 2007 20:31 GMT | 5 |
I'm taking a course in spreadsheets application. The class uses a textbook on Excel 2003 & all the college computers also use that version. So I ordered the software for Excel 2003 over the internet but instead received the 2007, with the explanation that the 2003 is
|
| Average | 27 Apr 2007 20:00 GMT | 10 |
In cells G21 and J21 are grades calculated from another sheet in the same wrokbook. The grades are NOT numbers but letters: E+, C, D+, ..... (letter system) In cell K21 i want to have the average of the two cells G21 and J21.
|
| Calendars | 27 Apr 2007 19:35 GMT | 2 |
Hello Folk's, Is it possible to insert a calendar in a specific cell. For example, if cell d4 requires a date, I would like to know if a calendar could be activated when cell d4 is activated that allows the users to select
|
| If condition | 27 Apr 2007 19:28 GMT | 3 |
I have 2 workbooks: wkbook1 and wkbook2 Each workbook has only one column (column A) with content. There are 10 rows with numbers in them. Sometimes these rows will vary depending on the updates. I.e. wkbook1 may have 5 rows of content, but
|
| text list | 27 Apr 2007 18:26 GMT | 2 |
I have the following list: AAA AAA AAA
|
| solver cannot take "if "function? | 27 Apr 2007 17:45 GMT | 4 |
I use solver to calculate the minimum with the following equation x1+n1*y1+o1*z1+x2+n2*y2+o2*z2=Min! shipping costs should only be included of the shop is used!, therefore a if-the function is used: Cell x1(and x2) contain the function if(or(n1>0;o2>0;10;0) thats adds the ...
|
| Conditional formatting macro | 27 Apr 2007 14:57 GMT | 1 |
Help. I would like to know if it is possible to have a macro that changes the colour of a cell dependant on the number or text within. eg
|
| Excel Worksheets collection | 27 Apr 2007 14:52 GMT | 1 |
Greetings, all: I am in the midst of teaching some C# and I do not have Excel in front of me, but a student posed a question about how to refer to a given worksheet inside a workbook.
|
| saving a workbook to disc | 27 Apr 2007 14:12 GMT | 4 |
I am trying to save a workbook to a disc so that I import it too my laptop at home. Am using Excel 2003, and I cannot find options for saving to a disc, just insstructions to 'save"
|
| Calculating Week Numbers | 27 Apr 2007 13:25 GMT | 10 |
One of the fields in an Excel timesheet I use calculates the current week number. The formula is : =ROUNDUP(((Q9-DATE(YEAR(Q9),1,0))/7),0)
|
| Excel: Remove characters from cells using wildcards | 27 Apr 2007 12:45 GMT | 8 |
Can you anyone help me with this problem please? I have a column of data like the one below and I would like to remove the the front part, (x) from the cell, but I don't want to remove the parts in bracket that come later in the cell, for example
|
| How to add values? | 27 Apr 2007 11:22 GMT | 1 |
I have a long list in excel where the Number can occur in several different positions with diffrent Value. I want the Number to only occur once and the Value of the different positions added.
|
| stoping duplication in drop down list | 27 Apr 2007 08:24 GMT | 3 |
Im using a simple loop to check part od a column an add thecontents of its cells to a dropdown list. The code is below rowno = 9 Do Until IsEmpty(ActiveSheet.Cells(rowno, 2).Value)
|
| sumif with >or< condition | 27 Apr 2007 07:45 GMT | 8 |
I have 6 numbers in cells a1..a6. Some are positive and some are negative. I would like to total up only the numbers that are > 20000 or <-20000. This formula works for > =SUMIF(A1:A6,">"&20000,A1:A6)
|
| CSV file into Excel....still need help please ! | 27 Apr 2007 05:39 GMT | 1 |
Unfortunately I lost the info I had previously gotten which was to make a change somewhere IE, Excel or ? and then when you choose CSV as your file type
|