| Thread | Last Post | Replies |
|
| How do I get Excel to tell me the angle of a line | 22 Oct 2005 01:02 GMT | 4 |
I am trying to determine the angle of a line drawn in Excel; I need to acess angles from digital photos...so I import the photo and draw a line on it....I need to know the angle of the line.
|
| Resize Range - Macro | 22 Oct 2005 00:38 GMT | 11 |
Please write a macro to CHANGE number of rows “3” to a variable range (end.xlDown) on the macro below. Sub GotToRangeResizeCopyPaste() Application.Goto Reference:="MyRange"
|
| Countif | 22 Oct 2005 00:05 GMT | 3 |
what formula can I use to do a count with more than one criteria?
|
| How do I subtract block N19 from L19. | 21 Oct 2005 23:34 GMT | 2 |
Running a monthly expenditures worksheet. Would like to subtract what has been paid this month ,which is on same sheet with what is normally paid each month. example is (L19)-N19). All I get is block contains a constant. What do I do.
|
| need help again please | 21 Oct 2005 23:03 GMT | 2 |
I need to create a formula to add the dollar values in the cells of one column based on the date values in a second column being in a certain month ie October. This is the formula I came up with but it doesn't return the correct answer:=SUMIF(AU8:AU55,"=>10/01/2005=<10/31/2005" ...
|
| LOOKUP function -help! | 21 Oct 2005 22:22 GMT | 4 |
:confused: I have been trying to help my mom with something (she's taking an online class, but can't figure this out) , I can't even figure this out! I know it has to be something simple. She's done everthing herself up till this point, but is totally stuck on this .
|
| VLOOKUP | 21 Oct 2005 21:22 GMT | 8 |
How can I get VLOOKUP to continue searching a column after it finds the value it is looking for? For example..we have the following in A1 (NEW YORK) and in A2 (NEW YORK). I am able to pull up the values in b1 (# of employees) and c1 (total # of phones), but it does not seem to ...
|
| percentage formula | 21 Oct 2005 21:05 GMT | 2 |
Please help with writing a formula. I have a list of numbers and need to write a formula to show how many of them are over a certain value. Then I need to know what percentage is over this value. Example: 13, 45, 25, 12, 56, 32, 08. how many of these are over 25 and what ...
|
| Problem organizing text data into new excel page | 21 Oct 2005 20:20 GMT | 3 |
Ok... I am going to try to explain this as best I can. I have a HUGE amount of text data that was cut from a web page and pasted as text into an excel sheet. There are 9 entrys for each data set... so the first set goes from A2 to A10... second set goes from A13 to A21 and so ...
|
| Making a button to sort | 21 Oct 2005 20:19 GMT | 2 |
Very simple I'm sure, but I just can't figure it out. I have data in rows 1 and 2 on my spreadsheet. I'd like to create a button on the spreadsheet that when clicked, will sort rows 1 and 2 by the data in row 2. Any help or pointers is appreciated.
|
| How do I copy only cells with formulas in another row? | 21 Oct 2005 20:02 GMT | 2 |
I have a table with multiple formulas on each row. I need to be able to copy on the formulas when I insert a new row. I've tried the paste special formulas and that copied the whole row, data included. I only want the formulas to be copied.
|
| Need help with TRIM function | 21 Oct 2005 20:02 GMT | 9 |
I have a table with these values, some of which are INVALID. 0120120001 VALID 0000212462 INVALID 0150214785 VALID
|
| I wish to make a formula that adds dollars in 1 column if a date . | 21 Oct 2005 19:57 GMT | 2 |
I wish to make a formula that adds dollars in 1 column if a date range is satisfied in a second column. This is the formula I came up with but it doesn't return the correct answer. Can any one help me with a correction?
|
| Conditional reference on average interest calculation | 21 Oct 2005 19:29 GMT | 1 |
One of the typical problems of modeling in finance is that when interest is calculated on average outstandings a circular reference is created. A possible solution is to have Excel calculating the interest expense/income through iterations. Does anyone know, if other solutions
|
| List Box with dynamic list - Help | 21 Oct 2005 19:07 GMT | 4 |
hi, i have a problem... i have a list box and 5 dynamic named ranges. i also have a series of 5 option buttons that control which of the 5 named ranges is the one i want.
|