Is there a way that I can add different sets of filters into the same
worksheet? For example, I have two seperate tables which I'd like to be able
to filter on simultaneously.
Thanks in advance as always

Is it possible to use SUMIF or something similar to calculate the sum of
different coloured cells (red, green etc) in a list?

i am exploring this http://www.contextures.com/xlForm02.html
would like to improve like how to i prevent no repeated values hava been
entered if users click "Add to Database"
Thanks!

I want to make anagrams of words in excel. How can I do this?

I seem to have a very annoying problem with dates on excel.
I have a simple spreadsheet which is listing invoices for me on a monthly
basis.  The column is formated as date "dd/mm/yyyy", when i enter the date
into a cell within this column it will display correctly in the formula ...

I have an input sheet which contains the data and a summary sheet.  I need to
put a formula in the summary sheet to count the number of rows in which the
following may occur  "PPAO" is in Column A and the number 1 is in either
columns B or C or D.

can i have a button called "Reset"
upon clicked on Reset, all the data fill in all the cells will be reset to
blank.
A B C D

How do I get data bars in a range of cells based on the values in a different
range of cell?  I have two columns:  Category and Count.  I'd like to have
Data Bars appear in the Category column based on the values in the Count
column.  This feels like it should be easy, but I just ...

I am running a report on a monthly basis, which may contain up to 50,000
rows. I need to load the report results into another application, but that
application has a line limit of 10,000 records.
Is there a way to easily cut / copy my large file into multiple smaller

I just want to transfer a word list file to excel without having to type the
whole document over again.

where can i go to learn about macros?

Using Excel 2003.
Can someone tell me how to insert a Yin/Yang symbol into a cell?  I cannot
find the symbol.
Thanks in advance,

Is there a way to set headers/footers to auto populate to a set format?  For
example on each page the file name would appear at the top and the worksheet
name would appear at the bottom of each page without having to set each one
individually.

I have two workbooks.  I want to create a macro that copies information from
one workbook, which will be closed, to another workbook, which will be open.  
I would also prefer if this macro could run everytime the second workbook is
opened.  Is this possible?

HI, I'M TRYING TO DO THE FOLLOWING:
=IF((MIN I9:I32)>500,0,-2.5)
ITS IF THE MIN BETWEEN I9:I32 IS GREATER THAN 500, THEN 0 ,IF NOT THEN -2.5
WHAT AM I DOING WRONG?