| Thread | Last Post | Replies |
|
| how do i create an option button in a spreadsheet? | 15 Feb 2008 00:19 GMT | 1 |
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 GMT | 1 |
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 items | 14 Feb 2008 23:40 GMT | 9 |
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 GMT | 2 |
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 0 | 14 Feb 2008 22:21 GMT | 1 |
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 formulas | 14 Feb 2008 20:52 GMT | 2 |
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 Date | 14 Feb 2008 20:21 GMT | 1 |
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 error | 14 Feb 2008 19:29 GMT | 10 |
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 decimals | 14 Feb 2008 18:47 GMT | 2 |
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 dates | 14 Feb 2008 18:13 GMT | 4 |
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 GMT | 1 |
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 GMT | 4 |
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 functions | 14 Feb 2008 17:36 GMT | 1 |
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 money | 14 Feb 2008 17:07 GMT | 5 |
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 cell | 14 Feb 2008 17:05 GMT | 6 |
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.
|