Hi, I'm not sure if someone can help me. I have this formula: =IF(ISNUMBER(VLOOKUP($W8,actuals,X$6,FALSE)),(VLOOKUP($W8,actuals,X $6,FALSE)),0) The problem...

I know that excel has a function call CUMIPMT() that will return the total interest paid on a loan given a rate, initial value, and range of periods that you...

I searched through postings but couldn't find one which I could comprehend to address this issue. Earlier today, your support corrected my code in order to...

This has got to be very simple but I can't seem to figure it out... On Sheet1 "A1" I have "=Sheet2!A1" On Sheet1 "B1" I have "=Sheet2!A2" On Sheet1 "C1" I...

I have a simple Excel spreadsheet with just names, account numbers, and card numbers. I only want to view the names that occur more than once to see who...

I have tried to move and copy a worksheet but nothing happens using the right click or the edit route. The workbook is not protected. I can insert new...

I want to copy text from cell Sheet1 B1 to cell Sheet2 C3. Then when text is changed in cell Sheet1 B1 the new text is copied to next cell in Sheet2 columnC...

Been struggling with this for a few hours and not making much progress, hoping someone can help me out. I've got an analysis XLS that has a bunch of...

Hi, How Can I have multiple condition using countif function Can we use the Countif function or any other function if we are working with dates or...

I need to create a calculation where the range creiteria in my first column is "=7=9" and my second column ="30+" before it is counted. I'm not sure how to...

I want create a formula that if the Min column (C3, F3, I3, and so on...) is greater than 0, then A1 will combine the XX1, XX2, XX3 and so on... can anyone...

is there a way to get rid of the blue line that surrounds the cells when you use lists?

I want to select multiple spreadsheets to duplex print at the same time. How do I do this??

I have a list of teams in one column, i would like to begin typing a team name in a separate cell and excel will recognize the name and fill in the...

How Can I have multiple condition using countif function. Ex: If I want to count only those cells that have value 300 and 700

I am trying to use a sumif command and want excel to copy the formula in each cell EXACTALY like it is. Excel keeps "progressing" the formula. I just want...

I copy data from a different program and paste it into a spreadsheet and some of the cells have unused spaces behind the last character. When I link that...

I am using Excel 2003 and I have a lot to learn. I have two workbooks. One is a QUOTE WORKBOOK and on is a JOB RECAP. The QUOTE WORKBOOK is used to quote...

When I'm creating a new worksheet and formatting cells with borders, when I go to Print Preview, it doesn't always show all the borders even though when I...

I have a large amount of data that needs to be tracked horizontally across 26 pay periods. I'd like the first column (a list of names) to stick or float as...