| Thread | Last Post | Replies |
|
| Can't Access Add-Ins | 23 Jan 2008 09:55 GMT | 1 |
Ijust upgraded from Office 2003 to 2007. I had in Excel an add-in that Federal Express had given me (that opened upon launching Excel) which would allow me to bulk track large sets of numbers in a sheet. I can see in Excel Options that the add-in is still there and loaded, but I
|
| Modify a UDF please? | 23 Jan 2008 09:40 GMT | 2 |
Could this be slightly modified please: Function ConCatRange(CellBlock As Range) As String Dim Cell As Range Dim sbuf As String
|
| How to delete blank worksheets | 23 Jan 2008 09:35 GMT | 1 |
My Excel 2007 Workbooks always have a blank Worksheet at the end which I am unble to delete. How do I prevent 2007 Workbooks from having this unwanted blank Worksheet and how do I delete it when it appears?
|
| I want to count the cell if contains 111 or 1111 | 23 Jan 2008 08:59 GMT | 2 |
I cant get this one, must have a comma in the wrong place.
|
| FORMULA | 23 Jan 2008 08:53 GMT | 3 |
DEAR FRIENDS, I WANT TO ASSIGN NUMERIC VALUE TO ALPHABET FOR EXP. A=1,B=3,C=5 AND SO ON UP TO Z AND THE RESULT SHOULD BE STORED IN THE NEXT ROW
|
| Referencing Cells | 23 Jan 2008 08:40 GMT | 1 |
I have several columns with dates and text. For example: 1A text 1B date 1C date
|
| Formula Help | 23 Jan 2008 08:39 GMT | 1 |
I need to set up a formula that results in an outcome based on the below chart. If the cell result is less than or equal to minus 2.50 the outcome is $0. If the cell result is wihin the range below the outcome is the corresponding dollar amount.
|
| Date changes mysteriously | 23 Jan 2008 06:59 GMT | 2 |
I am having trouble with cell referencing in a workbook. I have it set up so that I enter the date on the first sheet and then reference that cell on the following worksheets. This works on some of the worksheets but not on others. For some I get a #VALUE and for some it ...
|
| countif with variabel criteria? | 23 Jan 2008 06:57 GMT | 2 |
I'm blocked on a most likely very simple issue: I'm trying to have the criteria in the countif function refer to a cell, so that the formula gives a different result when that cell value is changed. I'm trying to compare times in the [hh]:mm:ss format, and the 1904 date system ...
|
| Editing an Office 2003 Document using Office 2007 | 23 Jan 2008 06:49 GMT | 3 |
One of our employees has Office 2007 installed on his laptop and the rest of us use office 2003. Whenever we e-mail him a document he states that he can not edit that document. Can someone please help with this?
|
| EXCEL 2003 | 23 Jan 2008 06:38 GMT | 1 |
If I want 39 = 7.0 how would I put in the formula I am trying to use it as Reading score conversion
|
| time seperation | 23 Jan 2008 06:34 GMT | 1 |
Hi Im getting knocked about with this one and sure could use assistance from someone in the know>>> I am applying the following formula =IF(C12>$W$5,(C12-$W$5)*24,IF(C12<$Y$5,($Y$5-C12)*24,"0")) to work shifts
|
| Multiple Logical Functions in one Formula | 23 Jan 2008 06:24 GMT | 1 |
How can we use multiple logical functions into one formula. We have 2 cells with numerical values which are a result of various cells in the sheet. We want the 3rd cell to be populated with "Excellent","Good" and "Needs Improvement" if various conditions are fullfilled according ...
|
| This should be easy, but can't find an answer...requesting your in | 23 Jan 2008 06:02 GMT | 1 |
Here is my spreadsheet: ---Date Range--- Conversion Date Descr1 Begin Date End Date Descr 10/25/94 ? 02/05/96 03/03/96 FY1997P1
|
| Replace the Find Function with a formula | 23 Jan 2008 04:46 GMT | 1 |
Is it possible to create a formula that is like the find function. I would like the user to be able to type the number or name of an item they are looking for and it will take them to the cell that has that name or number in it.
|