A1:
=FACT(9)/FACT(6)/FACT(3)        returns 84, as it should
A2:
=COMBIN(9,3)                           returns 84, as it should

I have tried and succeeded in importing a .csv file into excel. This file has
numerical values. After converting the file, I try and add a few of the
numbers in one of the colunms and my answer is always #VALUE; which tells me
those numbers are being read as values and not ...

In http://www.mrexcel.com/pc09.shtml site there is a solution with 54
piece of knapsack problem
using simply Excel macros and find all solutions in <  8 hours using a
Pentium 4 - 3,4GHz computer

i have a .xls file that has been layed out very nicely (and i wasnt supposed
to change it), but the silly bugger who designed it, didnt put it the
formulas to relate various cells
where totaling stuff.

In a Macro How do you print a string in a macro?
For instance: Print "Hi there" So "Hi there" goes to the printer.
I tried all kinds of things but it keeps saying someting about an
object. I'm trying to print a string variable.

Hi All,
I need some help with a problem I'm facing.
I have multiple excel sheets (almost 80 separate files) in which I'm
concerned with two specific columns (Say Column A and Column B, both

I have some doubt in Date & Time Format.
I have some (time) appearing in a column in this format 7/17/2006
3:20:53 PM..
I need to have a conditional formatting for this in that column.

I need to count the number of X's that appear in column B. What would
the best function be to do this?
Many thanks,
Marie

I would like to find out how to transfer an excel file to a text file
format where each field is separated by a delimiter
TQ

Hi
I am new to excel and would like to design a form, that keeeps track of the
construction maintenance jobs we have in then when they have been completed
to produce an invoice saving all imfo in relative sheets. i.e. work in, work

Is it possible to divide first and last names that have a space between them
is one cell and put copy them to two separate cells?
Thanks,
Digital2k

I require as a header, Report From (min Date) to (max Date)
which i have acheived by :
="Summary Data For Period "&MIN(Data!B:B)&" To "&MAX(Data!B:B)
however the dates are returned as excel values rather than dates.  How

I would like to calculate (only in one cell) the sum of absolute values (
ABS() ) of a column. The column includes positive and negative numbers and
some blank cells. I would like to reject the non number cells.
Is this possible?

Is it possible to automatically run a  macro if a cell contains a certain
value???
thanks
Rossella

does anyone know how to save data coming form formulaarray directly to
a variable?