I use wildcards for =countif function and it works
but when I use it with for example =if(b30="*test", "yes", "no") it always
gives me a "no" in the cell.
if in include the asterisk in the B30 cell the if is successful.

Does anyone know why excel 2002 will not include all of my non-adjacent
ranges in a named range?  It includes 10 of my ranges and then just refuses
to include the last two ranges I highlight.  Any ideas for a workaround are
welcome.

Hi there. I created a validation for a cell by using the "custom" criteria.
I then entered my formula into the formula bar. I now need to scroll back
and forward in this formula to make adjustments to the formula, but it seems
I can't scroll in this bar since it only adds the next ...

How do I get text (in a cell) to flash in MS Excel?
Thanks.
OH

as we transpose values from rows to column in the same way i want to
transpose links from rows to column.is it possible in excel ?

I demonstrate that the Normal distribution is a good approximation of the
binomial in Excel but I found there was a diference in entering the formula
f(x)=1/(stdev*sqrt(2*PI()))*exp(-(x-mean)^2/(2*stdev^2))
and

Hi, can anyone simplyfy this code as it is used in the workbook open event
but it blinks 4 times because the following code although it does the job i
think i ask for to many activate on the payslip side as that is the book that
when opens seems to perorm 4 operation, hense the ...

does anyone know how to do submations?

The regresssion tool says the limit is 16 x's.  I have 30.

I am having trouble organising a large database of names that needs to be
updated from old database.  Both workbooks were created in 2003 Excel
Professional Suite.
How do I import the new names from the other workbook? This needs to be

I've been trying to get the data in column f  time the data in column c to be
equal to the data in column d..  D=F*C but it only work if I do it one row at
a time ..I need a formula that work on the whole sheet ,without having to do
it in every single row..

Id appreciate any advice on this lookup issue please.
Basically I have 2 worksheets in a workbook.  Both have the same data in
column D, and I would like to set a lookup in Sheet 1, to look into Sheet 2
and where column D data matches in each sheet return the Value from Sheet 2

Occassionally I find that when I use VLookup I get the row number of the item
within the lookup range instead of the value.  It's not clear that I am doing
anything different from the dozens of lookups I seem to do each week
(sometimes each day).  Anyone have any thoughts?

My data analysis toolback is apparently installed, but the "Data analysis"
function is not appearing under the Tools Menu. How can I fix this?

Is it possible to use SUMIF or similar to sum cells where the Fill Color is
Yellow for instance ??
IE something along the lines of =SUMIF(C3:C15),"FillColor=Yellow",C3:C15)
.....