Functions

returning a date 7 business day excluding holidays in the future
How would I write a formula that would do this. If I input a date in cell A1 and I have holidays in cells R1:R11. Can I write a formula that would give me a date in cell B2 that is 7 business days excluding holiday from the date in A1. I am having a hard time getting the networkdays and holidays working if... 25 Feb 2010 14:51

how do i see which data matches between two worksheets?
I need to compare a very long worksheet (W1) to a shorter worksheet (W2) to see if any of the files listed on W1 are on W2. I then need to copy the matching rows from W2 to a new worksheet. ... 25 Feb 2010 14:51

Saving Pivot Tables
Is there a way to save frequently used Pivot Table configurations so that you do not have to recreate them every time? I can do this with Macro but there has to be a better way. ... 25 Feb 2010 12:34

IF - AND - OR statement?
Using Excel 2007. I have four cells that either contain a "Y" or are blank. I am trying to analyze if any two of the four cells in A1:A4 have a "Y" then in cell A6 there should be a Y. If only one of the four cells has a "Y" then cell A6 should be blank. I have tried this formula but it only takes into ac... 25 Feb 2010 14:51

Formula results display only after pressing Enter key
I import data from a database as a csv file and then save it as an Excel 2003 workbook. The first column in the spreadsheet contains a long list of four character entries. I remove the first character of each entry by inserting a column next to Column A and using the following formula: =right(A1, LEN(A1)-1) U... 25 Feb 2010 12:34

Retrieve unique items with 2 criteria (USING SUMPRODUCT)
This question was posted before but the solution proposed used different functions. I would like to insist. Is there a modification to the formula below, using SUMPRODUCT, that allows to retrieve the number of unique itens that meet a 2nd criteria? Original formula: =SUMPRODUCT((A1:A20<>"")/COUNTIF(A1:A20,A1:... 2 Mar 2010 12:24

How do I get a sum of every seventh cell in a column?
Hello I am trying to find out how to get a sum of cells with a specific fixed interval between them ... 25 Feb 2010 13:43

Can multiple criteria be used for IF formulas?
I am using the below formula to calculate percent of change from one year to another year. =IF(F3=0,1,U3/F3-1) F3 being the amount spent in previous year U3 being amount spent in current year The question I want my formula to answer is: If F3 and U3 have a quotient greater than zero, then calculate. Howev... 25 Feb 2010 11:26

Can multiple criteria be used for IF formulas?
I am using the below formula to calculate percent of change from one year to another year. =IF(F3=0,1,U3/F3-1) F3 being the amount spent in previous year U3 being amount spent in current year The question I want my formula to answer is: If F3 and U3 have a quotient greater than zero, then calculate. Howev... 25 Feb 2010 12:34

VLOOKUP - Not returning the proper number (Caro)
I have this function: =VLOOKUP(S2,'MFD Cost Table'!$B$3:$C$13,2) The lookup value is either 5655, WC 255 or WCP36. The formula brings back the price of the lookup value. It does not bring back the right price for WC 255 or WCP36 even though they are entered correctly into the table. It does bring back the righ... 25 Feb 2010 11:26