I am doing research on numbers.  I have been entering the numbers in a very
time consuming and potentially error ridden manner....the old fashioned way
by scrolling through the colums and then when I come to the column I want to
add a number to stopping at that column changing ...

i have done a search and assigned either a 1 or a 0 to each row, 1's are
matches.  i want to create a sort that will take all the matches and all
their coressponding data in each adjacent column to the top of the sheet. so
in other word if there is a 1 move the entire row to the ...

I am new to Advanced Excel functions and appreciate any need help with a
project.  I have 2 sheets that need to be compared.  Both sheets only consist
of 2 columns labeled ISBN and COST.  Some data will be unique to each sheet,
while other ISBN data is not.  When a match of the ...

I have a column with the following formula in every row associated with data
(ie. Q5:Q32):
=IF(AND(B25<=L25,L25<480),"2","1")
In the "Totals" cell (Q33), I have the following formula:

I have a worksheet that on Col A I need a "tickler" to prompt me to update a
particular row based on date requirement on column B (i.e., every 30, 60 or
90, etc days).
I came up with a conditional formating on Col A, row 2:

I have included a sample table.
State    Priority    Age    P90 for A____     P90 for B___   P90 for C___
A    1    3
A    1    128

This is proabably simple and I'm just not seeing the obvious.
I have a spreadsheet with numerous columns of data.  The second column
contains names.  I want to sort the spreadsheet by name but maintain the data
integrity of the entire row when it sorts.

Hello;
I would very much appreciate your help.
1) I've developed 12 different (independent) equations y=fn(x), each
equation depends on the value of x::cell H30

The following example is:
a1  0%
a2  0%
a3  0%

Excel 2007
I have a column of numbers, all negative.
Like:
-213.00

How can you restrict a user from entering a value above 100 in a spreadsheet?

Column B = mmm/yy
Column C = Quanitity
Column D = Criteria (nameA, nameB)
I would like to sum column C for all quantities which match citeria in D

I have the following question from a colleague:
I like to solve the following problem. I have an RC address in one cell
of the form, RC6, (current row, col 6). I like to copy and paste this to
another cell (or copy the conditional format portion involving a formula

I have a table reflecting how many members of staff are required per 450
customers. The first column therefore contains 450, 900, 1350, 1800 etc.
Adjacent each customer break is the number of staff required, 10, 20, 30, 40
etc. I want to create an equation which looks at a ...

I have a list of years belonging to different depts with numbers for internal
sales goals.  I want to have a variable field to enter the correct year and
have it display the dept names and numbers for that year.  Example:
     A          B         C            D