It's been sometime since I've used this site until quite recently, but it was
my belief that I had access to a list of my questions. Can someone please
help.

I would like to know how to set a formula to check two cells for dates and
then calculate a start date by taking one of those cells and adding lead days
from another cell.  The hard part is making the formula 1) check the
confirmed cell for a date and if no date there then 2) use ...

I've been trying to display the current "time out"  in one cell if another
cell contains a "Y" for work finished.  I used the IF function to tried and
set up conditions, but always receive errors.  If a "Y" is entered the last
column of the sheet for that row, then I need the ...

I've been trying to display the current "time out"  in one cell if another
cell contains a "Y" for work finished.  I used the IF function to tried and
set up conditions, but always receive errors.  If a "Y" is entered the last
column of the sheet for that row, then I need the ...

I have a spreadsheet with 4 tabs of quarterly data (representing four
quarters in the fiscal year-Quarter 1 July-Sept, Quarter 2 Oct-Dec, etc).
That same spreadsheet also has a tab which sums the data on a quarterly basis
(with the idea of creating 4 additional tabs reprersenting ...

I have a report which has some grouped rows. The normal view of the report
shows these rows grouped, and therefore only shows the total of the
hidden/grouped rows.
I want to protect certain cells in the report so they cannot be modified,

Hi, I have list range where I put data validation to prevent users from
entering wrong options. Then I put a drop-down list that is populated from a
dynamic range of a list of valid options in another worksheet (same workbook)
and set up the data validation to show an error ...

I'd like the contents of a cell to "blink" if certain conditions are met.  
Any way to do that in Excel?

I am trying to create a drop down menu that will go to the specific
cell where that same text is in a worksheet when that text is selected
from the dropdown menu(combobox).  I made a combobox menu from the
Forms menu not the Control.  The text I am trying to find with this

I am trying to use =VLOOKUP(I14,T:U,2)
When I14 is the time value 19:50 or 0.826388888888889
My table T:U has all the times from 00:00 to 23:55 in a sorted list of 5
minute intervals

I'd neet to get weekly averages in a Pivot Table. The source data may contain
several lines for one week. How can I get AVG weekly volume/customer/quarter
from this kind of data?
Any advice is greatly appreciated!

Given the position of a non-blank cell in a column, is there a way to return
the position of the next non-blank cell in the same column?
Example:
   The given position of A1 is not blank.  There is an unknown number of

I would like to calcuate the diff in the dates by in term of months e.g.
30.06.05 less 19.11.04 = 8 months.  What function should I use, could any one
help please.  Thanks

Hi Experts:
I have a Macro that will pop time to a worksheet...the problem is I can't
determine how to make it pop with a left Zero fill if there are no hours.  
Example:  :47:57 change to 0:47:57 whe the Macro pops instead of the :47:57.

I have got a column of data like below:
Y
Y
Z