I need to set it up that if they put in a certain date for an "actual end
date" for an action and it is equal to the "Planned Action End Date for open
actions" they will then get a drop down list for the question will this
"action become a control"  which they can only answer yes ...

I would like to use excel for outlier analysis removal - to calculate a
mean of a range but not include or change values that are 2 or 3
standard deviations above or below the mean. Excel has a trimmedmean
function but outlier removal based on the above criteria is considered

i want to know how to determine where (in Points) to position an autoshape
using vba (without recording a macro).
aparently shapes lines etc use a point system to position themselves using
start x axis, start y axis, end x asis and end y axis.

Can you help me out to find out a solution about the following..
I have 4 columns in my worksheet,each of them is validated with List of
certain range.I have to check the left cell is blank or not,if the
previous cell(row wise) is not blank then the next cell will allow the

I have to fill Excel forms form a data given in rows & colums. Every
time I use to copy & paste.
To fill one form I have details in many colum of single row and again
second form from other row & its colum.

Does anyone know how to set the time counter in excel?
such as
if( current time is between 10 am and 11 am,
if(current second is between 01 and 30, "A", "B")

How do I: If a cell contains a value, that cell shows that value.  If that
cell is empty, that cell shows zero

I will reword my previous question because after looking at it I think I
worded it incorrectly.
I have a database that collects customers surnames, middle names,
address, towns, etc. So if we take the first entry under surnames I

COUNTIF(range,criteria)
=COUNTIF(A2:A26,A32) would check the no. of times the value in A32 is
getting repeated in the range A2:A26.
How can i define the criteria - that the formula should check the no. of

I need to count if value in one column is met & if value in other column is >0
A                B                      C
Trailer        Bike                County
1.00                                adam

there are more than 80worksheets and i need to know which sheets have a
blank cell  for C6 from the entire worksheet.
any help would be appreciated!

I'm looking for a formula that will reutrn the last non-zero value in a row.
TIA.

If I have a date field in Column A, how do I set Column B to be Col.A+ a
certain number of days, where that number of days would be a figure set in
for example C1.
Sorry if this is simplistic, i'm a newbie.

(Last one, I promise)
I need a formula that will check 8 different columns (O5, T5, Y5, AD5, AI5,
AN5, AS5, AX5). Each column may or may not have a date in it.  The columns
are sequential so only the leftmost columns will have a date if all columns

The below is in a pre-dowloaded column, column L
11/14/06  4:19
It has custom formatting as  m"/"d"/"yy"  "h":"mm
What formula do I need to enter in the M column to just show the 4:19,