| Thread | Last Post | Replies |
|
| Copying a formula question | 03 Nov 2006 19:54 GMT | 3 |
I am a novice Excel user and have a formula I would like to copy to more than 100 cells in a column. I am hoping there is an easy way to do this without entering it many times. The pattern of the formulas are outlined below:
|
| Stop excel from copying data from one sheet to another | 03 Nov 2006 19:53 GMT | 1 |
I have a workbook (actually 75 workbooks) and it has ten worksheets. In each sheet I have a subtotal at the end of each row (34 in all) and at the bottom of each column (25 in all) I have copied this formula onto each sheet. The problem I am having is that in the blank cells ...
|
| Auto formatting .CSV import data | 03 Nov 2006 19:19 GMT | 4 |
I'm a database programmer and I'm trying to parse out a sets of data to our sales force. They are all pretty proficient in Excel and what I've been able to do at this point is create a .CSV file, email it to them and they can open the data without any problems. What I'd like to ...
|
| Text Formatting within a cell | 03 Nov 2006 18:33 GMT | 2 |
I know there is a way, I've seen it before I just can't figure it out or find it online. How in the world would I go about formatting a range of cells to make all text within that cell proper. I am not talking about the function "PROPER" but I need the same thing accomplished
|
| Need IDEAs For hidding data | 03 Nov 2006 18:02 GMT | 1 |
I've had a request for a simple spreadsheet that will allow my company to display the name and a few other bits of information on electrical items and then they need to be able to access additional information if that is what they are looking for. I've seen a spreadsheet with the ...
|
| Need help formatting a cell. | 03 Nov 2006 17:08 GMT | 2 |
Can such a request be done using Excel? I need to enter a time in Cell B18 of 2325 or 11:25pm from that time i need it to calculate that cell B17 is 15 minutes prior to B18 (2310 or 11:10pm)
|
| Need solution for SendTo: Mail Recipient | 03 Nov 2006 10:52 GMT | 9 |
I have developed a small tool to aid our salespeople in preparing sales proposals. One feature is a button they click that sends all of the details of the proposal to an expert in our firm for approval and so that he can keep tabs on everyone's activities and catch any errors.
|
| Running out of room in Microsofts Checkbook Register | 03 Nov 2006 09:49 GMT | 3 |
I downloaded the checkbook register1 template from Microsoft and am now out of space to add anything else. I have tried to drag the columns and rows down bur nothing happens. In the Excel spreadsheet I made this works to extend the form but it will not in the one made by ...
|
| 2 questions regarding count formula | 03 Nov 2006 05:44 GMT | 8 |
If I have the following data A B C 1 Personnel group type p't number 2 Melinda 1 4
|
| Checking for Dupes | 03 Nov 2006 03:43 GMT | 4 |
I am entering data to column B, a 5-digit number. Is there a formula that I can put in column D that will tell me if the number is a duplicate. The numbers batch numbers from the accounting system. There should be only one. But since I am entering the batchs with them
|
| Check colume if it is not blank | 03 Nov 2006 03:16 GMT | 3 |
I want to check another columes if one of columes are not blank. For example, I need to check B2,C2,D2,E2 & F2. If B2 is not blank, then A2 will show "1". If D2 & F2 is not blank, it will show "3" in A2. Thats mean A2 need to show the first item which is not blank.
|
| Multiple Entries from Validated Data | 03 Nov 2006 01:22 GMT | 1 |
On an excel spreadsheet that I have, I have a column which I want locked so only validated data can be placed in the cells. However, there are multiple acceptable choices (ie column 1 could include choice a and choice c). Is there any way to allow for this?
|
| CSV files | 03 Nov 2006 01:16 GMT | 1 |
I try to open .CSV files from excel but they open in a single column. Help Tks, Gaby
|
| Elegant way to restrict data entry to list of values | 03 Nov 2006 00:54 GMT | 2 |
I need to provide a way to restrict data entry on a large range. For example, I need the first 100 rows of column 1 to only provide 'yes, no' as possible entry values. The first 100 rows of column 2 to provide 'yes, no, maybe'; the first 100 rows of column 3 to provide
|
| Getting rid of the grid | 02 Nov 2006 23:16 GMT | 4 |
I have finished a spreadsheet and I would like to make it look a little slicker. If there any way to remove the cell edges so It is just white.
|