Functions

Counting specific letters in multiple cells
Hi, Lets say I want to look for the letter "O" in a cell with the text "How are you?" and count the number of "O" in that particular cell, the formula would be something like: =LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),"O","")) and the result for "How are you?" will return 2. My question is, what if I want to do it... 4 Jul 2008 16:09

Calendar or date formulas
I have a date on one column, and would like the column next to it to autmomatically calculate 6 months on, and auto fill with that date. I'm sure there is a formula for it, but I can't find one, or I'm entering the wrong question into the search. Can anyone help here? Many Thanks in Advance. Sarah M. ... 4 Jul 2008 05:55

Removing unwanted columns in a list
I have a list where users have selected. If the all of the data cells are not complete then I want to exclude the cells from the analysis that will follow. To do that, I change the name of the item to "ITEM_NOT_AVAILABLE_FOR_ANALYSIS". On separate tabs of my workbook I want users to use a drop down list of... 4 Jul 2008 04:54

yes / no formulas into 1/0
Hello all i have seen that a person has asked if this can be done as a block of three but i would like to do this on a larger scale will the formula still fit. to count the yes's as 1. ... 4 Jul 2008 21:16

Stop text carries over
We all knows that long text will carries over to the next empty cell, but how to stop it. That is the long text in cell A1 will not carries over to cell B1 ... 4 Jul 2008 05:55

Protect columns with password
Hi, Is it possible to protect columns in a spreadsheet with a password? I would like to hide the contents in specific columns from unauthorized users. Thanks! ... 4 Jul 2008 02:51

Wrap Text Problem + a little VB :)
Hello everyone! :) I'm an excel newbie and i need your help with something. I have a project where i created a workspace with several sheets in it. I use the 1st sheet as a template to enter all information and the data is spread to the other sheets using the obvious command: =Template![A-Z][#]. My problem st... 4 Jul 2008 13:05

not working for me
I have tried all of the suggestions/guidance here and in a KB article of the same subject and I still have the same prob. All I get is a formula in the intended destination. How do I get a simple SUM? Very frustrated. Any help you can provide is greatly appreciated ... 4 Jul 2008 02:51

How to calculate avg from various rows
Hello! Pls excuse if this is a repost. I was logged in, and after I clicked on Post, the stupid thing wanted me to verify my email addr and my identitiy again, and I had to log back in, so I'm posting again - ARGH. I've been searching for hours and just can't find what I need. I found many articles from Bi... 7 Jul 2008 00:14

How to calculate an average from various rows???
Hello! I've been searching for hours and just can't find what I need. I found many articles from Biff, but haven't found examples that meet my criteria and scenario, so I'm turning to you all, 'cuz I believe there's a solution out there somewhere! I'm not too experienced with Excel and formula's, nor the na... 7 Jul 2008 05:19