General

Adding some list items
Hello, I have an easy one here that I cannot seem to figure out. I have a simple list A:A = Vendor B:B = Amount C:C = Category (from dropdown list) What is the formula to get the sum of only the items in a specific category? E2 to E9 is the list of the categories. I tried =SUMIF(B:B,$E$2=C2) and it com... 19 Apr 2010 15:43

excel 2007 autofilter change to 2003 autofilter functionality?
Is it possible to make the 2007 autofilter change back to the 2003 autofilter functionality? ... 19 Apr 2010 17:48

Blackberry and Excel
I have an excel workbook with multiple sheets - when I open it on my blackberry it opens the first sheet not the last. Is there a way to set up the workbook - so it opens a certain sheet, not the first one. ... 19 Apr 2010 14:41

script or format to identify duplicate data
Is there a way I can write a script or conditional format to identify duplicate data. The data can be marked by highlight if need be. Ex Since A1 and A3 are both the same numbers both locations become highlighted. I have a large range of data to perform this in. The numbers being identified are lager t... 19 Apr 2010 14:41

how can I create a dummy variable in Excel?
I am running regressions in MS Excel, how can I create a dummy variable for any non-quantitive variables? ... 19 Apr 2010 16:46

Creating a value from a variable result
To start with I'll explain how my sheet is set up: Cells W40:W45 contain values of 40 through to 45 These are levels gained by an individual. Cells X40:X45 contain the grade needed to access the next level. Looking something like this:- W X 40 40 41,171 41 41 45,529 42 42 50,399 4... 19 Apr 2010 14:41

Displaying entire row
Hi, I would like to display an entire row based on a category selection. I´ve been trying to do this using PivotTables with no success. For example: East | Carl | 402-4567 | Home West | Kevin | 535-3677 | Work East | Karin | 455-7454 | Cell If the user selects "East" I would like the output to be: Carl | 4... 19 Apr 2010 13:39

2007 Find_Replace - default on workbook?
I know it's possible to do find and replace on a workbook by selecting "workbook" in the "within" drop-down in the find dialogue box. Is it possible to set excel to ALWAYS carry out any find or replace on the entire workbook so you don't have to choose it every time? Thanks -- Faye ... 19 Apr 2010 12:37

2007 excel autofilter change back to 2003?
Is it possible to change the autofilter in excel 2007 back to the way excel 2003 worked? ... 19 Apr 2010 13:39

2007 excel autofilter change back to 2003 autofilter?
Is it possible to change the 2007 autofilter back to like the 2003 autofilter worked? ... 19 Apr 2010 13:39