| Thread | Last Post | Replies |
|
| find alpha in column 1 numeric column 2 | 26 Feb 2008 04:45 GMT | 2 |
Might be basic question, but I am having brain cramp!!! I am trying to count the number of times in a sheet column 1 = 10 AND column 2 = South. I have tried multiple version of the count, and, if, countif etc, but can not figure it out. Please advise
|
| How do I find the loan amount from my payment in Excel? | 26 Feb 2008 04:06 GMT | 1 |
I am building a cost analysis and I know what I can afford for a monthly payment but I need to know what the total loan amount would be for that payment. EX: 20 year amortized
|
| How to Create a Date Series across a row? | 26 Feb 2008 03:07 GMT | 3 |
Greetings all. I've run into a roadblock in Excel 2007. I am trying to create an ascending date series across a row, with each 3-cell section containing the same month, day and year. So, for example : Cells A1 - C1 = 1/1/03 1/1/03 1/1/03
|
| 2007: Property Sheet button disabled | 26 Feb 2008 02:21 GMT | 5 |
Is there a way to enable the property sheet button on the Quick Access Toolbar ? When I add it to the QAT it's disabled, and doesn't function. Excel Options -> Customize -> Customize the Quick Access Toolbar
|
| timecard | 26 Feb 2008 01:26 GMT | 1 |
I need a simple formula. Cell A1 is begin time and cell B1 is end time, both are entered in hours and minutes. I need the formula in C1 for the difference between the two in hours and
|
| help with formula sum? | 26 Feb 2008 01:17 GMT | 1 |
I have a quantity in Column B and the part number in Column A on sheet2. Which is listed multiple times. How would you send the total quantity to sheet 1 where ever that part number is located. Example: Sheet2
|
| Linking 2 columns of data | 26 Feb 2008 01:13 GMT | 2 |
I am trying to create a form in which 2 columns of information are linked. In one column is a product number and the other is a product description. I want the form to have drop downs if possible. I want the result to be if you select the item number the description column fills ...
|
| Horizontal numeric order | 26 Feb 2008 00:57 GMT | 5 |
I am trying to arrange zip codes in horizontal numeric order so I can read them like reading a paragraph in a book. How to do this please? Thanks.
|
| filtering | 26 Feb 2008 00:23 GMT | 3 |
I have two colums. A description column and an amount column. How do I subtotal the descriptions?
|
| SUMPRODUCT multiple conditions | 26 Feb 2008 00:21 GMT | 1 |
I want to be able to return a value based on mulptile criteria (from both columns and rows). Worksheet 1 (Summary): I have Location, Postition, Rate, Hours for Date, Dollars for Date as
|
| delay in opening excel files | 26 Feb 2008 00:07 GMT | 1 |
I have an issue opening excel files that are created/used every month. I create new excel files each month (as I receive new data), and the delay in opening these files seems to get longer each month. I don't necessarily get significantly more data with each new file, just ...
|
| problem with links | 25 Feb 2008 23:17 GMT | 1 |
Whenever I open my workbook I get the message "This workbook contains one or more links that cannot be updated." Then I click "Edit Links" and there is only one link to another workbook. The status for that workbook reads "OK". Is there something I should be doing? Is there
|
| Emailing Spreadsheet with Hidden Rows | 25 Feb 2008 23:16 GMT | 1 |
Need to email spreadsheets with hidden rows, and need those rows to remain hidden. Currently emails un-hide those rows. Can this be done?
|
| How to Calculate Average | 25 Feb 2008 22:59 GMT | 4 |
I would like to find the AVERAGE of the last "X" alues in a column. The columnn contains an unknown number of empty cells. In the example below: COL A contains the values to be averaged.
|
| Mix up names | 25 Feb 2008 22:41 GMT | 3 |
What is the formula and how to: To change the names from alphabetical order to being shuffled. Excel 2003 Thank You
|