General

INDIRECT not working as expected - referencing multiple dynamic ranges
Hi all I have some dynamic ranges that are subsets of a master dynamic ranges. The criteria for the start/end of each subset range are in A1:A4 dynMaster = OFFSET($A$40, 0, 0, NumRows) dynSub1 = INDEX(dynMaster, MATCH($A$1, dynMaster, 0)):INDEX(dynMaster, MATCH($A$2, dynMaster, 0)-1) dynSub2 = INDEX(dynMast... 27 Jan 2010 20:36

How do I arrange cells in alphabetical order in Excel?
How do I arrange cells in alphabetical order in Excel? ... 27 Jan 2010 21:43

export Pivot Charts to MS Word?
Can this be done? I'll have several charts to go to several Word docs and would like to avoid the copy/paste option. ... 2 Feb 2010 17:27

Excel pausing
When typing in text in excel, when I type a word that has a double letter such as "letter" excel pauses and it takes a minute before it will put the second letter "t" in. Using windows 7 with excel 2007 ... 27 Jan 2010 17:12

Changing dates
How do you change a date to text and return a string such as mmddyy to replace 01/01/10? In other words remove the slashes but keep the same numbers. ... 2 Feb 2010 17:27

having two separate column width controls on same worksheet
I have a work sheet - in top part, I want column widths to be one setting; in bottom part, I want ability to have different column width setting...all on one sheet. Can this be done? I have excel 2007. ... 27 Jan 2010 17:12

cannot open excel file from outlook
Excel 2007 cannot open document eithout first saving and opening thru excel ... 27 Jan 2010 16:04

Summing cell values based on the value of another
Greetings to all, I need to sum cell values based on the value of another. Here is the example... A B 1 44.00 $5,874.40 2 44.00 $- 3 44.00 $- 4 23.00 $516.67 5 44.00 $557.20 If A1:5 = 44 then sum B & the row in column A that equaled 44... ... 27 Jan 2010 14:55

Inserting sheets into Excel workbook
I have created a workbook with 7 worksheets. I want to add more worksheets but the option to Insert Worksheets is grayed out. What have I done to remove this option from just this workbook? ... 2 Feb 2010 17:27

Separating data in a column
the spreadsheet i am working on has 1 column with 2 possible answers, i.e. yes/no. what i need to do is separate the replies and then total the yes replies in another cell and also total no replies in a different cell. How do i do it? ... 27 Jan 2010 13:47