=SUMPRODUCT(('Sites Task List_Logical'!$B$2:$B$5776=$C26)*('Sites Task List_Logical'!$Q$2:$Q$5776=FALSE)) =SUMPRODUCT(('Sites Task...

I'm with a real estate company and we do a lot of analysis of properties in specific price ranges. Is there a way in a pivot table to set filters by a range...

I have a problem in our office. For the most part Excel works fine. We can open files and save them as long as we dont use the 'Save As' feature and try to...

I need to work with multiple spreadsheets side by side, and Excel's default behavior is driving me mad. I don't want all 4 workbooks open in the same...

My VBA help function does not find anythingn I ask it to search for. How do I reload the latest help instructions to my Excel 2007 help button?

I have a clip art (picture) which has a macro assigned to. When I move the pointer to it is swaps to a hand. I would like when this happen to display some text...

The data in my Access database is in the order that I want it to be but my Pivot Table insists on sorting it either Ascending or Descending. I can't seem to...

I need to know what formula to use for this hope someone can help in cell A2 i have a percentage value. I want cell B2 to display a value of 1 or 0 1 if the...

I am trying to ascertain if there is a method by which I can cause text/information on a worksheet to expand, and thereby fill the entire page (print preview...

Hi, I set up a worksheet for a Lookup Function that contains numbers increasing by 0.1 from 100.0 to 50.0. I used the drag and fill to set up the numbers. ...

Someone was meant to send an important document to me via email but they forgot to attach the document, and do not have it saved on their system. Is there...

I'm having a brain freeze and cannot come up with the formula to express the following: If A1 is greater than 0 but less than 3, return 50, If A1 is greater...

on tab: Weeks NQCQ I have a table as follows Col A Col B Col C Week CQ Week NQ Week wk2 1Q10 Wk-12 Week...

I have some code to filter a result set to a list of unique names - is there something I can add that will also remove 'blank' entries ? Range("AP1:AP" &...

I am using; Action:=xlFilterCopy, _ CopyToRange:=Range("A44"), _ Unique:=True to copy unique names to a list - is there something I can add to this code to...

Is there anyway to use formatted text within AutoCorrect in Excel or Powerpoint? I would like to use the AutoCorrect feature to superscript numbers when...

Is it possible to view the info on 2 Tabs sheets vertically side by side at the same time from the same worksheet. I know how to view 2 worksheets next to...

help

I have a table (created by using the “Format as Table� function). When I add a row to the bottom of the table, some of the cells do not adopt the...

Hi, I had a problem with multiple custom cell styles that don't allow me to convert an excel 2007 file to excel 2003. I found a VBA example to delete all...