I have recently seen a worksheet with + boxes to the left of a row that when
you click on it several related rows are revealed and the + becomes a -. When
you click the - the newly reveald rows are hidden and the initial line is
visible and the sign chaned back to a +.

I have original cells formatted as m/d/yyyy h:mm because that is the way the
program I'm working with returns them.  Example is 9/30/2006 15:00.  I need
to get just a mm/dd/yyyy format.  At this point I formatted the origninal
data as mm/dd/yyyy, but the problem is that the time ...

I am working in a spreadsheet that uses many formulas for calculations.
There is a variable(s) (call it Cell A5 to Cell H5) that, if any of the
cells are changed, will change the result of the spreadsheet.  I want to know
how to search for all formulas that access cells A5 to H5.

In Excel 2003 you can repeat sort parameters for different sections of a
worksheet by using the F4 function key after performing your 1st sort, but I
can't get that to work in Excel 2007.  Anyone know if there is a way to "fix"
that or is there an alternate way to do this in ...

1.Is there a way to figure out what the Name is of an (embedded) chart
without VBA?
2.Is there a non-VBA way to change that name?
Thanks in advance,

I have two columns - Industry Code and Market Cap. I want to create a
summary table for average market cap and standard deviation for certain
Industries. However, there are like 20 different industry codes and I didn't
exactly feel like doing it manually for 20 cells. I tried out ...

i would like to sum all values in column C of different sheets when column A
of these sheets matches a certain value.
i tried the following:
sumif(Sheet1:Sheet3!$A:$A,"EU",Sheet1:Sheet3!C:C)

I am wondering how you can count the number of occurences in myRange that
contains 2 charters only?
This function does obviously not do the trick:
=SUMPRODUCT(--(ISNUMBER(SEARCH("??",myRange))))

Please help to provide a formula when compare A to B with results in col C.
Data example
A       B          Results C
1       2            Lower

Hi Experts:
I am trying to sent a Workbook with Macros in email to other team members.  
I did a test to myself in email and when I try to open the file and use the
shortcut key to run the macro, I get the 1004 Run Time Error.  If I save it

Hi, I have a list of dates, that go from =TODAY() and then +7 until
October time. (So one entry a week based on todays date).  I then have
created a combo box based on these dates and that works fine.  I have
done a cell link to another cell, so I can use the date in some

I have several rows which all start out as blank cells but then over time
start to have numbers (though the numbers start to come at different times).  
I would like to write a formula that pulls the first non-blank cell for each
row.  The numbers (once they start) are not ...

I want a formula on how to change/translate an amount in figure in a cell to
amount in words on the other cell within the excel sheet. How do I do this?
Like for example: In cell D3 I typed 6000, on cell D4 it should be " Six
thousand"

Main sheet is 10 columns and 3696 rows. when creating pivot table get error
message.  What can i do to get full spread sheet to load?  the rows contain
names,
names go up to starting with Z but only load rows that go up to S.

I need to count the number of instances of "1" in a cell range. Here's the
catch, the range may contain more than one instance of it in a single cell,
but I need to account for each independently. So one cell may contain 11 and
the next 111, but I need to count the number of ...