| Thread | Last Post | Replies |
|
| A Particular Amortization Method | 03 Aug 2006 03:07 GMT | 2 |
How can I create a formula in excel to determine a "maximum mortgage o $51,645" by just plugging in the monthly payment, the rate, and th term?
::$361/month at 7.5% on a 30 year amortization equals a maximu |
| I think this would be an if problem | 03 Aug 2006 02:12 GMT | 7 |
How would I write this? G= degrees. If 0-90 degrees = G If 90-180 degrees =180-G If 180-270 degrees = 180+G
|
| Transferring Text | 03 Aug 2006 00:16 GMT | 2 |
I need to be able to send data from one worksheet to another. Sheet 1 is the master and only sheet where data is entered. I have found out all cells have to be set to "Text" - which is not a problem. Sheet 1
|
| In excel | 03 Aug 2006 00:07 GMT | 2 |
In excel page setup , I want to transform inces in centimeters
|
| need to know how to control length and height of lines | 03 Aug 2006 00:04 GMT | 2 |
Here's teh problem, I need to print the gridlines with the sheet I am making for work. I need some of the lines to start at a certian place and stop at a certian place. I need some cells to be larger without all of them being the same size. Help
|
| sorting dates in Excel 97 | 02 Aug 2006 23:31 GMT | 2 |
Running a worksheet that lists all medical expenses and am not able to always insert date, expense, who to, in correct sequence. Some postings just come in on time. Is there a sort formula that will allow me to sort these entries in sequence? Will the sorting move up the entire ...
|
| I need a formula that returns True or False if a number is found in a specific array. | 02 Aug 2006 23:07 GMT | 2 |
I need a formula that returns True or False if a number is found in specific array -- BigDubb
|
| FORMULA HELP! Find all values in column at random rows and perform calcutlation. | 02 Aug 2006 21:37 GMT | 2 |
|
| if cell is blank, color another cell? | 02 Aug 2006 21:20 GMT | 3 |
I have 2 fields A1 and B1 If B1 is blank I want the text in A1 to turn red. Otherwise it will remain black. Later if B1 is filled in then A1 will turn back to it's original state
|
| Best solution VBA/C++ | 02 Aug 2006 17:56 GMT | 3 |
I am seeking some advice on the best solution for a small program I have to build. I need to design a program which can be launched in Excel, would acquire some data from Excel, then run some cash flow calculations (so mostly working on multiple small arrays with a lot of
|
| help with updating spreadsheet | 02 Aug 2006 17:39 GMT | 2 |
I’m new to excel and learning as i go. i need help, I’m trying to make my work a bit easier. i want to keep a historical record of products and there locations at work (work in a warehouse by the way), I’ve managed to create a worksheet (see below, worksheet 1) that uses
|
| Excel 2002 - How do I split a .xls file into multiple files based on data in a column | 02 Aug 2006 17:28 GMT | 3 |
I am working on a huge spreadsheet that logs thousands of transactions from dozens of customers. What I need to be able to do quickly break up that spreadsheet by customer code (column C) and save a file for every customer (along with the header) as a file named "(column C) -
|
| Most efficient formula/combining multiple data cell ranges/seperat | 02 Aug 2006 16:56 GMT | 1 |
I have 2 wksts', same wkbook.. wkst#1=Summary. Open wkst#2=Holds Open. Current On w#2 I have 10 columns: 5= Current Reasons ; 5= Current Owner
|
| Help about image transfer to excel spread sheet | 02 Aug 2006 16:45 GMT | 1 |
can any one tell me how to use csaned image in to excel, particularly am concerned about reconciliations, have many paper account statements and will be of great help if i can scan these documents and get it into Excel sheets.
|
| Reference every 4th row from a master list of modifiable length | 02 Aug 2006 16:41 GMT | 1 |
I'm creating an excel database for a clinical study on patients wit migraine. Each patients will treat 4 attacks (episodes). Thi presents a bit of a problem, since there's some information I' collecting that's specific to the patient (demographic information lik
|