Home Loan Schedule Principal $125,000 Rate 7.2% Years 20 Payment $984.19 per month Year Beginning Balance Ending Balance Total Paid 1 $125,000 ...

I have 30 to 60 sheets in several workbooks. I need to do some "drill down" analysis and reporting: I want it to count specific cells in all sheets that...

I would like to stop at a cell until something is entered into it. I even want to stop Tab, arrow key also from allowing advancement to the next cell in my...

I have a column with many rows of text (brief product descriptions). I need to identify which cells have a content of more than 35 characters, since I will...

I have a summary page with data in rows. Within that row I want the average of all the numbers that have a specific value in the cell before it. For...

=IF(ISNA(VLOOKUP(A4,'507.xls'!$A:$A,1,0)),"",G4) I got this function from Sean Timmons, but can not get it working, can anyone tell me why? It returns with...

1. what function is suitable to use when the number or value appeared in column D until column AX. 2. name will call out in column C when the number or value...

I'm just now trying to learn the COUNTIF function but obviously am having a problem... If the cell range is (A5:A370) and I need to count the "Y" 's and the...

How do I make cells mandatory for a user to enter information and if the cell is left blank the user should be prompted with a warning of the invalid entry

Hoping you can help me. I have Column A with a start date and Column B with an end date. Column C has "New". Column D has the name "Jane". Column E has...

How would one set up a formula for: Range B1:B20 is text and is sometimes duplicated, range A1:A20 has amounts. If duplicated I need the amount of the later...

Dear All, Facing problem to write a proper lookup formula for following problem, Look value in Coulmn A match it in Coulmn B and return the Number In coulmn...

Hi all, Don't know if this will test you or not. I'm trying to combine a drop down list along with a lookup facility. I have a list of job grades in say...

I am trying to calculate a column using the VLOOKUP function. When I enter all of the variables, the function wizard shows the right results, but when I hit...

I have a data base in excel that lists test info on students. There are multiple tests on various sheets. The sheets are almost identical except for the...

Please could someone help me with a SUMPRODUCT formula? I have the following...

I want to set up filters for columns a, b then skip c-h, then filter i-t...is this possible?

I have A macro that changes a formula in workbooks. It goes into a list, opens the right WB and changes the formula, printout couple pages . the problem Is...

I swear that prior to Excel 2007, if you inserted above a range of cells with formulas that the new row was not totally blank - it fill-copied down the...

I have multiple locations in column B ...B2:B1700 Site A, B, C, ... In column N2:N1700 I have a number 0, 1, 2 3, 4 and so forth Column B = Site X Column N=...