| Thread | Last Post | Replies |
|
| merge data from one workbook to another | 06 Dec 2005 01:02 GMT | 1 |
I am trying to import data from one workbook to another, but need to do two things in this process. I need to compare data and only insert what is missing. IE in one column of one workbook there is a group of client ID's. IN the other workbook there is a sales associate for that ...
|
| merge from excel to word | 06 Dec 2005 00:43 GMT | 4 |
I can't figure out the envelop merge from excel to word. I can do it at work, but I have a different virsion at home. The home virsion (whatever comes with windows XP) is not user friendly at all. By now I could have hand written everything.
|
| HELP with spreadsheet | 05 Dec 2005 23:29 GMT | 1 |
Does anyone have access to a simple PROFIT and LOSS spreadsheet ?.:(
 Signature taichi ------------------------------------------------------------------------
|
| Looking for a function...MIN IF ? | 05 Dec 2005 23:14 GMT | 6 |
Here is my problem : On my sheet, I have to 2 columns of n lines. The first column contains n numbers. The second one contains n boolean values ('true' or 'false').
|
| bills, invoices | 05 Dec 2005 22:38 GMT | 3 |
I need to create an invoice for my company
|
| outlook view to normal view | 05 Dec 2005 21:23 GMT | 2 |
I open an Excel file and it is in "outlook view" . How can I change it back to "normal view"? Thanks
|
| flag cells | 05 Dec 2005 20:57 GMT | 1 |
I am working with zip codes and when certain (around 25) zipcodes are entered, I need for the format of the cell to change colors. How can I go about doing this?
|
| Nested Function Question | 05 Dec 2005 20:21 GMT | 2 |
I would like to write a formula which would find either of two words, such as David and Grace, in a selected cell. =IF(C11="David",D11,0) etc., etc. can be made to work for either word, but how can I get the second word (the either /or word) into just one formula?
|
| This should be so easy... | 05 Dec 2005 20:13 GMT | 6 |
I have a workbook where on Sheet 2 I have certain cells =to cells on sheet 1. If those cells are blank on sheet 1, it is showing up as "0" in the cells on sheet 2. I don't want "0", I want blank if the cells are blank in sheet 1. What should I be doing?
|
| How to refer to current sheet in a formula | 05 Dec 2005 19:52 GMT | 2 |
I want to have a named formula which always refers to a cell on the sheet it is on. When I define the formula it is automatically changed to refer to the sheet active when I defined it. E.g. =$B$2*3 becomes =sheet1!$B$2*3. This is no good for use on sheet 2 where I want the
|
| Removing blank lines | 05 Dec 2005 19:30 GMT | 2 |
I have been deleting numerous lines of my database, but I am left with blank spaces. Is there a way inwhich all the blank spaces, which there are hundreds, can be removed by one click, with the following lines underneath
|
| how to open a spread sheet email | 05 Dec 2005 18:47 GMT | 3 |
Hi there, I was sent an email which is spread sheet set out but after i downloaded it, it said i had to find a programme to open it with but i have no idea how to do this. I hope someone can help me.
|
| How to test a cell to see if it is over a threshold? | 05 Dec 2005 18:01 GMT | 4 |
I have a column with Sales figures in Column A for eg. 5000, 3000 etc and I need to indicated whether they are above the bonus target of 4500. Is there a formula I can create that would give me the results ON TARGET or Below Target next to the sales figures in Column B?
|
| Rearranging aTable | 05 Dec 2005 17:34 GMT | 2 |
I created a worksheet consisting of two relatively narrow columns. But it's about 7,000 rows deep. I'd like to rearrange it so I'd have five sets of column pairs on a single page, so I could print it using one fifth the paper.
|
| "Blank" cells | 05 Dec 2005 17:31 GMT | 5 |
I've got a table in Excel where I want to do this: suppose we're in line E; I want to fill all the cells, from E2 to E10, for example, with blank values if E11 < 0; all the referred cells - E2 to E10 - contain formulas.
|