| Thread | Last Post | Replies |
|
| pmt function | 12 Jul 2007 08:07 GMT | 1 |
Scenario: I have $x currently and want to save up to $y. What is the formula to tell me how much I need to save each week for say 1 year to go from x to y given a standard, fixed variable rate?
|
| Spss verse excel | 12 Jul 2007 07:48 GMT | 5 |
I want to do some statistical analysis and probability calculations. my professor advised me to use spss, which I am totally unfamiliar with. Does this software offers functions that excel can not perform I prefer to do all my analysis with Excel which I am used to it.
|
| JIS / ASC Functions in Excel 2007 | 12 Jul 2007 06:31 GMT | 3 |
I have several text strings in single-byte Japanese I need to convert to double-byte Japanese. The JIS and ASC functions in Excel are listed in Excel Help, but they are not available in Excel 2007. Attempted use generates a NAME? error. I am running English Vista, and I have ...
|
| Is there a way? | 12 Jul 2007 04:13 GMT | 4 |
Is there a way to add up the number of lines that have writing in them versus an amount? For instance I have this spreadsheet and I want to add up how many sconces I have and every time I add a new one the number updates.
|
| Please Help... | 12 Jul 2007 03:10 GMT | 5 |
I had a table of data and would like to go the following... please help... A B C D 1 Andy 78 98 85 2 Jane 45 65 96
|
| vlookup | 12 Jul 2007 02:57 GMT | 1 |
can you have the result return a color for a certain value? thanks!
|
| Calculate value in a text filled cell | 12 Jul 2007 02:05 GMT | 6 |
How can you setup a cell with text and assign a value to that cell so when you sum the columns, the value computes. For example, I have a cell contract terms with a text value of "6 months", how do I setup the cell so it's value for formulas is "6" so it will compute the sum of ...
|
| PROPER FUNCTION | 12 Jul 2007 01:38 GMT | 5 |
HOW DO I USE THE PROPER FUNCTION FOR MULTIPLE NAMES THAT NEED TO BE CHANGED?
|
| How do I insert cells in a macro? | 12 Jul 2007 00:32 GMT | 7 |
I have a worksheet with 6 columns 300+ rows. I have a macro that preforms a a filter, delete rows based on blanks, turn off filter and save as values. Now I need to find "GRAND TOTAL:". in Column A. This is variable. Once found, insert 7 cells and shift right.
|
| Thank You! | 12 Jul 2007 00:20 GMT | 2 |
Just wanted to take a moment to thank many of the regulars to this group for all of their wonderful help. I'm a realtive "newbie" to Excel, and I have received such great help from people like Max, Roger, Toppers, BJ, Pete UK, Driller, and Rick. You all are so gracious in sharing ...
|
| Extract Middle Initial from Name | 11 Jul 2007 23:17 GMT | 10 |
I have a list of names; some of which contain the fistname, middle initial, and last name. The other names in the list are only first and last names. For example: John T. Doe and John Doe. I need to extract the middle intial and the period after the MI so that I end up with a ...
|
| Multiple Criteria | 11 Jul 2007 23:08 GMT | 4 |
This is on Sheet1 (database of prices): A B C D E F 5 Type I Type II
|
| NZ function equivalent in Excel | 11 Jul 2007 23:04 GMT | 6 |
Does Excel have an equivalent to the Access function NZ? I want to avoid having to perform a double VLOOKUP (one to determine if the value is non-numeric/non-existant, the second to pull the actual value in the event it is numeric).
|
| delete macros | 11 Jul 2007 23:01 GMT | 1 |
An Auto_Close macro was set up by someone else and we don't want it in the file anylonger, weare getting some strange messages when closing out of the file. I followed the instructions for deleting but the delete button won't highlight, it stays gray. I don't know if it was ...
|
| How do I insert cells in a macro? | 11 Jul 2007 22:32 GMT | 7 |
I missed the answer by 15 minutes, then went on vacation for a week. The answer didn't work, however, and this problem truely has me bugged. My question is now past page 15, so I thought I would try again. I have a worksheet with 6 columns and 300+ rows. In column "A" I need to ...
|