| Thread | Last Post | Replies |
|
| Auto-create separate worksheets... | 19 Jun 2006 07:44 GMT | 3 |
I have a list in a single worksheet that runs as follows: Product no. Qty. 123 17 123 8
|
| Excel problem trying to format columns of data | 19 Jun 2006 06:34 GMT | 3 |
Probably an easy problem for the Excel Wizard. However, not for me. Presently I have a price list that is 3 columns wide and extends to over 300 pages if printed in its current format. I would like to move the data so that it shows/prints page 1 and 2 on a
|
| Making formulae function throughout worksheet | 19 Jun 2006 04:15 GMT | 1 |
I am currently working on setting up a call cost register for my workplace. Currently, the first cell in columns D, E and I have a formula in them used to calculate total time of the call, the number of 6 minute units the call used and the total cost of the call.
|
| return a list | 19 Jun 2006 01:11 GMT | 1 |
I have 50 employees listed and have columns that represent 6 different skills. I want to generate a list of the employees that have a given skill. I am usually good at figuring this logic out , but am having a brain
|
| Another Date related question.... | 18 Jun 2006 23:49 GMT | 7 |
I am trying to work on a formula using DAYS360 (We cannot use NETWORKDAYS as plug-in's are'nt allowed at work), and failed! So a 30 day month * 0.67 to give 4 working weeks is good enough here. We have a Start Date and an End Date, the variables of this are pretty wide.
|
| SUMIF variation? | 18 Jun 2006 21:13 GMT | 8 |
Excel 2003 I have a sheet with col. A being a list of dates and the other columns being various figures. I know how to use the sumif function to give me totals for a particular date in col A. How would I do something similar except giving
|
| IF or IF(AND Function | 18 Jun 2006 20:00 GMT | 4 |
Expiration /Date/Current Date/Status - Cenerio 1 # Required/# On Hand /Status Cenerio 2 Feb-06/ Jun-06 /ORDER/15/15/NO ORDER / indicate seperate cells
|
| How do I find unknown interest rate using TVM functions | 18 Jun 2006 17:13 GMT | 8 |
I invest ?$ and need to have ?$ in ? years. How do I find out what interest I need to earn on my initial investment to have my future amount?
|
| Web Query (Excel 2003) | 18 Jun 2006 16:58 GMT | 3 |
I'm trying to create a workbook that queries financial data (multiple tables) from MSN. I can get the data queried just fine into different worksheets, but I can't figure out on my main worksheet, which performs different calculations from data queried on the other worksheets, ...
|
| Formula for calcing dates | 18 Jun 2006 14:55 GMT | 7 |
Hiya, The spreadsheet I need function help on is to be used to flag end dates for plant hire. We need to know when a piece of plant is over 2 weeks on hire to keep track of where stuff is and what is available. I have used the following:
|
| A Tricky One...... | 18 Jun 2006 14:04 GMT | 3 |
Hello All, Hopefully someone here knows something I dont! :) Basically, I need a formula or function that will allow one cell to determine what value is assigned to another cell. What I've been
|
| How do I write this formula in Excel? | 18 Jun 2006 13:53 GMT | 3 |
Help, I need to write this as a formula in Excel Below £30.multiply by 5.25% , Above £30,the first £30 multiply by 5.25%,then the remainder multiply by 3.25% ,Hope this makes sense, Thanks Woodie
|
| how do I add Drop down menues in Excel? | 18 Jun 2006 11:50 GMT | 2 |
I am trying to set up Drop Down Menues as part of an Excel Workbook. Can anyone help explain how this is done?
|
| Variable File Name | 18 Jun 2006 10:36 GMT | 1 |
Does anyone know of a way to have a user type in a file location into a named cell and then use that information in other formula? For instance, assume that a file used once is located at \\server\allocation\space\myexcelMay06.xls
|
| Formula | 18 Jun 2006 08:33 GMT | 1 |
Hi all, I am new to this website and am wondering if anybody can help me. I want to form a formula that if number 6000,4000,2000, or 0 appear, that it will produce 20000.
|