| Thread | Last Post | Replies |
|
| Find max date | 25 Nov 2005 10:32 GMT | 6 |
i have a number of dates in one cell separated by carriage returns (alt-enter). how can i find the max of these dates?
|
| Help with formula | 25 Nov 2005 09:59 GMT | 2 |
Is there any way to do this. I have a column of dates. The dates are at regular weekly intervals starting from 1990 until now and they are always a Friday. In a separate worksheet I would like a formula in a cell to return the row number of the first date
|
| In Excel: select the last 20 rows of data in a column | 25 Nov 2005 09:36 GMT | 3 |
How do I create a formula that will select the last 20 entries in a column of a database?
|
| Problems with setting up a billing budjet | 25 Nov 2005 09:17 GMT | 1 |
Wow, talk about a useful program. Where have I been all these years? Oh, yeah! Happy Turkey Day! This is a basic question for a basic form. I can't seem to navigate through excel (actually using Open Office but it's nearly the same) to
|
| vlookup using two lookup values? | 25 Nov 2005 05:22 GMT | 10 |
Is there a way to perform a vlookup with two lookup values? For instance, I'd like to look up the value of A1 and B1 in a table with A1 and B1 values included to return cell C2 from the table. Any ideas? I've had limited succcess using concatenate and then using vlookup on ...
|
| Find last non-blank row with a worksheet function | 25 Nov 2005 05:10 GMT | 2 |
Find the last row with a value. Say I have a worksheet with a data entery range of A1 to A100. The user is required to enter data from row 1 downwards and cannot leave blanks between rows.
|
| complex amortization | 25 Nov 2005 04:56 GMT | 1 |
Problem: 5 loan amounts, each different, with varying interest rates, payments, and loan periods. The loan periods are epressed in decimals of a year, not full years. I need to determine the total amortization if, as the highest interest loan is paid off, the payment for that ...
|
| Rounding | 25 Nov 2005 02:33 GMT | 3 |
I would really like some help, round(3348.86*.1,2) = 334.89 round(3348.86*.03,2) = 100.47 when added together 334.89+100.47 = 435.36
|
| How easy is it to loop in VBA based on cell contents? | 25 Nov 2005 01:22 GMT | 3 |
I have a function in code that I added via the built in form designer Option Explicit Private Sub CommandButton1_Click() Application.Calculate
|
| Count cell | 25 Nov 2005 01:22 GMT | 3 |
I have a cell "Exams" who contains Exam Description. For example; Exam 8086L ANKLE - LEFT
|
| best formula to use | 25 Nov 2005 00:50 GMT | 2 |
Hi* What would be the best formula to use if i want to find out how much a number would go into a number then the left over part Eg
|
| How to summarize the first 4 numbers greater than 0 from a list. | 24 Nov 2005 23:34 GMT | 7 |
I've a list of numbers, I need to summarize the first 4 greater than zero cronologically eventhough they were in different places, and it could happen only three or less were in the whole list. Ex.
|
| Selecting a range of values for another function | 24 Nov 2005 22:45 GMT | 4 |
I cannot seem to figure this one out... I have a table that contains e.g.: Company1 Company2 Company3 Date1 Value11 Value21
|
| How do I extract data from graph (i.e. interpolaton) | 24 Nov 2005 22:31 GMT | 1 |
If we have a table of data values, can we build a graph and extract values from it not found in the table? Example pairs 2200, 1,21; 2400, 1.37 are in table from which a (non-linear) graph is created. Is there any simple way to find the value that goes with
|
| Error in "IF" formula | 24 Nov 2005 22:00 GMT | 4 |
Please help me to see the error in the following formula: "=IF(G6>=0.9<=1,E6*G6,IF(G6>=0.75<0.9,(E6*G6)*1.05,IF(G6>=0.6<0.75,(E6*G6)*1.1,IF(G6>=0.45<0.6,(E6*G6)*1.15,IF(G6>=0.3<0.45,(E6*G6)*1.2,IF(G6>=0.15<0.3,(E6*G6)*1.25,IF(G6>=0.1<0.15,(E6*G6)*1.3,0)))))))" The worksheet is ...
|