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 / January 2004

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Excel Functions: Countif Problems26 Jan 2004 21:27 GMT3
75.00%    33.33%    41.67%
A      B               C
37.65    50.00    37.64
33.48    39.74    46.95
Sorting of mixed zip codes (5 digit and 9 digit) in ascending order26 Jan 2004 21:08 GMT3
I have a large mailing list in FileMaker Pro which I export to Excel so that a printing house can take the Excel address mailing list, with the addresses sorted in ascending zip code order, to do a mail merge with the Word document (brochure).  Essentially, they print the ...
Referencing the cell that is calling a function.26 Jan 2004 21:02 GMT5
Is there a function, or constant string that references
the cell that is calling the function, without putting an
explicit R1C1 reference as an argument?
For example, let's say I wanted to use the offset function
I figured out how to protect individual cells!26 Jan 2004 20:46 GMT1
Thanks if you were working on a reply.
Change label column26 Jan 2004 20:32 GMT2
Hello...
usually we use the numbers for files and letters for
column.....example a:1
how can I change the column to use numbers for columns and
Linking in Excel26 Jan 2004 20:05 GMT2
I have a Worksheet that shows a link to three other
worksheets.  I have searched the entire document for this
link and it is not in there.  How can I break the link.  I
need to send this document to a third party and do not
Formula and text within same cell26 Jan 2004 20:01 GMT8
Is there a way to have a formula and text within the same cell?
This is what I want to do:
Date:  =TODAY()
Is there a way I can get the formula to work with the text "Date:" in
If function with date ranges26 Jan 2004 20:01 GMT3
How can I create a IF formula that will state the following
If a persons membership dates falls between the following dates, then label him as Tier Tw
Prior to 7/01/03 = "Tier One
7/01/73-7/26/76 ="Tier Two
Extracting specific information26 Jan 2004 19:48 GMT2
Here is an actual sample of an exported file that I am
dealing with from EasyPay Payroll:
Code :    Name    : Smith,    Jacque  line   
    Type/F   
Automatically update imported data26 Jan 2004 19:38 GMT3
I have 1 excel report that has 18 separate external data
sources, this report then is used to create a statistic
report.
At present all the reports are pasted into the Excel
Can a macro find straight portions of a graph?26 Jan 2004 19:26 GMT2
Hello, I'm not sure if this is possible in excel, but im hoping it is!
Ok I have a very large data set of events occurring at different times
over a 50 year period.  When plotted cumulatively I need to identify
the sections of the graph which have a constant gradient(or near
Using Countif across multiple sheets26 Jan 2004 19:01 GMT29
I am attempting to count the number of non-zero cells in a rang
spanning multiple sheets.
For example, I have the following:
On Sheet1:  A1 = 5
new user question26 Jan 2004 18:54 GMT2
I am trying to use the following expression:
eg:
=IF(A3="","", IF(B3="","offline","online"))
where A3 is a tool number
Recursively using VLOOKUP26 Jan 2004 18:39 GMT2
Wonder if anyone can help me.  The deal is I have two sheets in a boo
one called TABLE_ROWS the other called TABLES (they store databas
table information).  I currently use VLOOKUP to lookup a table name an
populat a cell.  Using:
anchor an object to a cell26 Jan 2004 18:31 GMT1
I have an object that floats on this spreadsheet. I want
to anchor it to a specific cell so that when I resort the
spreadsheet the object will go with that specific row. In
this casae the object is an embedded equation object.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 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.