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 / February 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
how do i create an option button in a spreadsheet?15 Feb 2008 00:19 GMT1
I am attempting to create a form in excel and I need the option button's
toggle feature.  The form is broken down into various sections and I am
wanting to select the answer and have it record as the answer for each
section.  Currently, as I go from section to section answering ...
Vlookup and "value"15 Feb 2008 00:04 GMT1
How do I sum across a table the results of several vlookup functions.
In my table I have three columns. In each column is the result of a vlookup
function. I sum across the three colums , in the fourth column and the result
that returns is "Value".
Counting totals between multiple columns for like items14 Feb 2008 23:40 GMT9
I have a spreadsheet that tracks weapon type and their qualification steps in
two categories (primary and secondary weapon). There are 4 columns in each
category: weapon type, Day, NBC, Night.  
I had this formula in the weapon type column:
nested IF - too many arguements.14 Feb 2008 23:35 GMT2
System error of to many arguements, Need help please.
I tried nested IF but can't get everything in....
In E need formula that reads B 'group' returning "FLAG" if values of C
'Long' and/or D 'Short' are greater then limits established in reference
IF formula:enter value if it occured in the year 2008,otherwise 014 Feb 2008 22:21 GMT1
Hi, I need help creating an IF formula. I need to enter value, if it happened
in 2008 (1/1/2008-12/31/2008), otherwise enter zero.
Let's say this is my chart:
2/12/08          $450
how do I turn off the insert function dialog box in excel formulas14 Feb 2008 20:52 GMT2
I do not want the 2 dialog boxes popping up to help me enter a formula, I
want to just be able to hit the formula key & enter the formula like I used
to in the older office Excel. The pop up boxes slow me down.
Conditional Formating based on Date14 Feb 2008 20:21 GMT1
Okay, I have been working with this for some time, but no I have a problem.  
I am pulling data from a standard document.  The date format from this
document is: JAN 15, 2009  It cannot be changed by using the date format, and
with this format the Conditional Formating will not ...
aconcat UDF throwing a #NAME error14 Feb 2008 19:29 GMT10
I'm attempting to display in a cell a concatenated list of items that
match in an array.  Here is an example:
Data:
    A    B
frequency function with decimals14 Feb 2008 18:47 GMT2
I have a set of 365 different numbers and some of the numbers are decimals
(i.e.: 921.74). How do I use the frequency function to determine how many
numbers in my set fall into certain categories that I want to create. For
example, if I want my category to include all the numbers ...
Countif and dates14 Feb 2008 18:13 GMT4
I need to count datess in a column if they occur in a specific month and year.
Can anyone help?
Signature

Tom

Absolute References (Excel 97)14 Feb 2008 18:08 GMT1
Is there a quick way to change all the references within a wooksheet to
absolute references? Either a function or a VB script?
thanks,
SUMIF and #VALUE! when source is closed?14 Feb 2008 18:03 GMT4
Hi all,
I have stuck one more problem. I tried to search through earlier questions
but didn't find solution.
I have 2 files, first has product code (column A), name and another
Nesting countif functions14 Feb 2008 17:36 GMT1
Can anyone help on how to properly write a function to count the number of
cells in a column with a certain value if they have a corresponding value in
a different column?  For example, I want to count how many times "BIG"
appears in Column B, if the same row has "B" in Column A.
Discounted Value of money14 Feb 2008 17:07 GMT5
I have this following problem.
If a certain amount (P) is receivable after certain period, I would like to
know the present value (V) of that future receipt (P), discounted at a
certain percentage (R).  The discounting has to be done on a monthly basis
count the occurrences of a month in a date&time cell14 Feb 2008 17:05 GMT6
I'm trying to count the occurrences of any given month in a rage where the
cells are in a date&time format. (11/02/2008 11:22:53)
For example in the range A1:A30 I want to count the number of times the
month of February occurs.
 
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.