I have a block of data, e.g. 30 rows and 20 columns. How do I switch them,
i.e. put the data A1-T1 to A1-A20, A2-T2 to B1-B20,  A3-T3 to C1-C20 and so
on?

I could be losing my mind, but isn't there a function where you can get a
Pivot Table to create a separate worksheet for each row in your table - in
one go. I know I can do it by double-clicking the total but i thought there
was a single function to do them all in one go? I'm ...

I need Microsoft help. I try to use "and" sign; "&" in Microsoft Excel 2003.
But when I try to print preview the document to see the whole document but
the sign of "&" is missing.

Does anybody have a readymade function to do what auto-filter does?  I have
done this before but it will take very long to figure it all out.  I think I
used a combination of: vlookup, address, index, isna, row().

I need a formula for the sum of one column values (in three parts) subject to
conditions in another column.
column A conditionals are : sgd or usd or rp or blank, where blank is to be  
read as "rp" . These are currency identifiiers.

I need to look into a range of cells within a Pivot table that contains Text
strings and values. the text strings are a single cell that is a
contatenation of company names, country codes, and numeric text. The numeric
values in the adjacent cells are a count of how many times ...

i want to print more than one file at a time. if once the margin is set, that
margin should be same for all the file. is it possible.
pls help

Before in Office 2003 if I had a worksheet that I always used the same sort
setup and I saved the worksheet it would always bring that sort criteria up
when I hit sort.
Now in 2007 it doesn't seem to matter what I do even if I sort several times

Hi Everyone!!
Looking for help on a formula.
I have s apreadsheet
In Column A is a date and time 12/04/07 16:00

I have a huge spread sheet that I'd like to automate.  My current delima is
how to calculate a dollar amount in one cell with information from column J
based on the criteria, same row, but in column N.  I've tried the sumproduct
information but I'm entering it in wrong ...  I've ...

I need a formula to be able to add months to a date,
Example: If my date is 1/1/00 I want to add 18 (30,42,54, etc) months to it,
and calculate to 7/1/01 (7/1/02, 7/1/03,7/1/04, etc).  I can get it to come
out using number of days but because of leap years some of the calculations ...

How can I calcualte an average in one cell from two different columns of
data depending on which is populated.  Oh yea one column has a function
applied to it and if there is no data it returns a zero...I only want the
average if the data exists.

Hi I have two possible data columns in a spreadsheet, I can enter the OD or %T
I would then like to calculate the average, max, and min of either column
after the data set is filled in.  The formulat to convert %T to OD
=(10^-C19)*100 what I am having trouble with is setting up a ...

I post a message earlier but it seems to have been removed.
Here goes again....
In column A I have a date and time.
I need a formula that will add 4 hours to the date and time, but take

I am working on an assignment for class and wondered if you could change
negative values in excel to zero without actually typing in the zero