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 / March 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
How do I add comments to a protected sheet?18 Mar 2008 17:07 GMT1
This worksheet is shared for multiple users and is protected so format can
not be changed.  Need ability to add comments to certain columns with drop
down lists.  Comment icon is not available when protected.
Link to a named range in another worksheet that is sorted frequent18 Mar 2008 16:32 GMT2
I want to create a link for each charge number in ChargeNumbers.xls that will
open the related project details for that charge number in another workbook,
Projects.xls. I've created named ranges for each project in the Projects
workbook (columns A & B).
Bit of a complex SUM18 Mar 2008 15:30 GMT4
I've got a large worksheet doing a variety of calculations. One section of
the data looks like:
A     ....    F        G            H        
6             one     four    
Worksheet Function Keeps Changing, need help18 Mar 2008 15:11 GMT2
I've created a worksheet function that counts based on various conditions.  
I got some help on these forums in creating it, and now I hope someone can
help solve a new problem.
The formula is: =SUMPRODUCT(--('Grindex
Cannot shift objects off sheet18 Mar 2008 14:03 GMT2
I am trying to hide many columns in a large Excel file. A dialogue box
appears stating: Cannot move objects off sheet. The box prevents me from
hiding any columns. All filters, formatting, hidden panes, frozen panes, etc.
are turned off.
FORMULA NEEDED18 Mar 2008 13:43 GMT10
IF Q1 CONTAINS THE WORD "OK", I NEED THE CELL TO READ "YES"
iS THERE ANYWHERE I CAN GO TO GET A BASIC HOW TO FOR CONSTRUCTING FORMULAS?
iF i JUST HAD A LIST OF WHAT SITUATIONS CALL FOR WHAT FORMATTING, I WOULD BE
FINE.
linked formula on multiple sheets18 Mar 2008 06:59 GMT1
I have a very simple linked formula ( i.e.  =personnel!C1  ) which I
use on multiple sheets to reference the "main" sheet titled personnel
and cell reference C1.
( lets title the sheets for simplicity   1) Personnel   2) Task   3)
Exterenal link18 Mar 2008 06:47 GMT2
I have a workbook that contains 18 spreadsheets and someone in the office
accidently linked data from a different workbook. I have searched this
workbook and cannot find any formula with an exterenal link. Also the
spreadsheet being linked from, no longer exists but every time I ...
how to increase from 4 to 9 previous files under FILE in Excel18 Mar 2008 05:00 GMT2
Using EXCEL and clicking on file the previous 4 files opened are shown; can
this list be increased to say 9 or 10 files
Return Min based on 2 conditions18 Mar 2008 03:48 GMT4
I am trying to return the Min in one column, based on criteria in 2 other
columns. Example:
Title     Region    Pay
SM       NJ          $10
how do you make the following formula count 1,2,3,18 Mar 2008 03:20 GMT7
I'm using the following formula, but have to add the number lines manually. I
know there has to be a formula to ease my burden.
=COUNTIF(B$2:B1199,(1)), one being #1,  =COUNTIF(B$2:B1199,(2))
Percent constant18 Mar 2008 02:20 GMT1
I'm trying to have a percentage calculation continue down the column. I have
amount owing in A2, amount paid in B2, balance in C2, interest on that
balance in D2.  
I want to have E2 include the balance from C2 plus the interest calculated
Evaluate 5 columns and return right-most name18 Mar 2008 02:07 GMT7
I have 5 columns containing different supervisor levels.  Some columns are
blank.  I would like to write a formula to evaluate the 5 columns and return
the name in the farthest right column.  Thank you!
a little complicated18 Mar 2008 01:12 GMT7
Here is what I am trying to do.
I have 3 sheets (A, B and C) for 3 different processes to track the overtime
of the employees.
I have a summary sheet on which I have a dropdown that lists all 3
Selection of Columns for SUM18 Mar 2008 01:03 GMT6
I have a table for sales in each month of the year (have used only 6 mths is
example) and want to be able to calculate the total sales for any given
period. The given period.The "from" and "to" will be  sourced from two  other
cells, I have put these cells in " " in my example.
 
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.