Functions

COUNT CONSECUTIVE ENTRIES IN COLUMNS
i have a column that returns "UP", "DOWN" OR "FLAT" BASED ON ANOTHER FORMULA. MY QUESTION IS, I WOULD LIKE TO START ANOTHER COLUMN THAT KEEPS A RUNNING TOTAL OF HOW MANY CONSECUTIVE DAYS HAVE BEEN POINTING EITHER "UP" OR "DOWN". IT NEEDS TO RESET THE COUNT EACH TIME THE DIRECTION CHANGES. Thanks micoz ... 7 Feb 2010 12:00

"Disclaimer"
I need to put a legal disclaimer on all printed excel pages. The disclaimer is too large to put in the Footer. Any ideas on how to do this? ... 11 Feb 2010 18:30

Track Changes History Worksheet
In a shared password protected workbook, I would like to keep the History worksheet displayed all the time. Currently, every time I open up the workbook, I have to go to Track Changes and click on List Changes in a New Sheet. Thank you for your help! ... 5 Feb 2010 12:51

Formula for if name begins with and date is less than or equal to.
Im trying to create a formula that gives me a total count for cells that are less than 02/05/10 and the name begins with FHLM, on previous post teethless mama helped me w this, but im still getting a value of 0. Someone please help!! =SUMPRODUCT(--(E1:E100<=DATE(2010,2,5)),--(LEFT(U1:U100,4)="FHLM")) Tha... 5 Feb 2010 11:42

Nested subtotals in incorrect order on large worksheets
I have found that the higher level subtotals are in the wrong order on long spreadsheets. Has anyone else got this problem or solved it? ... 5 Feb 2010 12:51

Finding the combination that appears more times
Hi everybody i have a list on excel 2007 that displays the purchase of items on columns A:E, each column showing one (1) item I want to find what combination of items appears more times, especifically, which combination of four (4) is the favorite mix eg: A B C D F A C D E F B C D E... 12 Feb 2010 16:52

Function needed
I was curious if there is a formula that I can use to check if a cell contains any of the values below? "Q3", "0308", "Q#3, "0408AU", "0408SL, "0408", "0109", "0209", "0309", or "0409" ... 5 Feb 2010 11:42

Growth rate
Daear, all! I have a problem with the following: There are some numbers in column: 10000 15252 32545 1545 I need an avarage growth/drop for these couple of years. I've tried with XIRR formula (but does add-ins do not function). So, i need the formula to see how much growth or drops were in between f... 5 Feb 2010 06:08

data consolidation
I created a worbook with multiple pages. I then consolidated the data. I had to save it under a new worksbook name. In this new worksheet I need to be able to update the information and have it update the consolidated information. How is this possible ... 4 Feb 2010 23:37

Question About Sorting
I want to make a spreadsheet that shows multiple book authors and the books they have written. I want to set it up so that I can sort the list by last name of the author, but the books they write need to go with their name as it is moved. I have tried using column A for the author and column B for the books, ... 5 Feb 2010 15:06