| Thread | Last Post | Replies |
|
| Converting ASCII Into Excel, any Ideas? | 27 Sep 2006 19:42 GMT | 3 |
I need to convert Data from Sprint that comes in either a PDF or ASCII. I need to convert those to and put them onto an EXCEL spreadsheet. Anybody know how to do that?
|
| Automatic updating for text boxes used on Charts | 27 Sep 2006 19:40 GMT | 1 |
One of my supervisors has asked for me to design a new chart for an ongoing project (that will be updated weekly), where a formula based on one only column of data (that is linked from another spreadsheet) is reflected on a Chart (currently) by creating text boxes and typing in ...
|
| Tab Function in Protected Worksheet | 27 Sep 2006 19:37 GMT | 1 |
I'm using Office 2003 and have a worksheet protected with the ability to enter data in a selected table. How can I get the Tab function to work in the data entry section of the worksheet? Thanks
|
| COMBINE COLUMNS | 27 Sep 2006 19:09 GMT | 6 |
How do I combine two columns (of items numbers) without having any duplications on another worksheet?
|
| I can't find the Assign Macro command | 27 Sep 2006 19:08 GMT | 3 |
I am trying to assign a Macro that I recorded to a command button. However when I right click on the sizing bar of the command button "Assign Macro" does not appear. Is thare another way to do this?
|
| Help with formula | 27 Sep 2006 18:59 GMT | 7 |
=OR($F$1=5,$O$1=5000)The problem with this formula working is the formula in cell F1 is being read as text (I think) and I need it to read as numerac. Example: The cells that I need are selected and conditional formatted to change to red if these criteria are met. If a 5 is in ...
|
| conditional formatting | 27 Sep 2006 18:46 GMT | 5 |
i am trying to have a row of cells be a certain color if one particular cell is >0, for example. is there a way to do that? thanks! eric
|
| Macro - can't find | 27 Sep 2006 18:43 GMT | 2 |
Upon opening a spreadsheet I get error messages about enable/disable macros but I can't find any macros in the file. Why is this happening.
|
| What is the best way to set up a meal calendar for volunteers | 27 Sep 2006 18:28 GMT | 1 |
My office has an employee in the hospital . We have several different organizations that are going to do meals for the family What is the best way to set up a meal calendar?
|
| Need another Formula Help for Copying Info Between 2 Pages | 27 Sep 2006 18:10 GMT | 4 |
I need to know what formula i would use for this following situation. I have a Excel Sheet in Excel 2003 First Sheet says: Credit Card Setup Second Sheet Says: Order Form
|
| print excel with formulas and answers together | 27 Sep 2006 17:52 GMT | 1 |
can anyone help me if i want to print out my worksheet that will contain both the answer and its formula together on a single page?
|
| I have "page 1" across my spreadsheet. How do I get rid of it? | 27 Sep 2006 17:30 GMT | 1 |
I don't know how the statement "page 1" got here but I don't want it or need it. ????
|
| simplify this formula?? | 27 Sep 2006 17:28 GMT | 6 |
=IF(ISBLANK(OFFSET(A8,0,MATCH($H$6,B$7:$G$7,0))),"",IF(OFFSET(A8,0,MATCH($H$6,B$7:$G$7,0))>=OFFSET(A8,0,MATCH($H$6,$B$7:$G$7,0)-1),"OK","Check")) The boss says it's "too complicated" The boss also doesn't like errors returned, so the boss wants errors trapped. Hence its being ...
|
| List of all "Date Formats" from Excel | 27 Sep 2006 17:26 GMT | 4 |
How can I get the list of all "Date Formats" from Excel? Something like this: dd/mm/yyyy mm/dd/yyyy
|
| Index Match Match? | 27 Sep 2006 17:04 GMT | 4 |
This one just seems to stump me! What I have in the cell is: =INDEX(Sheet1!C2:C1000,MATCH(D104,Sheet1!A2:A1000,0),MATCH(Sheet3!E104,Sheet1!B2:B1000,0)) and it gives me the eternal #REF!
|