I have an estimating spreadsheet with links to all my vendors pricing
spreadsheets. I work on a network and a sample path is:
='J:\Depts\Estimating\_Price Schedules\[Sea Group
12.05.07.xls]Agreement'!$F$77

Is it possible to create alternating lines of data using a function, based
on a preceding line?
I need to add simaler products underneath each line of existing data to add
the wood type oak.

I have a worksheet with 15 columns. Column 1 is labeled "Last Name" and
column 2 is labeled "First Name". I need to create a conditional format that
will turn a cell red if a name (first and last) appears more than two times.
I can create a conditional format that will work with ...

Is it possible to perform an IF function on a certain character? For example:
In this model string, 0068T21N00A025T32E5X8Q4C4, I would like to perform an
IF function on the 11th character. If the 11th character = N, I would like
the true value = 0 and the false value = 1.

Hi, I'm sure this has been asked somewhere but I couldn't find it on
google.
How do I make a large set of formulae that looks like this:
Cell B1:   =A5

I am trying to put a Year or blank in a field.  I have to fields for a date:
H2 is Actual
G2 is Planned
I would like the Year from H2 in a C2; however if it is blank, I would like

I have a worksheet that have colums of added numbers.  In the total column is
there a way to not see the 0.00 in the unused total column when I print out
the page?

I hope you can help. I am trying to change the page breaks on my exel 2003
document but every time I click on a line to move it a fat white cross
appears. I am it should be a slim black cross.
Looking forward to hearing form you.

I need to display an image file name in a column if a range of adjacent cells
contain data as this example: If the adjacent cells are blank, I don't want
to display the image file name.
Is there a function to do this?

Is it possible to display filtered fields in a cell on a spreadsheet?
For example I have a column with Numbers. I then filter on the Numbers
and want this specific number to be displayed in a cell which is part
of a title.

I want the formula from one worksheet to another worksheet Example:-
one row Date 03/12/07 is there and at the same coloum number is (1) given
and another row the same date 03/12/07and the number (2) is there,
I want the formula to calculate the date wise and the number coloum, ...

I have a sheet that was generated by the "export" function of a VB program.  
I do not have access to that program's code.  My worksheet ends at column N.  
There are no columns to the right, which is all grayed out.  I selected the
entire sheet and chose "Unhide" to no avail.  The ...

I am having a problem with dollar amounts showing to many decimal places
after the . sign.  I have tried to format the cell to only show 2 places, but
in the word document is shows 6 places after the decimal.

I need to number random conditions as they occur in a column.  The example
show is in its simplest form.
Column A is a list of colors that are selected randomly.  Column B needs to
be the order in which the color code was selected relative to equivalent

I want to have a formula in a cell, return the number of visible records
after I apply an AutoFilter. In other words, I want to return the same value
that I see in the Status bar after I apply the auto filter.
There are multiple columns in the data table. The AutoFilter will be