from conditional formula, how can i create a formula IF D20 <= E20, Then will
display tick. else will display, cross tick

I need help with this formula.
     A                         B                        C
1 ACTIVE               11.78%               ______ AVERAGE
2 ACTIVE               12.88%

     Anyone know some code I could use to easily enter times into cells.
For example, I currently type '20:15' (without the quote's of course) but
would much rather type 2015 & have it appear as 20:15

Since i installed IE7 on one of the clients i cant open a certain excel
file which includes some macro's. I can open this excel-file on every
other pc without problems. The file contains some buttons which
activate some macro's. After i open the file on the client with IE7

I have a question that I hope someone can help with.
     A                        B                           C
1 ACTIVE               11.88%                 _______ Average              
2 ACTIVE               12.80%

My spreadsheet uses columns A-G, but when I print, column H also prints even
though there is nothing in any of its cells.  There is no print area set.
Why is this empty column printing? And how do I stop it from printing? TIA.
Mark

Hi, I am trying to find a way of determining whether variables (in a large
array of 35000 data points, defined as Single) are actually blank or are
really zero.
I appreciate that numeric variables default to 0. In my case, I dimension my

I am trying to mimic the approximate find methods used in Excel MATCH,
VLOOKUP, etc. application functions in VBA. I have a large(!) data set and,
in this particular instance, want to perform operations (average, max, min)
on subranges containing data for different periods. The ...

I wonder if this is possible.
I have an excel sheet which has a dropdown column. What I would like to do is
if I select, for example, 05/06 in the dropdown, I would like the following
to happen:

when i try to print an excel 2003 worksheet i am asked to save as instead of  
the printing taking place. I havent made any changes to my workbook so i have
nothing to save.

Hello, have a nice day,
I want to open (jump) to a sheet depending on a number in a certain cell.
For example;If there is 1 in cell A1, then go to (jump, open) Sheet1, if
there is 2 (also in same cell A1) go to Sheet2, if there is 3 go to Sheet3

I work in Microsoft Visual Basic (write macro for excel) and the wheel of my
mouse don't work on the page so I can't move the page up and down by the
mouse wheel. Any one know how can I operate it?
Thanks,

I'm trying to perform a countif on two different ranges of cells but am
having difficulty figuring out how to get past the first range.  This is
what I have that does work...
=COUNTIF(Sheet1!A13:AA39,"*David*")

I have a long list of numbers in a column.
How would I determine if there are duplicates, and "flag" them ?
How would I remove all the duplicates in a single, perhaps, step ?
Thanks,