Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / June 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Auto-create separate worksheets...19 Jun 2006 07:44 GMT3
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 data19 Jun 2006 06:34 GMT3
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 worksheet19 Jun 2006 04:15 GMT1
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 list19 Jun 2006 01:11 GMT1
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 GMT7
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 GMT8
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 Function18 Jun 2006 20:00 GMT4
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 functions18 Jun 2006 17:13 GMT8
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 GMT3
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 dates18 Jun 2006 14:55 GMT7
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 GMT3
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 GMT3
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 GMT2
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 Name18 Jun 2006 10:36 GMT1
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
Formula18 Jun 2006 08:33 GMT1
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.