Losing rows that reference data from another worsheet I am designing an invoice in Excel 2007 that draws data from a query in Access 2007. I have constructed a 2-worksheet workbook; Sheet 1 is the formatted invoice, and Sheet 2 is linked to the Access query results. Sheet 2 is doing its job perfectly. Part of Sheet 1 references the Sheet 2 data in the same list fo... 25 Feb 2010 19:25 Count between two dates using sumproduct Using Excel 2003, A5:A1000 is a range of dates covering 12 months, 1/1/10 through 12/31/10; E5:E1000 is a range of names, ie Smith. I need to count the number of times Smith occurs for each month, ie January, February, etc. I have the following formula, {=SUMPRODUCT(--(A5:A1000>=1/1/2010),--(A5:A1000<=1/31/2010... 25 Feb 2010 21:38 Icon Sets - Display icon in one cell depending upon value in anoth I would like to display in cell A2 a red diamond if the value in U2="Storage"; a Green Circle if the value in U2="Central Files" "Office" or Floor"; and a yellow triangle if the value in U2="Missing". I saw the response to "ICON Arrows UP or DOWN", but I couldn't understand where the different parts were suppo... 25 Feb 2010 18:16 Formula for adding time Hello, I want to put in a start time in B2 and have B3, B4, B5, B6 be filled in with a formula. If I put 1:00 pm in B2 - B3 would add to 1:40 and so on. A B 1 Location start time 2 stop 1 3 stop 2 B2 + 40 minutes 4 stop 3 B3 + 55 minutes... 25 Feb 2010 20:31 Nees Function to Split Hi All I have in one cell some numbers , separated with commas . Eg : 1, 22, 24, 44, 56, 77 After every number follow a comma , and then is a space till to the next number . I need a function / formula to put every number separate in the next right cells : A1: 1, 22, 24, 44, 56, 77 B1: 1 C1: 22 ... 25 Feb 2010 16:00 cell range not changing when refreshing linked data- sumproduct fo The cell range is not updating correctly to reflect the last row in the data sheet that is being refreshed. 5878 is the correct number of rows and 5824 is not. I can find and replace in my formulas to correct the problem, but it does it each time the data is refreshed. Any suggestions as to why? =(SUMPROD... 25 Feb 2010 18:16 Label filter disabled I have a pivot table connected to an Analysis Services database. When I click on the arrow in the Field Caption, the label filter is disabled. All of the value filters except Top 10 area also disabled. Sometimes they are enabled. I need them to always be enabled. Any idea why they're grayed out? ... 25 Feb 2010 14:51 counting the number an item appears I am trying to place a number next to an item for every time it appears, any suggestions? ex: apple 1 orange 1 grape 1 apple 2 apple 3 orange 2 kiwi 1 ... 25 Feb 2010 14:51 between function? I am trying to write an if function to find out if a value falls between two numbers =if(AM7(is between 0.005 and 0.999),"etc","etc") Is there a function I can use to make this happen? ... 25 Feb 2010 14:51 How do I make cells not move in a worksheet I want to lock or protect a range of cells from moving in a worksheet. The cells need to be open for editing from other users but they should not be able to insert columns, rows etc inbetween these range of cells. How can i do that? Is there a macro somebody has already developed that i can use? I am just starting ... 25 Feb 2010 13:43