Hi
I'm creating an excel database with 2 tabs - one of which will be a front
page, containing formulas to conduct a search from tab 2 - a data dump page.
I understand how to do VLookups, but i'm looking for a formula which means I

Dear Sir,
I have the following table to be sum up in block as illustrated.
              A                  B                  C                  D    
                               Block                  

I am trying to return the minimum value in a range J2:AJ2 whilst ignoring
empty cells.  How do I do it?

How can I include an array function within an IF function?
Thanks.

In my excel page I have a bunch of check boxes periodically throughout the
page. When I Scroll down the check boxes are wiped out to where I cant see
them but if I know where they are at I can still click on it then it will
show up. If I scroll up they actually reappear but when ...

I am using Excel 2007. I have a worksheet with two columns of data. I
need to compare the data between the two columns to find out which
ones are missing. I cannot get this to work right in Excel 2007 using
the PivotTable button. Any help is appreciated. Thanks.

How can I get the “<” and “>” symbols act as part of a number on a formula?
I work at a lab, and when we get results that our equipment can not measure
the samples, we use the “less than” symbol… The problem is that when you
write a formula at the end of the column; for example ...

Hoping someone can help with an apparent formula problem I'm having. I'm
working with a very simple spreadsheet showing different projects and their
monthly costs each month over the course of a year (cost figures cut and
paste from Microsoft Project)

I have five Worksheets in a Workbook  Four of them have the same formats and
are titled Week One, Week Two, Week Three and Week Four.  Each of these four
have 30 Rows.  The other is Titled "Performance Ratings" which also has the
30 rows, but with a different format.  I need a ...

I have to determine the age of an employee on the day they start employment
and the day they end employment.  I have their birthdate in Column A, date of
hire in Column B, date of termination in Column C.  I have too many names to
do this by hand.  What is the formula for ...

In  say column A and B I have the following:
Jan       1
           1
           1

Good afternoon!
I am looking to make a bar chart with 2 data categories.
Generalized Error Category
Specific Error Type

Hi - I am trying to put a base line in a graph however when I print preview
or print the base line shifts down - Do you know how I can freeze the line
for printing?
thanks

how do i call internet explorer from excel using macro

Could you please tell me how I could have in column C, the age of a person
from  indicating (column A)the birthdate and the other (column B) today's
date. Many thanks ahead