quiero buscar un valor distnto de cero y cuando mel o encuentre me traiga el
valor que tengo en el renglon 1110 ¿como puedo lograrlo?, lo intente asi pero
no puedo hacerlo:
=BUSCARH(<>0,J2:CR111,110,0)

I'm using Excel 2003.
I know how to repeat column headers on every page (by setting the "rows to
repeat at top" field) but what i'm looking to do is to repeat column headers
only on every manual page break.  Is there a way to do that?

I am working with two worksheets.  Sheet 1 contains data ie A2, B2 etc.  
Sheet2 needs to reference the last column with data on row 2 and multiply by
2%.  When I add another column of data to Sheet 1 I want the formula on Sheet
2 to automatical know to look at the last column of ...

Is there any way of determining the size of an external file from within a
spreadsheet?  Ideally, what I would like to be able to do is something like
IF(FILESIZE(filename)>1000,do nothing,access file)

I have a range that solver is manipulating. I've set the critera to have the
appropriate min and max values, and to be integers.
I also need each value to be "selection without replacement", e.g. I need a
solution where each value is only used once.

I need to determine the # of Saturdays in a given month.  Can anyone help?

I'm trying to get a second table which contains all elements of each
column of the first one, except that the empty-string-output cells ("")
are removed, but one. The first table should remain, the second one can
be either calculated or copied in some way.

I have four little worksheets (one for each sales rep) that all have the same
data (ie. client name, date signed, sales amount, etc).  I want to have a
"total" worksheet that will not only summarize all of the individual sales
persons data, but have the summary sheet ...

I am trying to send a workbook containing macros that I created in Excel 2007
and it cannot be accessed by anyone that does not have the 2007 version.  
What can i do to enable these people to be able to use this workbook and the
macros contained within it?  

Column A has a series of customer numbers and column B has each
contribution from that customer. Is there a way to somehow mark the
largest value in column B for each unique value in column A?

can someone please show me an example of a formula that would allow a value
to be placed in a cell from a formula I have written, only if the answer is
positive, otherwise it would put a zero as the answer?  For example, if I had
a formula that added two cells together, if the ...

how do I create a "new paper size"?

How can I extract the right-most "word" from a cell without knowing
its length, how many words are in the cell, or what the word is and
how many times it might occur in the cell?
I define a "word" to be a string of characters delimited by blanks.

I'm trying to change the format of a spreadsheet to repeat data in certain
cells.  My format is currently:
Column C             Column D
Part Number          Description

I know that you can require a cell/field to be completed in Access, but was
wondering if there was a way to do the same in Excel.