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 / August 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Combo Box Values not Numbers17 Aug 2005 13:41 GMT8
How do I get a combo box to return values not numbers. My combo box
displays January - February, but my linked cell only displays 1-12. How
do i get what is actually in the combo box to appear in the linked
cell.
Can I make the number in one cell automatically appear elsewhere?17 Aug 2005 13:12 GMT2
If I enter a number in one cell in my workbook, I would like it to
automatically appear in several other cells.  The 'destination' or 'target'
cells cannot have any formula in them.
I need to be able to enter any number in the original cell and can use
Month Counter17 Aug 2005 13:11 GMT2
Does anyone know how to count months between two dates.  I want to be able to
go beyond 12 months.  01/01/2005 - 01/01/2004 = 13 months.
Month(Date2)- Month(Date1) = will only give me answers from 1 to 12
I was originally using the formula :
'vlookup' and/or 'if' help!17 Aug 2005 12:53 GMT5
Hello...i'm in charge of conducting a physical training test and have a
table already created with the parameters of the test. Here is a
partial table:
%    1.5 mile  300m    Bench     sit-ups    push   vertical
Conditional functions17 Aug 2005 12:48 GMT1
Can someone please help, I want to achieve the following.
2 worksheets, results and data
Data sheet has the following colums
Size    Wegcost    Cempcost
MsgBox with condition and showing details17 Aug 2005 12:38 GMT2
I have two columns, one called NAME and the other BIRTHDAY. I want a MsgBox
that appear when a cell in BIRTHDAY take place during the current month, and
display the name of the person.Something like "JASON, PETER and JOHN HAVE
BIRTHDAY THIS MONTH" . Moreover, I want the MsgBox to ...
excel, how do I get sumif with two criterias?17 Aug 2005 10:20 GMT1
I've got a table with many columns and I want to add the last left column but
using two criterias for two different columns.
the option to send an exle file as an attachment is not there17 Aug 2005 10:20 GMT1
I do not have the option to send an opened XLS sheet as an attachment to be
sent thru Outlook express ?
Regards  
Sandeep
time conversion frustration17 Aug 2005 10:09 GMT1
I have a cell giving total minutes (using SUMIF) and need to convert the
total into hours and minutes (real time, not decimal) for costings.
=SUMIF(B4:B200,B8,K4:K200)
the total for the cell (eg. S11) needs to be shown in hours and
Sumproduct Problem17 Aug 2005 09:39 GMT4
I have a spreadsheet that documents details about files contained within a
document repository.  There is a data sheet containing an audit history of
all actions that I run formulas against.
I use the following formula to successfully return the date when the last
Future Value17 Aug 2005 09:24 GMT2
Can you please help me to apply a formula in excel where I can find a future
value of an investment "X" years from today, according to the following
example:
Present Value: $4,000.00
conditional sum question17 Aug 2005 07:28 GMT6
I want to add a range of values, but they are formatted differently:
some of them are formatted with the dollar currency, others with the
euro currency. Excel treats them equally, as numbers, but I need to
make different sums automatically - I want to add only dollars or only
data analysis on fields with words not numbers17 Aug 2005 05:49 GMT3
How can I get the total number and percentage of for each different
word in a column which has several word descriptions? What function do
I use?
if functions17 Aug 2005 05:41 GMT2
I have the following problem:
In sheet 1 I have :
Column A > party codes (Customers)
Coloumn B > Bill number
select a string of characters17 Aug 2005 04:25 GMT7
I have some large cells with various data, some (not all) contain a unique
string of charaters which I would like to extract to another cell. The string
of characters is two alphanumerical then six numerical then one
alphanumerical. For those in the UK, like National Insurance ...
 
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.