I have asked a similar question here awhile ago.
I'm want to AutoFilter a column that contains multiple string data.  If I
use AutoFilter to look for just the bit of the string that is say "A", Excel
returns every row that contains ANY string in the column that contains an A.

I need to merge multiple worksheets in the same workbook. The headers
are same for all the worksheets. The worksheets contain each months
data now i want to merge them in one worksheet and get the entire
years data in one sheet. Each worksheet has auto filter enabled.

I have searched Excel help but I cannot find a way of merging several
rows in an excel spreadsheet.
I was given 15 separate sheets with group lists, some of the people on
group 1 also take part in up to four other groups.

I have a table containing TRUE and FALSE values. Essentially I want to count
the number of TRUEs, ultimately in a pivot table.
Should I convert TRUE to 1 first, (=IF(A1=TRUE,1,0)(??)   or is there a way
to get a pivot table to cout the number of TRUEs in a category without

Hi, I'm working on a excel file, and need to create a bar chart based
on the graph, it has to be descending on the graph, I made couple try
but no success. I'm lost on this topic. How to create a descending bar
chart?

I am trying to "Refresh the Data" for my Pivot Table.
My data is a lot longer then it used to be. How do I make sure that all
numbers are included in the pivot table.
Right now the last three rows are cut off.  

(sory for my language, I'm from Poland)
Why Excel 2007 is doing inverted charts? For instant, please write in
a1, b1, c1, d1 some text (a, b, c, d) and in next column (1, 2, 3, 4)
and do chart. Excel do from 'd' to 'a', not from 'a' do 'd'. Why?

A file I access every day has mysteriously become read only a couple
of days ago. I looked at the file attributes, but it's not read only
there. I searched here and on other XL ng's, and tried cleaning out
the Temp folder as someone suggested. No joy there. Any other ideas on

I am trying to produce a simple text file in Excel that I can save as a text
file which I can then import into another program (ACT by Sage). The list is
very simple, just a single column containing text in each row.
The problem I have is that ACT expects to see each line item ...

A strange thing happened when I enter a date into a cell.  If I enter
6/1/2007 the date displays 1/0/1900 but inside the cell it shows =6/1/2007.
If I try to remove the = from the cell it then put the = back.
Any ideas as how to why this is happening?

Can anyone post a reliable formula for calculating week numbers in Excel
that relate to the UK Tax year?
I guess week 1 would be the week with 6th April in it, or maybe week 1 is
the first full week after 5th April.  Does anyone know?

I used the Microsoft Query Editor to edit queries for different
spreadsheets in my workbook--they all point towards the same access
database. What if I want to point the queries to a different access
database (different ODBC DSN), but query the same table in that

I'm trying to total numbers that match certain cells as in the
following example:
A       B      C
26     x

If you will receive 100 + X% of an investment in Y months, what is the best
way to calculate the annual compound return represented by that?

I am a new user to Office 2007 & Windows Vista, having been a long time user
of Excel 2003 & Word 2003.
How do I e-mail a file in Excel or Word.
1.    If I "send to e-mail recipient", it sends the page as part of the