| Thread | Last Post | Replies |
|
| Import data from Adobe Acrobat PDF Files | 31 Mar 2005 22:24 GMT | 1 |
How can I import text as data from acrobat pdf files?
|
| Conditional Formatting & IF Statements | 31 Mar 2005 21:43 GMT | 2 |
I would like to know if there's a way to do an IF statement as follows: [If the cell contains any part of the word "VACANT", then do this... ] I have cells that say "VACANT" and some say "VACANT/NEW TENANT" and I'd like the formula to recognize both these cells. Hmm... maybe using ...
|
| Moving multipule sheets into their own workbooks | 31 Mar 2005 21:14 GMT | 1 |
I have a workbook with many spreadsheets in it for customer pricing, each customer has a sheet of their own. I need to email each particular sheet as an attachment to each customer, is there a quick easy way to have each sheet copied and pasted into its own workbook in one or ...
|
| "=RESULT()", "=ARGUMENT()", "=RETURN()" ?? | 31 Mar 2005 20:59 GMT | 1 |
I'm tying to figure out a function whose rows look like this: ---------------------------- SDV_AN =RESULT(1)
|
| formatting date | 31 Mar 2005 20:44 GMT | 1 |
is there any way to format this date 2005 so that it only shows the year number 5 thanks
|
| Comments far from cell | 31 Mar 2005 20:18 GMT | 2 |
I have a user who has an issue with their comments in their spreadsheet. First off, there are quite a few comments inserted, so not sure if this is the root cause or not, but the problem is, he clicks on cell 'A93'
|
| Sum a column that meets two criteria | 31 Mar 2005 18:50 GMT | 5 |
I need to sum a column of numbers if it matches two different criteria. I can set up the SUMIF easily for meeting one criteria, but I need to also sum the column if it meets that criteria, and another. For example:
|
| Publish A Workbook Onto The Web, Then Access Using My Web Browser. | 31 Mar 2005 18:45 GMT | 2 |
How do I access my spreadsheet, or workbook, on the web once I've saved it as a webpage from the file menu? I've found that even though I've save my workbook as a webpage, it does not have an http:// address which I can type in my web browser to access the workbook from my home ...
|
| mixed formats in calculations | 31 Mar 2005 18:06 GMT | 3 |
I'm trying to calculate mixed formats like currency * time If I worked 9:22 today and my hr rate is $23.00/hr how do I do this? Mark
|
| Excel in english vs french | 31 Mar 2005 17:50 GMT | 2 |
I use some function from addins like analysis tools. My problem is that I work with some english version of Excel (2000) and some french version. When I send my french version to someone who have the english version, They have an #nom? for result.
|
| Random input? | 31 Mar 2005 17:32 GMT | 2 |
I'm making a test database up, but what I want to do is input a random model machine name into columns of cells. In other words I want to stipulate say 25 different machine names and I want to put them randomly into a particular column. Is this possible from within Excel without ...
|
| How do I create an hourly daily planner? | 31 Mar 2005 17:15 GMT | 2 |
I am using excel 2003. From start to finish, how can I create an houly daily planner?
|
| sort command | 31 Mar 2005 16:54 GMT | 8 |
my sort command is not active (grayed out)
|
| input box upon workbook open | 31 Mar 2005 16:50 GMT | 1 |
I want to have an input box that will ask for a date when a workbook is opened. I want to be able to us the date that is input in code that will be run from a macro.
|
| Remove hyperlinks | 31 Mar 2005 16:45 GMT | 3 |
Good Morning All, I have a spreadsheet with about 3800 words which are all hyperlinks. Is there a way to remove the hyperlink from all of them at the same time instead of individually right-clicking, hyperlink, remove?
|