In the previous version I could select "show page" from the drop down menu to create new tabs per page field. I can't find that funcionality in this version,...

When attempting copy/paste, a message pops up that reads "Microsoft cannot empty clipboard." However, my clipboard is empty. This is preventing me...

I would like to use a range of numbers in an IF statement. As an example IF("C8 =3,4,or5",25,0) which is meant to read if cell C8 is equal to the number 3,...

2Please help with the syntax for the following: If the contents in A1 = the contents in A2, put the contents of B2 in D1. Thanks, ck

I have filter media that I need to order every week and some filter medias I have too much of. I need a formula that can tell me the exact date I need...

IThe short version of this question is above the line......you can help a lot if you respond to only THAT. I am using Excel 2003 on an XP machine. If two -...

When creating a worksheet with main categories on the top line (i.e. Date, amount, notes, etc.) how do I adjust preferences so that when I scroll down the page...

If i have a numbers in the cell . eg : 1.1 , 1.2 , 1.3 , 2.1 , 2.2 , 2.3 for this numbers i want to find say like 3 smallest number then Sum it up. it will...

Here's what I can't figure out how to do, I have two lists of checks, each formatted with first column check number and second column check amount: CK# ...

My problem is that my formula is returning values for which there shouldn't be a value. Here's the first...

A link between two workbooks using the SUMIF function is not updating unless you open the master workbook. Why isn't the s/s automatically updating?

I'm trying to do what i think is quite a simple function. I have a data array (B5:B13) with the following values in it: 14 40 45 59 70 79

Is it possible to use the countif function to count a t seperate from...

OK I have data in a rate card sheet that I want to display in another worksheet in the same book. This information will be selected from a drop down list. For...

I am splitting a cell in the cell is dix00001 I need to split it from the first three letters, and when I do I get dix in one cell and a 1 in the second cell...

On complicated Excel workbooks it is easy to lose track of which cells reference which. If there was some feature that could map out which cells reference the...

Hello, I am working on an Excel project in which I need to return one cell value from an array based on multiple conditions. Let me explain my example as...

i got alot of columns in a sheet and i want to use the sumproduct to calculate the sum of a vehicle no based on a few criterias(e.g) ...

I am creating a form for employees to fill in. One of the automated calculations will be a percent that I will either round or truncate to 1 decimal (ex: ...

this is my problem: the number for tyre replacement is the location of the tyres(1,2,3,4,5) vehicle no start km end km tyre replacement(if any) x1234 45 67...