Functions

Expand/Collapse in Pivot Tables
Is there any way to put in a button to expand and/or collapse groups of grouped items in pivot tables? I know in regular spread sheets, there are buttons on the left hand side of the sheet called 1, 2, 3, etc. which will expand/collapse the entire level 1, 2, 3 groups of items. Looking for something similar i... 16 Dec 2009 19:07

copy dates, events and times into a montly calendar
... 16 Dec 2009 14:38

conditional formatting and coloring cells.
I have a spreadsheet for relays that had info such as due date, last done, when due etc. etc. . When the new completion date is entered, the formula adds to years to it coming up with a new due date. That changes that cell to a color assigned the year...2010, 2011 whatever through 2017. Is there any way to ma... 16 Dec 2009 12:23

multiple range in SUM,IF
=SUM(IF(('13b'!A3:A75="Customer 1")*('13b'!C3:C75="QAR")*('13b'!H3:H75>31<=93),('13b'!F3:F75),"")) Im above array formula, 3rd criteria i am trying to set range > 31 AND <=93 but it doesnt work .. could anyone help ?? ... 16 Dec 2009 02:35

counting the number of occurences
I have a list that shows the worker ID and the result of each work item. The number of work items differs for each worker ID--the results of each item is either "A" or "D". This is an example of a portion of the list: Worker Status 008Q A 008Q D 008Q A 098Q D 098Q ... 19 Dec 2009 09:26

I cannot highlight a whole row or column
Inadvertantly, I pushed the wrong button and am now uanable to highlight rows and columns to delete , insert or even clear them. This condition applies to eleven spreadsheets in the same folder. I don't know where to find a remedy for this situation. Please, can someone help me? Windows XP Home Edition... 15 Dec 2009 22:16

Look up Data by Row criteria and column criteria
I am trying to build a formula that looks up an identifyer in a row and a column, such as the following: 0 1 2 3 4 $250 0.01% 12.50% 12.50% 20.00% 20.00% $12,500 0.01% 8.33% 8.33% 8.33% 13.33% $37,500 0.01% 6.25% 6.25% 6.25% 6.25% $125,000 0.01% 5.00% 5.00% 5.00% 5.00% $187,500 0.01% 4.17% 4.17% 4.... 15 Dec 2009 22:16

Replacing spaces with data from another cell
Hello, I'm trying to create some tracking URLs and I am was hoping that there was an easier way to do this. I have keywords that vary between 2 and 5 words long. I need to enter unique code before, after and in between each keyword. I.E. Apples Oranges Bananas Pears = code1applescode2orangescode2banan... 15 Dec 2009 20:05

Conditional format question
What formula is suitable to determine if a value in 'B' is not present in A:A example: oranges are in B3 but can not be found anywhere in A:A ... 16 Dec 2009 07:58

look up, match index? multi variable formulas
I have a possibility of entering a dollar value in C10 - C14. Once a number is used in C10 it will not be used again in the next months D10, E10 and so on. The same for C11-14. there might not be a number entered in those sells for months to come. IT might be G11 or later on. I set up another cell with the ... 16 Dec 2009 11:16