In my workbook I have a set of numbers that I want to rank.  I have a empty
colomn and when I use the rank function it displays the error window. I know
I am making this harder than needed.  What do I use in the number, ref,
order? The numbers I want to rank numbers E4:E34 and ...

I have a list of several hundred names which I linked to a column of cells
using validation.  Is there a way to begin typing a name and have auto fill
search alphabetically making the section process quicker and easier?

Worksheet is 20 columns x 50 rows. Column C is populated with the string
"Atl." from rows 2-15, with "Bos." in rows 16-33, and with "Cha." in rows
34-46.
I want to automatically insert 10 blank rows, beginning with the first cell

Hello, I am having trouble with a SumIf question that I think would be simple
but doesn't seem to work. Basically I am just dividing two columns but when
there is a zero, it gives me the div/o error message. Here is my current
calculation:

Can someone give me a function to use so that the cell at the bottom of a
column equals the last nonblank cell above in that column?

Is it possible to do a VLOOKUP with a Wild Card? We have various systems that
display the names slightly different for our staff and would like to combine
it all in one sheet. Right now my lookup looks like this:
=VLOOKUP(A2, '[Premier Goals.xls]FTE'!$A$2:$F$100, 6, 0)

I have a long spreadsheet and I have several columns that have  text.  These
cells are not consecutive but is like every fourth cell and I have to count
them to perform operations like calculating percentages.  If i pick a range
of cells (i.e. c6:cu6)  the results are going to be ...

I am working on a financial workbook in excel. How can I link data between
sheets in a workbook? When entering data in one sheet, I want it to auto
update  in another sheet in the same workbook. Here is a example wheat I
want to do......

I have a workbook that has 2 sheets of data.  I would like to have sheet 1
column a go to sheet 2 Column A and look for a match (not case sensitive).  
When a match is found I need the data in sheet 2 columns C:H copied to the
corrosponding row of column V:AA in sheet 1.

I have excel 2003
I have a workbook that has numbers relating to each month of the year for
several different work areas. There are 4 weeks of data on each sheet with a
summary page showing the average for the 4 weeks for each work area.

I have been trying to figure this out but, can’t seem to find a solution.
Please Help.
Cell A1 will show lists of categories (fruits or veggies), cell B1 is
dependent on A1 and will show its items depending on what I choose in A1. Up

how do i make check boxes
--

I have an Excel sheets with dates formatted dd/mm/yy. (eg 18/01/06). I copy
this to a new Excel sheet and the dates change by 4 years and a day - e.g.
the date becomes 19/01/10.
I have tried pasting values, formats but the result is always the same.

I have row D that needs to be over 4.00% to be counted 33%
Row H that needs to be a positive number to be counted 33%
Row L that needs to be a positive number to be counted 33%
and the sum of all three rows add in row P.  The range could be 0%, 33%,

I have one workbook I call test suite. I need to reference a worksheet from
other workbooks which are test cases for software products.  then autopoulate
a worksheet in the test suite workbook. The formatting is the same for all
the worksheets, including the suite worksheet. No ...