| Thread | Last Post | Replies |
|
| Wrapping text | 15 Feb 2008 23:28 GMT | 5 |
We have Microsoft Office 2007 running on Windows XP Pro. We use excel a lot entering text into different cells. We frequently have problems with text not want to wrap within a cell. Have you seen this or do you need to see a specific example?
|
| Formula Help | 15 Feb 2008 22:26 GMT | 1 |
Not sure how to do this, I need to add Column A that equals "abc" then multiply column B by Column C. There could be up to say 12000 cells in column A. So what I need to do add up anything in Column A any cell that equals the text value of "abc" then multiply the cells in ...
|
| Cannot check the check mark box in cell | 15 Feb 2008 22:24 GMT | 1 |
I created the check mark box, renamed it, and then saved it off. I basically want to use it for a survey, but when I go to click on the box; it highlights the entire text box and that is about it. Thanks for any help!
|
| networkdays function | 15 Feb 2008 21:57 GMT | 2 |
I'm trying to use the networkdays function to return the number of working days between 2 dates which seems like the correct function however when I use 2 dates, 7 days apart, the function returns 6 rather than 5 i.e monday to friday working. Am I doing something wrong? Thanks in ...
|
| I have a 38 digit # and I want to subtract 27 thru 32 from 33 thru | 15 Feb 2008 21:49 GMT | 2 |
any way to do this. The 38 Digit # is in one cell. Thanks! Bill
|
| Update link cells without open up source document files | 15 Feb 2008 21:25 GMT | 1 |
I got "#REF!" error messages on linked cells after choosing "update" option when opening up a file. This error messages will disappear and linked info updated after source document files are open. How can linked cells update automatically without opening up source doc files?
|
| Q.1 | 15 Feb 2008 20:54 GMT | 3 |
how to format a cell in a 'sorting column' so that every time i put an entry in the cell it will be sorted in its right position- in the column, i guess it need to be after I finish entering all the other cells in the row? how please?
|
| Wildcards with numbers....* & ? not working | 15 Feb 2008 20:43 GMT | 2 |
We have a time sheet program and for what ever reason it rounds down at five rather than up, like most of us are taught growing up. For example, if we end up with a time in decimal format of 1.25 hours. it rounds this time back to 1.2. From 1.6 and above it rounds up. Now this ...
|
| Excel code to call a macro when a certain value in a cell is selected. | 15 Feb 2008 20:18 GMT | 4 |
I am trying to write code that will call a macro when the value of cell is equal to a defined text. Example: If C28 = "Remind", then Call Macro_Name.
|
| LookUp | 15 Feb 2008 20:10 GMT | 4 |
I am trying to use vlookup function for the first time: One sheet has table as below. I've named the range for lookup as "RB" (Region Balance). Region koef #Fl Hrs Amount
|
| can u make a text in a cell to blink , or change it's color? | 15 Feb 2008 19:40 GMT | 2 |
|
| Average is dependent on conditions | 15 Feb 2008 19:32 GMT | 3 |
I have 30 months of data (from Sep 2005 to Dec 2007) laid out in columns. Rows are different names of employees. I want to create averages for the each year from Sep to Aug so I that in the end of August there would be Sep 05 to Aug 06 average, Sep 06 to Aug 07
|
| Looup Value and Return a Range | 15 Feb 2008 18:46 GMT | 1 |
I want to lookup a value in column E and if it matches my lookup criteria I want to return all the information in the corresponding row. A=acct number B=acct status
|
| Creating New Formula | 15 Feb 2008 18:35 GMT | 1 |
I have a list of individual mobile numbers and a second list of the same numbers but with each number duplicated several times. On the list with the duplicate numbers I have their tariff info. I need to search for the individual numbers on the duplicate numbers list and add the ...
|
| Excel is rounding up my formula result | 15 Feb 2008 18:15 GMT | 4 |
I am new to this whole process and am spending too much time trying to determine how to fix my problem. Any help would be greatly appreciated. I am simply trying to divide a number by another and obtain the exact result of such expanded to two decimal places. For instance 419.00 ...
|