| Thread | Last Post | Replies |
|
| How to print everything in a cell | 26 Oct 2005 16:22 GMT | 2 |
I have a spreadsheet that has different sized cells filled with text. I have 2 larger cells and when I go to print these 2 cells cut off about the last 2 sentences. I have tried making the cells larger and removing the formatting and redoing it but nothing seems to work... HeLP
|
| pivot table created from another pivot table | 26 Oct 2005 16:16 GMT | 6 |
I was able to create a pivot table using an established pivot table; however, the established pivot table has filters (created using the PAGE area of the layout). I was hoping that when the established pivot table is filtered on (thus changing the data within the pivot), it ...
|
| Advanced Date Functions | 26 Oct 2005 16:08 GMT | 1 |
You should have date functions that can return business days. Example 01/FBD/2005 -> would return the first business day in January 12/LBD/2005 -> would return the last business day in December
|
| Sumproduct #N/A! error issue | 26 Oct 2005 16:01 GMT | 2 |
I have not been able to find the answer after a while searching for it so here is my question: I am using the sumproduct function for calculating subtotals in 2 corporate worksheets dealing with production data and with the
|
| How do I calculate IRR using monthly cash flows, not annual? | 26 Oct 2005 15:15 GMT | 2 |
As I understand it, Excel assumes that for purposes of calculating IRR, each consecutive value is an annual value. If I have a short lived project, say 16 months, Excel assumes that the cash flow in the 16th cell is the 16th year, thus the IRR is dramatically understated. How ...
|
| Getting data from another worksheet | 26 Oct 2005 14:51 GMT | 1 |
I have an ever expanding excel sheet listing transactions. New ones are added to the bottom of the list. In the row cells will show name, address, value etc etc. I want to have another worksheet that picks up the name, address, value etc
|
| moving cells | 26 Oct 2005 14:50 GMT | 1 |
Hi guys I have a question or should I say i have a big fu*** problem Sory about that word :) ok one of my employee is getting every week excel document looking like the picture you can see it. Now here is th problem. Each document has always at leas 1000 rows, so don't even thin
|
| ISNUMBER and VLOOKUP Help Needed | 26 Oct 2005 14:38 GMT | 1 |
I have two separate spreadsheets: one that contains production jobs scheduled for manufacturing (Job Order Reports and Press Capacity Planning.xls) and another spreadsheet that contains all raw material in inventory (Shipping and Receiving Data). I want to write a formula on the ...
|
| Excel Won't Calc? | 26 Oct 2005 14:19 GMT | 7 |
I sometimes find that when spreadsheets get to be a certain size they often don't calc properly. Any idea as to why? Thanks, Eric
|
| Help! How can I get data from one sheet to another | 26 Oct 2005 13:51 GMT | 2 |
I am trying to associate a cost with each item number and when I add an item number in another sheet in one cell, I want the associated cost to be placed in another cell. Any help would be appreciated
|
| Link To Drop Down Menu | 26 Oct 2005 13:35 GMT | 5 |
I have a cell with a drop down menu with Contract Types. I want cells to populate with data elsewhere on a worksheet if this drop down cell = T&M. Please see example below to better explain. Worksheet A
|
| DATEDIF Simple request | 26 Oct 2005 13:30 GMT | 1 |
I want to enter regular entries in a spread sheet (of meter readings to track utility cost) and in one column I want to determine the cost per day. I therefore enter the date in column A (set as "Date" field), followed by such items as meter reading, unit rate, etc. In one column
|
| How do I put in more than 7 validations in IF FORMALA in EXCEL | 26 Oct 2005 12:31 GMT | 3 |
I have an excel sheet wherein I have a column in which I need to put in 30 validations . But the IF function is with 7 validations max. How can I do a IF function with 30 validations
|
| Validation | 26 Oct 2005 12:27 GMT | 4 |
I need a way to stop anything from being entered into a cell other than 2 letters and 2 numbers eg: AA12 (Alpha Alpha Numeric Numeric) Is there a way using validation to do this?
|
| data validation using vlookup | 26 Oct 2005 12:25 GMT | 5 |
I have a spreadsheet with a list of serail numbers and their cooresponding asset tags. I have named this range "AssetList". I have another spreadsheet, in the same workbook, with a list of employees. I need to enter the serial number, then type in the asset tag.
|