I have created a macro (in the visual basic editor as sub function/procedure)
in my file, and I want to activate it as soon as the file open or when the
":" button is pressed.  Anybody that can help me with this problem ?
Thank's.

I have a row of numbers from 1 to 26 in cells A1 to Z1 representing numbers
'chosen' at random by 500 unique people.
I have another row of numbers representing the 'frequency' that the
aforementioned number was chosen in cells A2 to Z2.

help please i want a cell to display the first duplicate number in two
lists for example
a1 a2   a3
1    3     5

I'm trying to create a conditional data validation for a cell ($D4) based on
the entry in cell ($B4).  There are three possible entries for cell $B4.  
I've created a named list for $B4 and based on the entry I want three
different conditional data validation types for cell $D4:

I need to convert Meters to Feet and Inch measurments.  I need it in
fractional format I.e.  1/4, 1/2, 3/8, 5/16, 8/32.
Ex.  1         Meter
=    3   1/2 Feet

I have two worksheets.  On one a name, date and amount (thousands of
records).  The other is a small sample containing just a name and date
which i require to match to records in the first sheet and return the
amount.

Good day!
I have an excel file with 2 sheets. On the first sheet I have names on
the left rows.. example is:

I have a matrix with 1 row and 20 columns, the couple cells contain a numeric
value and an associated text in the next column, like this there are 15
couple of sets.
Now using Min(Value1,Value2..,) i can find the min of all the numeric

I recently learned there is such a thing as ISNA for recognising #N/A (since
using IF(C1="#N/A",... didn't work unless I copied the #N/A from the C1
position...weird...)
Is there such a function for #NUM??? ISNU and ISNUM don't seem to work.

What is the formula for determining the following: If you have an 84 average
that counts as 60% of a grade (school); and you have 91 average that counts
as 30% of a grade' and you have 85 average that counts as 10% of your grade,
what is the formula to determine what your average ...

cell A6 is a ratio, and favorable if less than (<) 2.5
cell C6 is the sum of individual ratings
Please help if you can fill in the blanks...  How do I write this function??
I want to be able to trigger a calculation if two favorable conditions are

I am tryin to do a calculation between 2 columns. If the value in colum
1 is >21, then I want to Average the corresponding values in Column 2.
have the formula
=SUM(IF(Gume>21,Dent))where column 1 is named Gume and Column 2 i

I have a worksheet with a list of names in one column and a group of
numerical scores in another column.
On a seperate worksheet, I need, a 4 wide x 2 high grid,  each grid is
filled with names from the first worksheet, for those that meet a specific

I have created and X Y Scatter chart and placed an Exponential Trend Line on
it with a good R2 result. I have added the equation to be shown on the chart.
How can I put the Constant values of this equation into separate cells
within the worksheet.

How do I use the Student, x^2 and Gaus (normal) distributions?
For example in student distribution for n samples and error probability
of 5%  I'm going to Student's table I'm going in n-1 row and t=95 and
find the corresponding number. But in Excel I don't know how it works.