| Thread | Last Post | Replies |
|
| Validation based on values | 20 Jan 2004 01:49 GMT | 1 |
I need help with a formula. User "may" enter a value in cells D14, E14, and/or G14. These cells relate to cell D13, which is a text value and the cell is labeled "Product A."
|
| stumped on summary? | 20 Jan 2004 01:19 GMT | 1 |
Hello newsgroup, I have created an attendance sheet. Names in a column, dates in a row across the top. Each cell has a value (alpha-numeric, (the number "1", or one of 4 alphas)) or
|
| How to Build an External Link Using Data from Cells | 20 Jan 2004 00:25 GMT | 2 |
I want to import data in a cell from an external spreadsheet located at 'C:\Data\[MyXLS.xls]MySheet!$H$5. I want to build it using cells from the current worksheet such as:
|
| cell formats | 20 Jan 2004 00:22 GMT | 1 |
Does anyone know how to find formatted cells using a formula? For example: I want to know how many cells are conditionally formatted RED because they met some other condition.
|
| Automatic Report to run for 6 days only | 20 Jan 2004 00:12 GMT | 7 |
Im wondeing if someone can help with the following. I have an automatic report which runs daily and saves accross to another file. These are in reference to call volumes within the work place.
|
| are permutations possible? | 20 Jan 2004 00:10 GMT | 1 |
I read in an article that Excel is capable of converting character string representations of potentially overlapping permutation cycles and returning a concatenated product. It is important that the product be
|
| formula needed | 19 Jan 2004 23:14 GMT | 6 |
Im trying to find a formula that will calculate my fees.... D4 is the number im using.... if it is $25 or less = 5.25%, if it is $25.01 or more = $1.31 plus 2.75% anyone have any ideas on this one?
|
| Removing a space in a numeric string | 19 Jan 2004 23:01 GMT | 2 |
I have imported a text or general field from another file as follows 99 99. I need to remove the space between the two sets of numerics.
|
| Formatting for Weights pounds & ounces | 19 Jan 2004 22:29 GMT | 3 |
Can anyone help. I am trying to track my weight on an excel spreadsheet, but when I enter my weight is it possible to format it in stones and pounds. As when I want to subtract one weight from another it doesn't recognise that there are only 14 llb in stone so the calculations ...
|
| HELP W/ Merging Excel to Word | 19 Jan 2004 22:19 GMT | 3 |
Can someone give me some advice. Below is an example. Here it goes: In column A, I have dates of when someone started at a job(Aug 15, 2001); In column B, I have the date when they left their job (January 5, 2003). In
|
| Calculating Number of overdue dates with certain conditions | 19 Jan 2004 21:44 GMT | 4 |
I am trying to calculate the number of calendar days overdue based upon a scheduled date (H32) and an actual date (J32). I need to have a function that will address 3 possible scenarios: 1. Where Actual date (J32) and scheduled date (H32) have occurred (if
|
| mailing labels | 19 Jan 2004 21:12 GMT | 2 |
how do I convert a spreadsheet with several rows into mailing labels. Thanks
|
| HELP with printing labels | 19 Jan 2004 21:10 GMT | 1 |
I need help printing address labels from an Excel file. I've done this before but can't for the life of me remember how. Thanks to anyone who can help.
|
| How do I check for color in a formula? | 19 Jan 2004 21:09 GMT | 2 |
I want to sum for all cells of a certain color. Anyone know how? Thx.
|
| Macro | 19 Jan 2004 21:06 GMT | 2 |
I am trying to write a macro to 'Save As' I have a workbook that rolls over each financial year and I would like to set up a macro for it to re-name it's self to *2003, *2004, *2005 etc.
|