| Thread | Last Post | Replies |
|
| VLOOKUP Formula | 04 Feb 2008 16:28 GMT | 7 |
I have a workbook, one sheet for purchase orders, which collects data from the Stocklist sheet (excel 2003). I want to insert a vlookup formula into cell B10 of the PO, dependant upon a code i type into cell A10 of the PO, which brings across the corresponding description, then ...
|
| How to open microsoft xl | 04 Feb 2008 16:04 GMT | 1 |
I just installed microsoft viewer 2003. When I try to open it, I was able to find microsoft excel listed on my start-program menu. When I click on the file menu, there is a dialog box that pops out and ask me for the file name. I tried xlviewer.exe and then download.microsoft ...
|
| how do you archive a file | 04 Feb 2008 13:38 GMT | 1 |
how do i archive files on office 2003
|
| Graphs | 04 Feb 2008 12:22 GMT | 1 |
I have lots of graphs to do and I don't have a good knowledge about them, is there any website for teaching how to make graphs?? (on excel) thanks, shiblie.b
|
| Cannot copy the merge cells into another sheet | 04 Feb 2008 01:47 GMT | 4 |
I m a new user of excel. Recently i have working on excel.When this problem occurs. My problem is that I have a data in one sheet. Which has cities wise data.And some cells are merge. I have to copy the one city (NEW DELHI)
|
| count | 03 Feb 2008 23:35 GMT | 7 |
I have a table that shows all the employees that have been termed. I want to count how many different codes each manager has used in a given amount of time. ie: bob termed 10 employees using codes 2,3,5,9,12,2,5. what formula can I
|
| no more html o 2007? | 03 Feb 2008 22:59 GMT | 2 |
Can you no longer save to a html format for a workbook? All I see is the ability to save is to mhtml or mht.
|
| Help req: how to conditional count with words in cells based on their formatting | 03 Feb 2008 21:25 GMT | 12 |
I have a text based spread sheet that counts the number of words at the end of each row. I want to be able to bold selected words and have these excluded from the count at the end of the row e.g. frog cat dog (If cat is bolded then the count at the end of the
|
| Question about number of possible cells in Excel. | 03 Feb 2008 18:53 GMT | 2 |
The book I'm reading says Excel has 255 worksheets, 256 columns and 65,536 rows. It also says Excel has 16.5 million cells. Is that correct, and if so, how is that calculated? Another thing...it says columns are labeled A through Z, AA through AZ, and
|
| inventory/Stock book | 03 Feb 2008 18:01 GMT | 2 |
I am trying to make a stock book to manage the stock, INs Outs, ourall value etc. do you klnow any link where I can get this spread sheet ready made? cheers
|
| Using <PgDn> changes active cell. | 03 Feb 2008 15:43 GMT | 1 |
According to my book, if I make C11 the active cell by selecting it, then hit <PgDn> to navigate the worksheet, C11 should still remain the active cell. However, that isn't the case. When I press <PgDn> my active cell reference changes to C40, then C69, etc. Could you please ...
|
| Conditional formatting - Excel 2000 | 03 Feb 2008 13:48 GMT | 2 |
How do I get around to add more than just 3 conditions to a cell? I need to be able to do much more like if the input into the cell is between 1 and 2 then fill color red, between 3 and 4 then fill color orange, between 5 an 6 fill color green, between 7 and 8 fill color blue and ...
|
| 2002: Conditional formatting question | 03 Feb 2008 13:43 GMT | 9 |
I am using Excel 2002. I want to set up a conditional format that look for a piece of text. Anyplace in column A (range A:A) where the word "work" in any format (eg. WORK, Work, work, WoRk, work_, work-, etc.) is found I need the background color changed. Other than the search ...
|
| Insert Row | 03 Feb 2008 13:28 GMT | 1 |
Is this possiable, I have a column that I want to insert a blank row if the number changes, see example below 111 111
|
| Combining the Contents of Columns | 03 Feb 2008 12:52 GMT | 7 |
I could really could use some help to combine the contents of Column (A ) and (B) into Column (C) I'm not very knowledgeable with Excel or using formulas. The example I have is: First Name in column A Last name in Column B I want to put First and Last name into one Column C ...
|