Functions

COUNTIF Formula
I am using an excel spreadsheet to keep track of ratings. Count A and C. The spreadsheet used to updated automatically when A or C was entered, but now it does not update automatically. I have to re-enter the formula everytime a enter new data. Can you help? ... 23 Apr 2010 13:55

Need a code
I need a code that does the following: If C3>D3, B3 value will start blink and if C3<D3, E3 value will start blink. Any help please. Thanks in advance. ... 23 Apr 2010 16:11

VLookup between date ranges ?
Sorry 'bout that. Somehow it got send too early. Here is my table representing A = Pay Period Week, B = Sat date of week begin. If I manually enter any date, e.g., 4/8/10, in I need the lookup to produce the A3, because 4/8 is in that week. 4/10 to produce A4, 4/16 to produce A5, etc. Something like if >= B3 ... 23 Apr 2010 12:52

VLookup between date ranges ?
A B 2010082 4/3/10 2010091 4/10/10 2010092 4/17/10 2010101 4/24/10 2010102 5/1/10 2010111 5/8/10 ... 23 Apr 2010 13:55

Excel Formula for years and months
If the formula for number of years is =Year(latest date)-Year(earlier date) this formula only show the nubmer of years, and I would like it to show the number of years and months. I need help with this formula: A B C Year Year Service 01-Sep-89 31-D... 27 Apr 2010 01:04

Looking for the sample file
I am looking to check out xReacher21.xls to see if it will do what I am looking for. Unfortunately, the link is dead. Any chance of posting a new link for the file? T. Valko wrote: Here is a small sample file that uses formulas to do this.xReacher21. 03-Dec-09 Here is a small sample file that uses formu... 23 Apr 2010 11:48

How can I make a drop down box visible within a worksheet?
this was VERY helpful!!! Please ignore further instruction below because everything below is actually more confusing...and Bonnie, you're method is elementary and doesn't address the question "Peo Sjoblom" wrote: Office button > Excel Options, make sure "Show Developer Tab" is selected. Click the Develo... 19 May 2010 14:55

ODBC Query
Is there a way to have an ODBC query when refreshed simply insert the new rows into the spreadsheet, thus preserving any data in adjacent columns which needs to stay with the original rows? -- Laddie ... 23 Apr 2010 10:46

Despite formula I use (for example SUM) result is always zero.
Despite formula I use (for example the most simple SUM) it always shows me zero result even it should show a lot more. Values in other cells (cells that I sum) are in number format. Why this happens?? ... 26 Apr 2010 08:03

How to select other random cells
I have a 2 part question. I want to have a 1 question survey randomly filled out by 200 people. Column A lists the 1 questions. Columun b has ABCDE listed in cells B6 to b10. I would like 200 samples in columns c, d, e, etc. How do I set this up so that they randomly Coose B6 to B 10. Second part. On anot... 23 Apr 2010 10:46