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 / November 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
formula: count if not blank16 Nov 2006 20:33 GMT1
I have two columns, a date in the left, and in the right a formula to
calculate the date plus 14 days.  For some of the cells in the left column,
there won't be a date right away.  I want to have the formula to calcualte
the date in all the cells in the right column so when i do ...
exact value from supplied Row and Column data16 Nov 2006 19:57 GMT1
Column A contains countries. Row 2 contains years 1996 thru to 2005 (10
year span).
Question:
If someone tells me a country and year, I can give them the data for
change date format.16 Nov 2006 19:51 GMT2
I have an excel 2003 file with 1500 dates in one column .  The format is
10/31/2006  I have to import these dates into Microsoft Dynamics 9.0-fixed
assets.  To import, the date format should be 10312006.  Is there a function
that could strip the '/' out? could someone assist me ...
Convert month number to string16 Nov 2006 19:46 GMT6
I have a master sheet in which date is stored in columns by month.  Row 1 has
the year and row 2 has the month number (1 to 12).
There are presentation sheets that reference subsets of the master data and
on those sheets I would like to display a 3 char string for the month e.g.
Is there a formula can get min value of a range by certain conditi16 Nov 2006 18:44 GMT5
I want to know if I can use a formula to get the min date that task ID "A"
and task type "STK"? Sample data below. I want to get 1/1/2005 as Min date
for task A and Type STK. Thanks much!!
Date                  Task ID                Task Type
IF worksheet function16 Nov 2006 18:40 GMT3
I don't know if this possible, but looking for some help if it is.  I am
guessing it would be with some sort of IF worksheet function.
I have a column of dates.  In a separate cell a few columns to the right I
would like to enter a value (32.50) if the first of the month is among ...
Multiple values to report a third16 Nov 2006 18:20 GMT1
I have two worksheets.
The first is a list of Pipes and specifications
ColA           Col B              Col C           Col D
Schedule    Diameter        Volume        Weight
EOWEEK --- similar to EOMONTH16 Nov 2006 18:01 GMT3
Hi,
   I know there isn't and EOWEEK function, but there should be :)
   I get lots of requests each day and want to run them through reports
showing incoming per week, etc...
Counting the number of Error Types16 Nov 2006 18:01 GMT3
I'm trying to determine which error types exist in a fairly large worksheet,
so I wrote the following formula to find the number of "#REF!" errors:
=COUNTIF(A2:CY5000,ERROR.TYPE(A2:CY5000)=4)
After manually looking through the entire worksheet I found 2 cells
How do I calculate age from birthdate to present in Excel?16 Nov 2006 18:01 GMT4
I have a list of names with birthdates and would like to calculate each ones
age in years, months, and days from the present day. I am using Excel 2003
SP2. I see how to use the Today function to get the present day. A
subtraction yields the number of days from 1/1/1900. In date ...
Percentage formula help16 Nov 2006 17:08 GMT2
I have 2 figures, 1 I want to add 7.5% to it and get the total, the 2nd
figure I want to subtract 7.5% and get the total.  Have totally forgotten
how to do percentages.
Any help greatly appreciated, thanks.
Need simple IF formula, please16 Nov 2006 17:03 GMT5
I know this is simple, but I don't know how to write it:
In V1262 I need this formula:  If R1262 and Y1262 are the same, then 39 will
appear in V1262.  If, however, W1262 and Y1262 are the same, then it will be
38.  If again, however, W1262 is less than Y1262, then it will be 37 ...
lookup data and fill cells16 Nov 2006 17:03 GMT1
I have 1 sheet that has a column containing many different account numbers.  
I have a 2nd sheet with the same account numbers with the relevant account
name.  I would like to add a column on the 1st sheet which looks up the
account number on the 2nd sheet and brings back the ...
can I sum one column if the value of another column is ex. "M"16 Nov 2006 16:57 GMT2
I need to sum column D (currancy)  if the value  of column C is an "M"
I've been trying =SUMIF  but can't seem to get it right.
simple currency addition in cell without having to enter decimal16 Nov 2006 16:36 GMT8
I want to add dollar amounts in an individual cell with a fixed decimal
point. In other words, click on a single cell, press =, then enter multiple
numbers (preceeded or followed by the + or - sign) without having to enter
decimal for each amount entered.
 
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.