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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
If statement based on currency format19 Sep 2006 15:40 GMT4
I have a spreadsheet that has a column (column B) of numbers.  Some of the
numbers are formatted in Euro currency and some are formatted in USD currency.
I would like to put a formula in column C to automatically calculate the
currency conversion of the Euro to USD.
Excel adds significant digits, resulting in errors in calculations19 Sep 2006 15:27 GMT6
I have data from an 8th grade science lab - before and after measurements of
mass.  We are plotting a histogram of the differences in mass for a set of
data.  However, when I plot the histogram, the results do not match the data,
which is significant to 2 decimal places.  Excel ...
Offset Question19 Sep 2006 14:49 GMT1
I have the following OFFSET formula in a named range
=OFFSET('Summary Data'!$D$2,0,0,LASTROW-30)
I want to modify it as follows
'Summary Data'!$D$2 ->
How do I calculate exact difference between two dates in y,m,d.19 Sep 2006 13:42 GMT3
I want to calculate the difference between two dates exactly in years, months
and days. Say between the dates 14-02-1980 to 28-02-1985. The difference is 5
years, 0 months and 14 days including both the starting and ending dates. But
excel does not give the exact answer. Pl help ...
Naming Sheets using a range in another worksheet19 Sep 2006 13:02 GMT3
Is there any way I can put names in a range on one sheet and  then
automatically rename sheets with the names listed in the range without
manually renaming each sheet
COUNTIF for numbers of dates in column which are 30 days older than today19 Sep 2006 12:58 GMT3
I have a column with dates.  I need a count of how many of these date
are older than today's date.  I tried:
=COUNTIF(L7:L155,"-(=TODAY())>30")
and it returns 0
formula that writes to a *different* cell?19 Sep 2006 12:55 GMT2
I have 2 columns, a and b, as follows -
     a1 0
     a2 1
     a3 text
wildcard characters, can they be used in tables to be searched?19 Sep 2006 11:41 GMT2
I have several tables of data that I am returning into a long ten digit
number using V-lookup.  The data typed in can vary, and thus so does the
resultant 10 digit number.  I would like to return specific comments in
another vlookup equation based on that ten digit number.  
Soccer betting excel19 Sep 2006 11:23 GMT1
Would appreciate a great help ...
I am entrusted to make the excel sheet for the Bundesliga here for the
only reason i come from India and i am supposed to know Programming.
Well jokes apart ... the excel contains the dates of the game, who all
Help with Duplicates19 Sep 2006 09:16 GMT3
I need to use duplicates for good! I have two sheets and I need to figure out
two formulas. Both Sheets have similar information. Column A has UPC codes
and Column B has a numeric value. I want the first formula to compare every
UPC in Sheet 1 to every UPC in sheet 2 and if it ...
Loan Compound Interest Function19 Sep 2006 09:01 GMT2
I'm trying to create a function to allow me to calculate total interest paid
on a loan.
* The interest is calculated daily (using "annual rate/365" to calculate
daily rate)
Charity Auction Worksheet. - Copy a row of data - THANKS19 Sep 2006 08:43 GMT1
I am providing some volunteer work to help a group of ladies that raise
money for children and community at Christmas time.  Last year I observed
that mass confusion when trying to correlate Auction Bidders/Auction
Items/Winning Bidders after the Auction.
how do I get excel to use tab to move in a sheet19 Sep 2006 07:26 GMT1
In my sheets I have several areas that needs filled in by our dispatchers,
these areas contain info such as "fuel on board" "fuel used" "lock delay" and
serveral other areas (approx. 45 different cells are filled in out of a
grouping of 80 (5 across x 16 down)). My sheet has ...
Automatically fill info from another spreadsheet?19 Sep 2006 06:53 GMT2
I have two seperate spreadsheets, one inventory (A) and one for customer
orders (B). Is it possible to enter the name of product in spreadsheet (B)
and have the next cell automatically fill in product number from spreadsheet  
(A)?
Attachment files19 Sep 2006 05:32 GMT2
I received an Excel file from someone and I found there were a few Acrobat
icons attached at the bottom of a worksheet. It is somewhat like attachments
in Lotus Note mails. When I clicked the icons, they opened pdf. files in my
Acrobat Reader program. I find it is useful in my ...
 
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.