| Thread | Last Post | Replies |
|
| Pictures adding & removal | 08 Oct 2007 16:14 GMT | 3 |
I use a vba-button and function to add logos in a worksheet. Everytime I use this button, the old logo is being overwritten by a new one. I need to change the code so that the old logo is deleted before the new one is placed.
|
| High = 4 | 08 Oct 2007 16:10 GMT | 7 |
Someone help! I need to know how I would do this i want to creat a formula so that when i type in High it will equal 4 or Medium equal 2 or low equal 1. So for example: = IF(4,High;2, Medium;1,Low=()) - This doesnt work What i want is to add
|
| Find and Replace | 08 Oct 2007 16:03 GMT | 6 |
I'm using Excel 2003 with all latest updates. When I use the Find & Replace function, if I click on Find I have three options in Look In -- Formulas, Values, Comments. If I select Replace I only have the Formula option in Look In. Can anyone tell me how to fix this. I need to ...
|
| Formula Countif Index Match | 08 Oct 2007 15:55 GMT | 2 |
I'm using Excel 2003 and this is my first post to the discussion group. I'm trying to help a coworker and don't have a lot of experience working with formulas. I've searched the discussion groups, etc. and have tried several different
|
| Copy and Replicate exact formulas | 08 Oct 2007 15:08 GMT | 4 |
I have a range with formulas in, say A1:F50. I want to copy the exact formulas over to G1:L50, but if I select the range and copy and paste, it changes all the values in the formulas, when I want an exact replica, not adjusted ones? How can I do this? At the moment I'm doing
|
| Insert a letter in front of number in every cell? | 08 Oct 2007 14:50 GMT | 3 |
I have a whole column of numbers which I would like to add a letter to in the beginning. For example, if the cell has the number 2350, I would like to change the cell to B2350. How do I do this without manually changing the data on every cell?
|
| link text | 08 Oct 2007 14:49 GMT | 1 |
I have two sheets in a workbook. Sheet 1 has six columns of information about projects. One of the columns contains one or zero indicating status [open or closed]. Sheet 2 has array formulas that copy only those rows from sheet 1 that have open projects. In addition there is a ...
|
| ExcelMedic.com | 08 Oct 2007 14:43 GMT | 1 |
ExcelMedic.com can provide a full range of Excel solutions to fit your needs. ExcelMedic.com charges an hourly rate that is guaranteed to be 15 percent less than other
|
| Spreadsheet within a spreadsheet | 08 Oct 2007 14:26 GMT | 7 |
I have a series of documents (system function lists) in Excel that vary in column width. Above each of these, I have to insert a 'Header' that is 8 columns wide. When I insert this 'Header', it needs to fit across the table without changing the column widths (no matter how short ...
|
| Refer upper field | 08 Oct 2007 13:59 GMT | 1 |
Is there any function that can refer upper or beside field without defining specify field?For example,i'm select row A1,then i use Alt+G to select blank field,then the blank field will refer the value/text each of there upper field,example field A2 refer A1,A3 refer A2,A4 refer ...
|
| Is there a keyboard shortcut for using Paintbrush? | 08 Oct 2007 13:54 GMT | 8 |
 Signature Mike
|
| where is the crystal reports wizard in MS Excel 2007? | 08 Oct 2007 13:27 GMT | 2 |
Is there an easy way to import data into Crystal from within Excel 2007?
|
| Search and go to cell | 08 Oct 2007 13:26 GMT | 2 |
I have workbook of names and some information for them all. The first worksheet is a Contents page. On that contents page I want people to be able to enter in a persons name and have excel search (and goto, or bring the infromation to) a name/cell.
|
| Conditional Formatting - further assistance required | 08 Oct 2007 13:16 GMT | 2 |
I require to format 17 cells in a row ie: A1:Q1 to turn red, dependent on text being inserted in K1 Please help, Thanks
|
| IF(ISBLANK) with other criteria | 08 Oct 2007 12:51 GMT | 5 |
I use ISBLANK all the time as I don't like to see div or num errors in a cell :) I now want to add something to it, but not sure how ... The formula in CELL E6 is this =IF(ISBLANK(D6),"",LOG(D6)) ... But when I
|