I have a lengthy worksheet with over 12,000 rows. What do I need to do to use CONTROL + END to get to the end of my worksheet from anywhere on the worksheet...

Hi, I badly needs someones help on this I have 2 sheets Namely Sheet1=Summarised Statement Sheet2=Report In Sheet 1 the A coulmn is loaded with ID starting...

Hi everyone, Existing if statement =IF(AL12=0,1,IF(AL120,"q","p")) I would like to amend this to say that if AL12 is between -5 and 5 return 1 if less...

thanks in advance for your help. i wanted to know if there is a function in excel that can calculate an annual rate of return on reinvestments. specifically: ...

I have a macro in which I want to copy a value from a cell in Workbook A to a cell in Workbook B.. However,when pasting it into Workbook B, I want to add it to...

Hello, I am running excel 2003. Can somebody please help. I have 2 columns Row A B 1 ...

Column A of my spreadsheet has a bunch of part numbers. I would like to create a formula in Column B such that my parts are either labeled "American" or...

Looking for a difference in loan websites? Want a change in your investing style? Check this site out. You will have an easy time with getting a loan. You can...

Looking for a difference in loan websites? Want a change in your investing style? Check this site out. You will have an easy time with getting a loan. You can...

Looking for a difference in loan websites? Want a change in your investing style? Check this site out. You will have an easy time with getting a loan. You can...

dear all I had created 2 rows with certain formulas . if i entered the value 24 in a particular cell total i need 22 rows to insert automatically after the...

I have in one cell (say A1) time displayed as 16:45 (excel shows it as 11/6/2007 4:45:38 PM in the bar at the top). I am trying to create an if statement...

it is possible to see in excel sheet for excample. 10/10/2007 15/11/2007 28/09/2007 30/04/2008 06/12/2007 18/08/2009

=sum(column label) do works in the respective sheet. How to perform this =sum(sheet2!column label) suppose i have a colum named Jan in Sheet1. Sum(Jan)...

Googled all over and haven't been able to find a solution- thanks in advance for any help! In Col A I have a list of items that are due for arrival; in Col B...

Please can someone help? Alt+Enter does not produce a line break in a cell for Excel 2003. I have formatted for wrap text and Alt key works for e.g....

How can i find all the cells in a sheet that have links to other data sources apart from that particular workbook? Thanks in advance Gary

I have a report that has 4 columns of numbers 0 - 9, about 1500 rows deep, what I would like to be able to do is simple, but I can't seem to get my brain...

I do not understand accounting, however, I need to create/obtain a loan amortization in months, not years. Is there an easy way to create or does anyone...

I would like for my pivot table to NOT show the data (in the data/column area) that sums to a zero value. I know how to show zero values and I went thru the...