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 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Is there a function to insert the worksheet name into a cell?07 Mar 2007 22:26 GMT3
I have MS Office Excel 2003.
Extracting information from table07 Mar 2007 22:13 GMT2
I have a table as follows
           blue     green      yellow
4          jane     heidi        natalie
3         bruce    sharon      fred
Toggle Between Tabs Within One Worksheet07 Mar 2007 21:55 GMT1
Are there any hot keys that allow you to toggle between tabs within one
worksheet?  I am familiar with Ctrl+Page Up/Down, but that isn't entirely
what I am looking for.  Any information would be great.  Thanks.
Macro to move files gets an error if it already exists...07 Mar 2007 21:46 GMT6
I have the following macro snippet that moves a txt file AFTER its
data has been imported into a spreadsheet.  It works great as long as
the file doesn't already exist.
Function TXTFileMove()
Countif?07 Mar 2007 21:33 GMT1
I'm trying to do the following:
Count how many cells (rows) in coloumn A that has the value 1 in Column C
AND value 1 in Column D...
How do I go about this?
Array Help07 Mar 2007 21:24 GMT3
I would like to create an array that is built off of criteria that I specify.
For example, if column A contains numbers and column B contains letters, I
would like to create a formula that would return all of the letters
associated with number 12.  Any help would be greatly ...
difference between + or = in entering a formula07 Mar 2007 20:54 GMT3
I'm a long time MS Excel user and working with it on a daily basis, I
find myself puzzled with it sometimes.
For instance,... What is the difference when entering a formula with a
+ or an = sign?
automatically roll the page number after you print07 Mar 2007 20:43 GMT3
I am trying to create a form that will automatically change to the next
number in the sequence after a copy is printed.  Is this possible in excel
and if so how is it done?
Help! How to Remove Read Only Status on a Worksheet07 Mar 2007 20:22 GMT1
I have put a read-only status on several files--so different branches can
look at but not change.  I think I should have just password-protected them
instead.  I'd like to remove read only status on the files instead of copying
them to different locations---does anyone know how I ...
Time Value of Money07 Mar 2007 19:33 GMT1
I have a number which increases each year by 3% at a certain date. What cell
entry can I input to have this number increase automatically per year
dependant upon that date.
For instance, I have a # 2532, which increases by 3% every year on September
Subtotal of Abs of a range?07 Mar 2007 19:26 GMT3
Greetings!  Am stumped.  Need a sum of the absolute value of row-filtered
elements in a column.  SUBTOTAL does this admirably, but it appears that
SUBTOTAL does not accommodate anything but a simple range as it target, in
the pseudo-syntax SUBTOTAL(Function,Range).  SUM, on the ...
How do I create a CountIF statement for a range of items in a list07 Mar 2007 19:21 GMT1
I want to be able to create a table with one column providing a list of
companies with the counts of their values in a series of other columns. In
the column where the original company data comes from, the company names
appear more than once in the column (but now I am wanting ...
Page & Chart Numbering07 Mar 2007 18:53 GMT2
Howdy-
Here's what I have:
17 tabs in a workbook (8 tabs are worksheets [with single print areas]
and 9 tabs are charts.)
Data Validation for Null07 Mar 2007 18:27 GMT2
i am new to data validation.  I want to create a data validation so that
cells can not be Null.  Should I use Custom and if so, how would I write the
formula.  What is the best way to accomplish this?
How to make a key float in an excel wksh when a person scrolls.07 Mar 2007 18:23 GMT5
Signature

Kelly C

 
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.