Threads Replies Last Post 125 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   If statement with dates I'm using Excel2003 with sp2. I want to track expiration dates of memberships I want to say: If m3 is blank make N3 blank and if M3 has a date, make N3 one year later. How do I do this? Thanks in advance, Vivian... 6 14.09.2006 07:27:50 count Hi - I'm hoping someone can help me - i have a list of employees (col A) who have been awarded $ amounts (col B). I need to count the number of times they have received an award... really would appreciate any help... thanks 00020084 1,500.00 00020084 1,000.00 00020084 500 00018539 1,000.00 00018539 1,500.00 00028267 1,000.00 ... 5 14.09.2006 13:34:02 find How can I setup a macro or use a function to find a column who's first cell is called "Addresses" then move the whole column to sheet 2. Is it possible? Puzzled ... 4 14.09.2006 09:29:30 How to sort with merged rows This is my delema. I have data that I need to input. At the same time I would like to have a blank area below each contact so that I can add notes. The first problem is that when I try to sort, excel keeps saying "this operation requires the merged cells to be identically sized" Even if I do get by that problem, how can I keep the notes and the contact/data info above it together when ... 7 14.09.2006 08:38:02 How do I force trailing zeros in an Excel cell? My accounting people have set up an excel spread sheet. woth part numbers. Many of them end in a "0". Ex; 2211.11520 and if you click on a cell with a number ending in 0 , the zero goes away on the edit line. When I copy and past this numeric column into other Excels or import into other applications the Trailing 0 is gone. Any one out there know a way I can convert or format or save this... 9 14.09.2006 07:43:32 Odd error - "This operation requires merged cells..." I'm cutting data from multiple sheets and pasting it into one, using Paste Values. This has been going OK for a while, but then when I cut data from one of the sheets, I get the error: This operation requires the merged cells to be identically sized. I have no idea what any of these terms mean. I don't know what "merged cells" are in this context, nor can I figure out where such a thin... 4 14.09.2006 00:54:50 Excel help I want 5% of one cell $ amount to automatically post to another cell. Is this possible? Or do I need to it manually and enter in the info in the new cell?... 4 13.09.2006 23:01:38 HOW DO I DELETE NUMBERS IN A COLUMN out of each cell I have a list of part numbers in a column, over 5000, and I need to change it while keeping other information in tact. For example 1025-00-128-5463 (Each of these numbers are in a cell which totals 1025-00-255-5656 5000. They are listed in a column.) 1025-00-233-5666 I need to delete the first four numbers and all the dash marks so they will look lik... 3 13.09.2006 20:23:02 Transpose a variable length list into Excel / Access Table Example given of a variable length (library) list, but which may actually be 1000 long. How can I transpose the data into a Table in either Excel or Access? LC Control Number 79013607 Published/Created "New York Seabury Press, 1978, c1977." Personal Name Boros, Ladislaus, 1927-1981. ISBN 816404402 Dewey Class No. 248/.48/2 LC Control Number 76007353 Personal Name Boro... 12 13.09.2006 18:37:09 merging data from 1 excel file, into a master excel file I have 2 spreadsheets - a master spreadsheet and sheet #2. Sheet #2 contains all of the information from the master (with the same exact columns), plus new rows that are inserted throughout. The first column of data uniquely identifies each row. Most of the rows are identical in both, with some tweaks to the master. Therefore, I do not want any cells in the pre-existing rows to be ov... 3 13.09.2006 17:39:02 Export from Excel to Word I have a 20 page Excel document that has a LOT of formating involved, it is text not data. Is there a way that I get it into Word without having to redo all the formatting? It is 11x17, landscape. ... 3 13.09.2006 16:30:28 Is there any way of calculating a running total within a single cell in a column Can anyone help with this query? e.g. I want to work out how many people are working at any time in a 24 hour period. The number of people rostered on differs each day of the week. Monday Time No. rostered on 6.00 2 7.00 2 8.00 2 9.00 2 10.00 (and so on) Can I add additional staff number in my 'no. rostered on column' by just entering the... 3 13.09.2006 12:22:01 Adding rows in Excel worksheets and 'deduping' Can anyone help please? I have a table of staff members and tasks set out as follows (the real one is a lot bigger) Task 1 Task 2 Task 3 Task 4 Total Staff member 1 1 2 3 1 7 Staff member 1 2 4 1 5 12 Staff member 3 1 3 5 4 13 Staff member 4 1 2 4 2 9 staff member 4 3 1 2 4 10 Staff member 5 1 3 3 5 12 Staff member 6 4 4 1 1 10 Staff member 6 3 2 3 2 10 I would like this t... 21 13.09.2006 11:34:15 How do I easily divide an excel list of names/addresses among 6 pe I am very new to Excel and need to divide an excel spreadsheet with 250 names, addresses, dates, etc between 6 people in an order of wedding date. Is there a really easy way to divide the list up so that each of the 6 people gets the next name on the list? ... 5 13.09.2006 11:05:02 WHY I GET " CALCULATE" MESSAGE i get the calculate message in status bar, i copy the formula in one perticular sheell and then paste this to some other shell but the formula is not applied to other shells, it shows always the first copied shell value to forth comming shells in status bar show the message " calculate" what can i do ... 2 13.09.2006 09:22:01 Microsoft Excel certification What are the best books, sources, etc. to use to get certified in Microsoft Excel? Microsoft® Office Excel® 2003 Step by Step got very bad reviews. -- Ed... 3 13.09.2006 04:03:25 How can I print different addresses on same text ? I want to print a letter with same text by several destinations and I tried a lot to find out on the formula box but not a chance, anybody can tell me how it works? Thanks... 3 12.09.2006 22:59:08 HOW DO YOU TOTAL MORE THAN 30 SUBTOTALS? PLEASE HELP ME SOLVE THIS PROBLEM!!!... 3 12.09.2006 22:22:28 Add a line I have a voucher I created in an excel spreadsheet (not a form or anything but on the worksheet itself). I need to be able to have the users click on a command button to add a new line. I tried doing it myself but I need the line added in the middle of the document using the same format as the line above. However, when I did it, it would delete the line underneath. How do I have it insert a l... 3 12.09.2006 22:16:31 office2007 beta how can i get product key ?... 2 12.09.2006 19:08:01 Speading up my Excel calculations. Hello, In a nutshell: I am putting together a database. I created a search "grid" that allows the user to choose a name from a data validation list. After selecting a name, the grid (shows 4 locations across, and the 12 months down) uses Sumproduct to count the number of units the selected name has for each site, in each month. The problem: I would like to use this database over a few y... 10 12.09.2006 18:29:11 column of dollar amounts don ... 1 12.09.2006 17:02:01 A cell appears "######". What's this? I write down a type, for example "55,000", which is by default a general type. From the menu Format, Cells, Number , I try to make it as an accounting type(in dollars), I press ok and then my type "55,000" disappears and appears a "#####" instead. What is this and how can I correct it? Thank you.... 17 12.09.2006 16:21:43 More lines in Product Pricing Calculator Hello I am new to this site and I am hoping someone can help me. I am trying to put together a pricing calculator so my staff can easily do quotes for our client, I currently work out everything manually. I need to put three or four more costs into this calculator and I am ttally bewildered as to how to do it. Can anyone help me ... 2 12.09.2006 15:24:02 How do I enter a date typing 040906 and have it appear 04/09/06? I I would like to format a cell so that I can just type in the numbers in a date and have the cell display the date with the forward slashes added automaticly! Example type in only 040906 and have Excel display 04/09/2006 in the cell.... 4 12.09.2006 12:44:16 125 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>