I am trying to figure out if there is a way to program the cursor to automatically move from one cell to the next without having to use the arrow buttons, or...

I'm not getting good values when I use dates in conditional or AND formulas. Example: =if(A11/1/2004),1,0) Example: ...

I have text from one worksheet that I want to link to another worksheet, but I don’t know how to do it. To give you a better idea, on the first sheet I have...

I have a cell formatted as mm/dd/yy hh:mm and I need to subract 3 hours from this value. example: 09/30/08 16:00 result should read as 09/30/08...

On Worksheet 2 I am pulling data from a data base to create the bar code sheet from on Worksheet 1. Worksheet 2 Data Column A Column B...

Help me please I am attempting to import a file that is too large for excel. It has to may columns and is getting cut off. Is there anyway to import the full...

Many thanks to Sean Timmons for the Vlookup solution. Using the same Excel 2000 worksheet, (I have two lists of data, both two columns. The first list is...

Is this how you set up an IF OR statement for Excel? =IF(B2="123U" or "12B3",$J$2,IF(B2="123N",$J$4,IF(B2="123T" or "345T" or "678T",$J$5,IF(B2="123W" or...

I have 8 groups (each group is column for description, and one for quantity) of colums, 400 lines long that have formulas in them to get the information to...

I have the following formula, which looks up the following: The expense amount (Legal!D1:D3) in the year 2006 (Summary! E2) for the month of February...

I need to calculate the max and the min of a certain column (say B) as long as the name in Col A matches a certain value. Basically it would have to do the...

Hi, I have no problem protecting a worksheet with the 'Protect Sheet' option, but is there anyway i can protect the whole workbook the same way, without...

Hi everyone, I am re-wording my original query to try an clarify the issue and hope someone can help: Data is copied into a workbook starting with Row 7 Cell...

I am trying to get the absolute average of a column of positive and negative numbers, so i am trying to gather the absolute sum of the numbers using the...

I am a golf coach and am trying to figure out how to add the 4 lowest scores to come up with the team score for my HS golf team. I understand the simple sum...

I have a worksheet that I am using on the first sheet "high priority" A3:A5764.. I have my master contact list. on the second sheet "bouncebacks"...

I am trying to get a price list to work using excel! I have all of the prices in one spreadsheet, but I need to process the information a little differently. I...

I have a data sheet with data listing users and a product group. I need to count the number of occurances where the user and group match. so on the second...

I have two dates say 15/08/1995 and 31/07/2008, I want to calculate the number of months between these two dates mentioned. how do I do that?

I need some help. I'm working on a 4,500 row worksheet. In each cell, there is a lot of information. For example: A1 would read: KWI 200DNL 11P DOR...