| Thread | Last Post | Replies |
|
| Function for 3 date columns | 24 Mar 2006 19:05 GMT | 3 |
Here is my issue for dates in Excel (2003). I have 3 columns with dates for which I want to calculate the number of days that have elapsed between the date sent and the date received. I am trying to calculate the the fastest receipt date for items sent.
|
| Formula/function that checks for a set of values. | 24 Mar 2006 18:59 GMT | 8 |
I am not sure if there is a function for this, but I am setting up schedual using Excel. I want to create a formula/function that look at a range and checks each column to confirm that there is at least on value of “E” “N” and “D” preset. There are other values that don
|
| Re: Copu worksheet ranges from One Workbook to another from | 24 Mar 2006 18:19 GMT | 5 |
I have a workbook with about 250 worksheets, let's call it MW.xls. All worksheets have a name(a1, a2, etc). Once a week I copy groups of worksheets and save them as different workbooks(let's say wb1.xls, wb2.xls). Those workbooks get updated and emailed back to me. I receive
|
| Tracking changes | 24 Mar 2006 18:03 GMT | 1 |
Is it possible to have Excel automatically insert a comment to a cell when data is added/changed? This data could be the date and pesons name for instance. tia
|
| auto fill sequence... | 24 Mar 2006 17:59 GMT | 3 |
I am sure this is simple but cannot figire it out. I don't use Excel that much but need to create a large table. I have a list of numbers that I want to sequence as I drag fill handle.
|
| Selecting rows based on cell entries | 24 Mar 2006 17:56 GMT | 3 |
I want to select specific rows from a sequential list based on a cell value. Example: Name: Age:
|
| help! printing locks up excel | 24 Mar 2006 17:42 GMT | 13 |
Hello, I have a workbook that contains several macros and many formulas. It works beautifully until I try to print or do a print preview. Then it locks up excel and I have to restart. Any ideas about what is causing this? Thanks!
|
| refer indirectly to Name | 24 Mar 2006 17:30 GMT | 5 |
My application has a large number of related look-up tables. Each table is defined as a Name. In each row of my main worksheet, I can use data to calculate the Name of its relevant table as text. But how can I look up the table?
|
| Auto Change in Cell Color | 24 Mar 2006 17:28 GMT | 1 |
I have a list of stocks like this: Stock Price ABC 0.35 DEF 0.35
|
| Hot key for time? | 24 Mar 2006 17:15 GMT | 2 |
I have an employee who needs to complete a time ananlysis where he records how much time he spends on various tasks each day. I thought the simplest way to do it would be to create "hot key" in Excel, so he could point to a cell, hit a key (say, F8, or shift-F8) to put the ...
|
| TODAY function question... | 24 Mar 2006 16:37 GMT | 4 |
This should be a pretty easy question. How do I (or can I) insert text and a function into the same cell. I want one cell to say: For the Week of: xx/xx/xxxx (TODAY ( ) -7) Any help would be greatly appreciated!
|
| Excel 2003, need formula that meets two conditions then divides sums of numbers | 24 Mar 2006 16:08 GMT | 2 |
I have named ranges for CustID, CustType, Tons, and NetSales, sorted alphabetically by CustID. I need to find "PerTon" for each customer (the sum of NetSales divided by the sum of Tons). I need an array formula that gives me the answer to: lf Y2 = CustID And X2 = CustType,
|
| Using the wotksheet name in a cell | 24 Mar 2006 15:33 GMT | 4 |
I would like to display the worksheet name is a cell, is that possible (how)? something like =me.name regards
|
| Automating text in a cell | 24 Mar 2006 15:06 GMT | 4 |
Is it possible to apply a formula to a cell so that as soon as it is clicked into, a prefix for an order number wil appear, leaving the user to input the actual digits of the order no after the text? IE. upon clicking the cell, the text "JW/R" would appear and the user could
|
| Lookup Values in Table | 24 Mar 2006 15:04 GMT | 2 |
I have a data table that looks like this: 1/1/06 1.2 35 7.5 70 8.5 10 1/2/06 1.2 35 9.2 27 1/3/06 1.2 35 5.4 15 10.1 40
|