How do I search a range of text cells and return value(s) based on my findings?
From C18, I want to search C3:C14, said cells sometimes containing names, to
see if one particular name is there.  If it is, I want to leave C18 blank.  
If it isn't, I want to insert the name in C18.  

For the data below B1>A1 is true.
       A                               B
12/3/07 11:48 AM    12/3/07 1:26 PM
How do I check the dates are at least 1 day apart, or 24 hours apart?

My 2007 version of Excel is unusable. Whenver I make an update, even
something as simple as changing the font size in a cell or cells it takes
forever. As soon as I hit the enter key I get the hourglass, within seconds
a totally white screen with "Excel Not Responding" at the top ...

IF SUPPOSE THESE ARE MY VALUES IN A SINGLE ROW.
P    N/A    P    \    P    B    D    \    \    P
NOW I WANT TO CALCULATE ALL THE
NUMBER OF P'S

I'm trying to subtract to sets of dates to figure out the time between but I
need my formula to exclude all weekends and any hours before 8:30AM and after
5:00PM. I have a formula that seems to work most of the time, but gives me an
incorrect result sometimes. Here's what I'm ...

I have the data below in different spreadsheets. I'm attempting to debug
"sumproduct" errors on one ofthe sheet. Tha same formula works fine in
another sheet.
=SUMPRODUCT((H3:H32="CLOSED")*(G3:G32>E3:E32))

ie I need to tally little athletics results. I need the average of the best
three scores.
These are times (minutes, seconds and hundredths of seconds) and I now
realise we probably should have been entering using colons throughout the

When I open the "open file" window and click on "details" for the View, it
only shows the file names, not the dates.  This means I can't sort by date to
find a file.  Is there a way to change this?

I need a formula to check for status=”Closed” and delivery within 2 days of
requested date.
 A                       B                                C
Status          Requested Date         Delivered Date

I need to calculate the number of minutes between two times on two different
days.
For example:  
2/6/2008  12:35 p.m.

I am working on the following problem and i am stuck.  In the income
statement workseet, project the revenue in years 2 through 4 by interpolating
the increase in revenue between Year 1(3,500,000) and Year 5 (5,200,000),
assuming a growth trend.  The resulting five-years revenue ...

I'm trying to round to the nearest .09 (i.e., 1.46 would be 1.49). Is there a
formula/function that would do this?

I am pulling values from another spreadsheet within the same workbook and  
need to increment the row munber by 1 when moving the formula down 22 lines.
i.e. =+MON!$D$6 is in I62 and =+MON!D7 will be I84
=+MON!$D$6    =+MON!$E$6    =+TUES!$D$6    =+TUES!$E$6

I need to know how to get this column to say: If the hours worked are more
than 40 then take time and a half and multiply that times the difference
between the hours worked and 40 and in that same cell add the regular hour to
the overtime pay.  i've got it about 98% done but ...

I type in the following formula and keep getting the error message that it is
missing a parenthesis. No error message when using the "pop up" window to
assist with the formula but when I hit "enter" I get the parenthesis
notification.  However,  I have added them everywhere I can ...