I have the folowing situation:
        A       B          
01  Day   Val
02    1      12

if cell a1 contains text (10-22-198) how do I write a formula that will opy
only a section of the text to another cell.  Ex I would like to be able to
take one of the sets of numbers and populate into another cell.  But I want
the formula to run through out the column so if ...

I am collecting a series of data labelled numerically from 1-1000. I need to
determine which in the series are missing. ie I know I have 750 data elements
out of 1000, so I know there are 250 missing. But I need to detmine which
specific data elements are missing.

I received a spreadsheet attached to an email.  I saved it into My Docs
folder and dressed it up a bit.  Noticed that the formulas round differently  
i.e. the original spreadsheet calcs 6.15 and the copied one calcs 6.14 the
formula is 27500/4475.  It is displayed as =+a24/$c$6.  ...

I am trying to figure out how I can return the values of multiple cells into
one (Merged group) cell for a cleaner presentation, any suggestions?

I have got a text string as below
She is a girl,,,,,"I am a boy",""
What the formula should be to extract the string between ,,,,,"  and  ",""
so that the result comes out with      I am a boy    ?

I am trying to link to several workbooks elsewhere on my computer, each book
has one sheet per month and a total sheet, the sheet i am working on will
contain all the same sheets but i want it to add up each month from the other
sheets so i get a total for each month and a total ...

I need all the dates in Column "D" to reflect dates in Column "C" with 75
days added.  The datesv in Column "C" will be different.  How can I assign
the formula to affect the entire column minus the title row. Thanks.

We have the need to look up a contact number on spreadsheet A and find that
contact number on spreadsheet B.  Spreadsheet B may contain that same value 1
to 20 times, and we can only get it to return the first value it finds.  How
do we get ALL values from Spreadsheet B to ...

I'm in a spreadsheet with a lot of data and two of my conditional formatting
options are already used, so I only have one left.
I would like rows that have a due date of today or earlier to be green but
all others stay the way they are (i.e. black).

I'm trying to compile an analysis of my accounts.  I keep entries for
purchases on a worksheet for each month.  I have various columns for credit
cards, cash, switch etc.  I enter a brief description of the purchase then
enter the amount in the relevant column next to it.  I have ...

I have a list of numbers that corresponds to a list of data (for example, a
list of test grades by student name).  Is it possible to sort a second list
of numbers (associated with the same data) to match the order of the first
list?

I am trying to graph my stores department sales for three years.  X- axis
will be each department with three bars above it (2004, 2005, 2006).  I get
this far.  Next I am trying to use a second y-axis on the right to graph the
sum of the department sales for each year.  This is ...

Can anyone offer guidance, preferred way to compute final outstanding balance
of a loan,  with additional non-periodic (irregular) withdrawls and irregular
payments made against loan over time, and exposed to variable interest rate
over various date ranges.  Time period spans ...

I am trying to colour a cell based on another cell's value.
I have a table with 4 status titles e.g. green, amber, red and blue. If the
value under the 'green' cell is greater than the values for 'amber', 'red' or
'blue', I want the target cell to be coloured green.