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 / September 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
What is the quickest method to insert & name multiple worksheets .20 Sep 2005 22:55 GMT8
Need to create several spreadsheets ... each containing multiple worksheets
...
Example: Monthly spreadsheets containing a separate worksheet for each day
of that month ... Jan-1; Jan-2; Jan-3, etc.
Looking for formula for lowest costs, excluding zero20 Sep 2005 22:42 GMT7
I found a formula for determining the lowest costs from several columns, but
I cannot get it to work in my worksheet.  This is nearly 1000 lines long.  I
want to search 4 columns and get the lowest cost excluding 0.  Any
suggestions would be greatly appreciated.  Thanks!!
updating source cells20 Sep 2005 22:35 GMT3
I have a spreadsheet where the user selects a product from a dropdown list.  
this list is connected to a vlookup that produces a cost (in another cell)
based on the product chosen.
I want the user to be able to update the price list by simply entering a new
Positives and Negatives20 Sep 2005 22:28 GMT2
I need a formula what will tun a positive number in to a negiive.
=SUM($H$5:H6)+(B4)
B4 is a negitive number and so my anser apears negitive, but I would like it
to apear possitive by adding to the formula  not my chainfg any of my numbers
How to report value of zero if calculation goes negative20 Sep 2005 22:14 GMT2
I am doing a simple payroll spreadsheet.  Hours Paid and holiday pay weeks
are entered.  The holiday pay is calculated on an average of 12 weeks.  On
some occasions if an employee leaves, holiday pay taken over the accrued
amount has to be paid back by the employee.
compare values20 Sep 2005 22:10 GMT3
I would like to compare 3 nonajacent values, bold the lowest value and then
take the lowest value and multiply it by a selected rate of currency.
Finding number of values in a range on a per year basis20 Sep 2005 21:49 GMT2
I have a column of data that represents task durations.  I have a separate
column that indicates the year in which the task was completed.  I want to
get a count of the number of tasks with a duration of 0-30 days, 31-60 days,
61-90 days etc. for each year represented on the ...
formulae have stoped working on an excel sheet20 Sep 2005 21:39 GMT1
a spreadsheet i have been using for the past 6 months has just stopped
working the formulae dont work unless u re-enter them again every time
Increasing distance labels using drag down method20 Sep 2005 21:25 GMT2
Here is what I have to deal with.
I have around 1,200 labels that I don't want to have to type in.  I
would like to us the fill down method.  The labels will be as
follows...
Excel Spreadsheet - Formatting Dropdown lists20 Sep 2005 21:10 GMT1
I have set-up a drop down list on a separate worksheet which contains items
formatted in different fonts (red, blue, green, etc). When I reference the
the drop-down list the items are in black font only. How do I retain the
different fonts in the list? Any help would be
The number of hours in a day cannot exceed 24...20 Sep 2005 21:09 GMT2
I have a spreadsheet that is used to manage time sheets and invoices.
The weekly time sheets are on separate tabs and the invoice is at the
beginning.  The invoice tab uses no special cell content type but Excel
seems to thing all of the cells on that tab are formatted to "Time" and
solver problem20 Sep 2005 21:08 GMT1
I am trying to use Solver to optimise  a plan.
I can set it all up with contraints and it says it has found a solution.
The trouble is that this is always whatever the starting point is set at.  I
know that this isn't optimal.
HOW DO I SET UP A CHART WITH FAMILY IMPORTANT ADDRESSES, NUMBERS,20 Sep 2005 21:07 GMT1
I want a database or template so i can store all the important numbers (ie
insurance, home insurance, med insurance,) and the phone numbers that go with
them
How do I get all numbers or cells on entire sheet (/1000)?20 Sep 2005 21:06 GMT3
I want to present a financial report in thousands of dollars.  How can I make
all the numbers on my sheet appear as if they had been divided by 1000
without entering my value and a formula in each cell?
how do i filter multiple columns20 Sep 2005 21:00 GMT1
I am trying to filter morethan one colums. I have 4 columns with differents
numbers. I need to pull out all of the number ones and coresponde to a part
number. my spead sheet kind of looks like this.
1     13     32    52          51623
 
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.