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 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Function for 3 date columns24 Mar 2006 19:05 GMT3
Here is my issue for dates in Excel (2003).
I have 3 columns with dates for which I want to calculate the number of days
that have elapsed between the date sent and the date received. I am trying to
calculate the the fastest receipt date for items sent.
Formula/function that checks for a set of values.24 Mar 2006 18:59 GMT8
I am not sure if there is a function for this, but I am setting up
schedual using Excel.  I want to create a formula/function that look
at a range and checks each column to confirm that there is at least on
value of “E” “N” and “D” preset.  There are other values that don
Re: Copu worksheet ranges from One Workbook to another from24 Mar 2006 18:19 GMT5
I have a workbook with about 250 worksheets, let's call it MW.xls. All
worksheets have a name(a1, a2, etc). Once a week I copy groups of
worksheets and save them as different workbooks(let's say wb1.xls,
wb2.xls). Those workbooks get updated and emailed back to me. I receive
Tracking changes24 Mar 2006 18:03 GMT1
Is it possible to have Excel automatically insert a comment to a cell when
data is added/changed? This data could be the date and pesons name for
instance.
tia
auto fill sequence...24 Mar 2006 17:59 GMT3
I am sure this is simple but cannot figire it out.  I don't use Excel
that much but need to create a large table.
I have a list of numbers that I want to sequence as I drag fill
handle.
Selecting rows based on cell entries24 Mar 2006 17:56 GMT3
I want to select specific rows from a sequential list based on a cell
value.
Example:
Name:                       Age:
help! printing locks up excel24 Mar 2006 17:42 GMT13
Hello, I have a workbook that contains several macros and many formulas. It
works beautifully until I try to print or do a print preview. Then it locks
up excel and I have to restart. Any ideas about what is causing this?
Thanks!
refer indirectly to Name24 Mar 2006 17:30 GMT5
My application has a large number of related look-up tables.
Each table is defined as a Name. In each row of my main worksheet, I can use
data to calculate the Name of its relevant table as text.
But how can I look up the table?
Auto  Change in Cell Color24 Mar 2006 17:28 GMT1
I have a list of stocks like this:
Stock   Price
ABC    0.35
DEF    0.35
Hot key for time?24 Mar 2006 17:15 GMT2
I have an employee who needs to complete a time ananlysis where he records
how much time he spends on various tasks each day. I thought the simplest way
to do it would be to create "hot key" in Excel, so he could point to a cell,
hit a key (say, F8, or shift-F8) to put the ...
TODAY function question...24 Mar 2006 16:37 GMT4
This should be a pretty easy question. How do I (or can I) insert text and a
function into the same cell.
I want one cell to say: For the Week of: xx/xx/xxxx (TODAY ( ) -7)
Any help would be greatly appreciated!
Excel 2003, need formula that meets two conditions then divides sums of numbers24 Mar 2006 16:08 GMT2
I have named ranges for CustID, CustType, Tons, and NetSales, sorted
alphabetically by CustID.  I need to find "PerTon" for each customer
(the sum of NetSales divided by the sum of Tons).  I need an array
formula that gives me the answer to: lf Y2 = CustID And X2 = CustType,
Using the wotksheet name in a cell24 Mar 2006 15:33 GMT4
I would like to display the worksheet name is a cell, is that possible
(how)?
something like =me.name
regards
Automating text in a cell24 Mar 2006 15:06 GMT4
Is it possible to apply a formula to a cell so that as soon as it is clicked
into, a prefix for an order number wil appear, leaving the user to input the
actual digits of the order no after the text?
IE. upon clicking the cell, the text "JW/R" would appear and the user could
Lookup Values in Table24 Mar 2006 15:04 GMT2
I have a data table that looks like this:
1/1/06     1.2     35     7.5     70     8.5     10
1/2/06     1.2     35     9.2     27    
1/3/06     1.2     35     5.4     15    10.1     40
 
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.