| Thread | Last Post | Replies |
|
| formula: count if not blank | 16 Nov 2006 20:33 GMT | 1 |
I have two columns, a date in the left, and in the right a formula to calculate the date plus 14 days. For some of the cells in the left column, there won't be a date right away. I want to have the formula to calcualte the date in all the cells in the right column so when i do ...
|
| exact value from supplied Row and Column data | 16 Nov 2006 19:57 GMT | 1 |
Column A contains countries. Row 2 contains years 1996 thru to 2005 (10 year span). Question: If someone tells me a country and year, I can give them the data for
|
| change date format. | 16 Nov 2006 19:51 GMT | 2 |
I have an excel 2003 file with 1500 dates in one column . The format is 10/31/2006 I have to import these dates into Microsoft Dynamics 9.0-fixed assets. To import, the date format should be 10312006. Is there a function that could strip the '/' out? could someone assist me ...
|
| Convert month number to string | 16 Nov 2006 19:46 GMT | 6 |
I have a master sheet in which date is stored in columns by month. Row 1 has the year and row 2 has the month number (1 to 12). There are presentation sheets that reference subsets of the master data and on those sheets I would like to display a 3 char string for the month e.g.
|
| Is there a formula can get min value of a range by certain conditi | 16 Nov 2006 18:44 GMT | 5 |
I want to know if I can use a formula to get the min date that task ID "A" and task type "STK"? Sample data below. I want to get 1/1/2005 as Min date for task A and Type STK. Thanks much!! Date Task ID Task Type
|
| IF worksheet function | 16 Nov 2006 18:40 GMT | 3 |
I don't know if this possible, but looking for some help if it is. I am guessing it would be with some sort of IF worksheet function. I have a column of dates. In a separate cell a few columns to the right I would like to enter a value (32.50) if the first of the month is among ...
|
| Multiple values to report a third | 16 Nov 2006 18:20 GMT | 1 |
I have two worksheets. The first is a list of Pipes and specifications ColA Col B Col C Col D Schedule Diameter Volume Weight
|
| EOWEEK --- similar to EOMONTH | 16 Nov 2006 18:01 GMT | 3 |
Hi, I know there isn't and EOWEEK function, but there should be :) I get lots of requests each day and want to run them through reports showing incoming per week, etc...
|
| Counting the number of Error Types | 16 Nov 2006 18:01 GMT | 3 |
I'm trying to determine which error types exist in a fairly large worksheet, so I wrote the following formula to find the number of "#REF!" errors: =COUNTIF(A2:CY5000,ERROR.TYPE(A2:CY5000)=4) After manually looking through the entire worksheet I found 2 cells
|
| How do I calculate age from birthdate to present in Excel? | 16 Nov 2006 18:01 GMT | 4 |
I have a list of names with birthdates and would like to calculate each ones age in years, months, and days from the present day. I am using Excel 2003 SP2. I see how to use the Today function to get the present day. A subtraction yields the number of days from 1/1/1900. In date ...
|
| Percentage formula help | 16 Nov 2006 17:08 GMT | 2 |
I have 2 figures, 1 I want to add 7.5% to it and get the total, the 2nd figure I want to subtract 7.5% and get the total. Have totally forgotten how to do percentages. Any help greatly appreciated, thanks.
|
| Need simple IF formula, please | 16 Nov 2006 17:03 GMT | 5 |
I know this is simple, but I don't know how to write it: In V1262 I need this formula: If R1262 and Y1262 are the same, then 39 will appear in V1262. If, however, W1262 and Y1262 are the same, then it will be 38. If again, however, W1262 is less than Y1262, then it will be 37 ...
|
| lookup data and fill cells | 16 Nov 2006 17:03 GMT | 1 |
I have 1 sheet that has a column containing many different account numbers. I have a 2nd sheet with the same account numbers with the relevant account name. I would like to add a column on the 1st sheet which looks up the account number on the 2nd sheet and brings back the ...
|
| can I sum one column if the value of another column is ex. "M" | 16 Nov 2006 16:57 GMT | 2 |
I need to sum column D (currancy) if the value of column C is an "M" I've been trying =SUMIF but can't seem to get it right.
|
| simple currency addition in cell without having to enter decimal | 16 Nov 2006 16:36 GMT | 8 |
I want to add dollar amounts in an individual cell with a fixed decimal point. In other words, click on a single cell, press =, then enter multiple numbers (preceeded or followed by the + or - sign) without having to enter decimal for each amount entered.
|