I have data in every other row in a column from rows A1 to A12455.  I would
like to know if there is a keyboard shortcut that takes me directly to the
last cell (A12455) in the column that has data in it.
Thanks in advance,

I need to find the count of a list of numbers listed in a
column(specific). But where the number exists more than once I need it
to be counted only once. In the example below this formula should
return 4 as the answer. Thanks in advance.

I need a formula that works like this.
Cell A1 has a name
Cell B1 has a date
Cell C1 has a number

I have a formula and have been able to achieve my initial formatting thanks
to everyone's help.
Now I would like to have variations to the formatting that would cover the
following criteria: Let's say that the results of the formula are less than

i run a spreadsheet that calculates commision for sales people
Column I is  a product list - 40 products or so
Column P is total sales value
Column Z is the name of a sales person who shares the commission with the

I want filter records based on the color schemes. I this feasible?

I have an issue with excel:
cell c7: 123200 (entered direct into cell-not calculated)
cell d7: -123151.6 (entered direct into cell-not calculated)
cell e7 forumula: =sum(c7:d7)

I think it's going to be difficult to satisfy my requests.
Anyway, I have a list of symbols in column A like the following:
00001 = xxx (it refers to...)
00305 = ysu (it refers to...)

I am trying to create a formula that will identify how many instances (rows)
there are, where within each row it much contain three varibles.
volvo    V70    black
ford    mondeo    blue

Can anyone help me I am trying to use the nested IF formula to add more than
one criteria prior to counting the number of
instance a value appears in a table.
     A    B    C

I'm want to use an "IF" formula to compare the values in two cells and return
the following...
IF cell A is equal to cell B I want the formula cell to be yellow with a "Y"
in it

If there any way that you can incorporate a tick box in to a formula, I
want something along the lines of.
If tickbox is unchecked then Sum(a1:a5), if tickbox is checked then
sum(a1:a5)/2

I am trying to do a two cell accumulator and I am having trouble
getting it to work. It keeps coming back with an circular reference
error and it's not adding up when I put in a value. I would like to
place a number in say cell C13 and have it add to cell G13. G13 is

How can I use a validation list from another worksheet?
Thanks in advance.
EP

I'm wondering if its possible to create a formula or some other cell
function that compares the values in two cells and draws an arrow
accordingly... for example, if we are comparing current month sales to
previous, the value in cell A could be 10 (previous month) and the value ...