| Thread | Last Post | Replies |
|
| Today Function | 10 Feb 2008 19:26 GMT | 1 |
I created a calendar using conditional formatting that runs with the today function. Past days are red, current day black and future days green. Can I create a web page that still utilizes the today function.
|
| formula | 10 Feb 2008 18:11 GMT | 2 |
Can anyone tell what is the formula for add 1+090 plus 2+090 (please)
|
| Dynamic Named ranges in formulae | 10 Feb 2008 15:23 GMT | 4 |
I have a named range 'CountRecords' created by the following :- =OFFSET(RecordOfRounds!$A$1,52,0,COUNT(RecordOfRounds!$A:$A)-5,1) which in the current sheet is the range A53:A80 - this is displayed surrounded by a blue line when I type 'CountRecords' into the 'Name Box'
|
| Formula help * | 10 Feb 2008 12:58 GMT | 3 |
Office 2007 I am trying to display in a cell the last value in a selected column. Numbers are added daily to this column but I need this specific cell to show the last entry at all times - any ideas or help would be appreciated Thanks in advance Bryan
|
| Code to have cells in the row formatted "Italics" when combo box value is set | 10 Feb 2008 12:52 GMT | 5 |
Anybody know the VB code to have cells in the row formatted "Italics" when a combo choice value "EUR" left of the cells is set? Column A B
|
| Using variables as parameters of function | 10 Feb 2008 10:13 GMT | 2 |
I got a little problem with my Excel function and cannot solve the following: Let's say A1 shows "D1". D1 contains 10.
|
| Strange Excel 2003 Grouping Problem | 10 Feb 2008 01:38 GMT | 2 |
Hey all, Something is happening that is strange on my clients computer. Whenever she opens more than 1 excel document (lets say she opens 2) they are automatically grouped on the task bar.
|
| range names across tabs | 10 Feb 2008 00:54 GMT | 1 |
When a sheet of workbook A is copied into workbook B, range names of the sheet are also copied, however workbook B doesn't seem to reqocnize those imported names. How can I make workbook B recoqnizes them? Thanks,
|
| time columns not adding correctly | 09 Feb 2008 22:48 GMT | 2 |
Please Help I am trying to calculate total available time for my job and am importing files. When importing to Excel and adding 3 columns, the data in the 4 th column is not adding up. h:mm:ss to total h:mm:ss. Also, some of the colums are less that one hour ( :15:22).
|
| Get rid of Automatic Links when opening | 09 Feb 2008 18:55 GMT | 2 |
I received an excel workbook from someone else and it has our list pricing on it, it has 4 tabs on the bottom with different pages showing different pricing. It was updated from another workbook within their company so it has automatic links in it. Obviously from where I am it ...
|
| CSV File Problem | 09 Feb 2008 18:33 GMT | 7 |
Can any one explain why the following problem occurs please? A colleague has a small list of data which is a csv file exported from SQL. Column One is a serial number from 1 to 29. Column 2 is a number of transactions which have occurred.(it should look
|
| recover an excel file that was accidentally over written | 09 Feb 2008 18:15 GMT | 3 |
I had a user this morning who accidentally overwrote one of our excel files with another one. Is there any utility out there that can help me recover this? Thanks
|
| 123 files | 09 Feb 2008 13:19 GMT | 4 |
Is there any way to open Lotus 123 files in Excel?
|
| Please help with subtraction formula | 09 Feb 2008 11:07 GMT | 7 |
I am trying to find a formula that will allow me to subtract .07 from each products sell price in an order form. The sell price changes every week but the .07 deduction is always a constant. Is there a way that I can enter a formula that will address the price change in each ...
|
| Lotto template | 09 Feb 2008 07:49 GMT | 3 |
Hi, I have arthritis in both hands and find it difficult to write with a pen. Does anyone know of a template I could use to fill in Melbourne Saturday night lotto forms?
|