When scrolling down rows, is it possible to have rows
highlighted when cursor crosses row?

The VLookup function searches for value in the left-most
column of table_array and returns the value in the same
row based on the index_number.
Question is>>>

Why can you not enter 9 or 10 for the nper in the rate
function?

Is there a way around the if statement limit???
TIA,
_Bigred

I have a string of numbers.....123456789, all in one cell.
How can I split, or un-concatenate this cell into three
cells?  i.e. 123 456 789
Thank you.

I have a row of forecasted numbers that I want to average
based on the current month. In the example below. I want
to use the today function to determine if a date has
passed and then average numbers from the first month

I would like to do the following: Whenever a certain
workbook is opened, a chronological number on the first
sheet should be increased by one.
Is there a count function for number of file openings?

I have a worksheet like so:
     ColA     ColB     ColC
row1   Y        June4    BOX1
row2   N        June4    BOX3

I have excel 2000. I am trying to count the number of
times the word "good" appears in a selected range. I am
using this formula
=Countif(A1:A9,"good")

I need to find a formula that will calculate an age in
years and months.  When i use a regular formula I get an
answer (eg  40.8) but this is 40 years and 8/10 months,
what I need is years and months exactly.

Is there a way to sort your worksheets within a excel File
for exsmaple I have A-T and I want it to go T-A is there a
better way to do this then moving the worksheets by hand.
Thanks a bunch.

I'm not exactly sure where to start with this formula.  Everything I have came up with hasn't worked.
I have a column to represent each day of the month.  Within those columns is different values for each day.  Those fields are populated by a lookup function.  So it does result in ...

How do I get excell hh:mm time translated into decimal form?
I want to be able to say if minutes is between 53 and 7 then round t
00.  If 8-22 round to .25 etc.
How would I go about that

A Custom format of ["HI "@] and an entry of "BRAD" in the
cell will output "HI BRAD".
Also a Custom format of [00] (zero zero) with an entry
of "5" will output "05".

I need to print multiple copies of a spreadsheet and with
each copy change the numberic value of a cell equivalent
to the number of copies.  I mean that the first copy will
have number "1" in the cell and increment up so that the