I need to be able to protect my formulas in a column. I know how to protect
the columns I don't want edited. However in the column which I allow data to
be input, if someones enters a number in the wrong cell in a row then hits
delete it also deletes the formula in the cell so ...

Sh1 C5:C40 are text values inserted at various times and not in any order.  
Sh1 D5:D40 are numbers that were inserted next to name and Sh1 E5:E:40 are
additional text values added.  In Sh2 C5:C40 are the same text values as Sh1
C5:C40 but in alphabetical order.  I am using the ...

I have a period (4 week) sales goal.  As I complete week 1, I need to know
how much remains of my sales goal.  I created a spreadsheet which tracks
sales for many accounts for one week (or sheet) at a time.  On sheet 2 I need
to subtract the total sales from sheet 1 and show ...

I posted this in the general questions but it's better suited for here:
Hi I need some help figuring out if it is possible to create a formula.
I'm trying to link information from different pages in a spreadsheet that
contain id's for people and prices they are paying for some ...

When using the Correlation Function in the analysis toolpak, I get an error
message if my dataset contains non-numeric fields. Is there a way to get
Excel to ignore fields that are non-numeric?

Hi, I am working in excell 2000  and I would like to write a formula that
would divide a numer in one cell and times the decimal portion of the answer
by the same amount I was divding it by.  Example cell A1 would countain the
amount I entered 5000 I would like cell B1 to divide ...

I'm newly impressed with what Excel can allow me to do, but am running into
an issue which may or maynot be doable...so please help if you can:
I want to find the sales number for a company by year in a sheet that is
organized as follows:

i have the error message that view settings could npt be apllied when in
excel. the sheet contains data and I want to view certain sections under
different and multiple views.

I am trying to lock the scroll, My range is "a1:ar31",  When i save and
close the work sheet and open again the scroll lock range dissappears. is
there any code???. please help. Thanks in advance.
moiz

Don't know does this forumula exists in Excel so I need help.
I need to count different values in range of cells.
Example:
I have cell ranges with this values: 13, 14, 15, 16, 13, 13, 16

when I drag and drop a date format the day value increases by one.  how do I
stop this?  Thank you

I'm working on a muti-page workbook and want to highlight specific dates that
may occur throughout the workbook. I want to be able to type in the date and
it automatically highlight that date if it occurs anywhere in the entire
workbook.

I have 3 date columns (Columns A, B, C) and I need one formula (Column D) to
return the following all inclusive result.  I can get some of it to work but
no all.  HELP! And thanks.
IF B1>=A1     =NETWORKDAYS

I have a spreadsheet that has rows of employees.  The header row lists Name,
Mon, Tues, etc, through Friday, with TOTAL HOURS WORKED at the end.  Each
row, under day of week listed the employee's work hours (ex: Under Monday I
have 7:36 - they worked 7hrs and 36 minutes).  How do ...

I have 3 conditions defined across 3 columns of data, each with 0's or 1's
depending on partnership status of an account.  If all three conditions /
columns are 0, then it is a company direct account.  I want to consolidate
the date into 1 column (Company Direct, Partnered on ...