Curious problem here and I'm pulling out what hair I have left...
Averaging a range of cells if the value of that cell is > the minimum, which
would be 0 (zero).  The formula works when I put it in one cell, but gives me
a #Value! error if I put it elsewhere.

My problem can only be properly understood by you actually seeing the
worksheets
Is there a way to achieve this?

We've some code that spits out an html table from our application and opens
it within excel. One of our clients has recently been having a problem with
date formats (operations in different regions of the world).
We changed our code to output all the dates in the format dd mmm ...

In Excel, I need a macro that will delete a column based on a cell
that will contain a name based on an input box.
Thanks,
Bernie

there is a folder containing 400 excel files which are on same pattern. I
want to merge all files in a single new excel file.

這裡有沒有中國人上來看的？

        I am using visual basic and Excel automation.
How can I programmatically move entire row to the end and shift all other
rows one row up?
Jack

How can i import sql database into excell using excel 2000  ?
Pleaseee someone help me.
I can do that usig excel 2002 but my user using excel 2000. I cant do that .
need help

Hi, im new to this xml thing. I created an excel and when i imported an XML
document, insteand of the information appearing in a single row, it began
appearing like a stairway. Example, insetad of being, row1 column A, row 1
column B, row 1 column C  it appears as row1 column A, ...

Could anyone please advise how I can conditionally format cells so that the
highest & lowest value in the range is formatted.
I've tried 'Formula is MAX($A$1:$A$10)' but no joy.
Any help greatly appreciated.

Help Automatically Populating A Summary sheet
I have 2 worksheets,:-
On sheet1 I have a series of columns going across the page (left to
right) each relating to one month. The rows going down the page relate

I want a formula that finds a cell and returns it address in another
workbook
I have the formula to return the address but it will not return the
content of the address

I have the following control structure from Matlab, do you think I need VBA
to handle it, or I can just rely on Excel?
Thanks a lot!
-----------------------------------------

In Excel 2003 you get the option of showing a macro as an icon  and or adding
text in the command bar.
Canthis be done ins EXCEL 2007? How?
Thanks

Using Excel 2003.
How can I get Excel to display and handle entries for duration in minutes
and seconds only (without having to enter a 4'30" entry as 0:04:30)?  I have
gotten as far as getting it to display as "04:30.0", but all I need is