Is there a way of taking a list of five numbers and adding together only the highest 3 (ignoring or dropping the two lowest marks)? E.g. if the numbers were...

I want to auto fill a colum as shown 1 1 2 2 3 3 4 4 ect ect but everytime i do it i end up getting decimals. or sometimes ill get 3 of a number instead, is...

new to spreedsheets and a bit stuck i'm doing a spreedsheet of results for a snooker league. i'm doing a form table from the results but having a problem i...

if you are using the index/match combination function is it possible to index the row below the result. In other words is it possible to take result...

I would like the specifics of 10 rows in sheet 1 to be copied into rows in sheet 2. Column A will contain the # of items the remainder of row describes. ...

im not the best at my formulaes when it comes to excel, im on a trial period for a I.T company and ive been asked to come up with a formule. heres my problem,...

I'm new to excel but I have learned a lot. I need help to improve my Excel Weekly Work Order Schedule. I need to make a FORM to fill out the Work orders for...

I have two worksheets. On one a name, date and amount (thousands of records). The other is a small sample containing just a name and date which i require to...

Can anyone tell me what's wrong with these formulas? Using small test workbook. =SUM(VLOOKUP(A7,Sheet2:Sheet3!A1:D5,2,FALSE)) This gives #VALUE! I have...

How do I name a range of cells in a worksheet to be used to grab data from another worksheet? All this highlighting cells time and time again is a pain in...

problems with TRUNC -------------------------------------------------------------------------------- Hi, I seem to be having trouble with the TRUNC...

I have formatted each cell as a time cell. I would like to take the time, 4 minutes 30 seconds and 20 one hundredth of a second, use a formula in column B and...

I would like the first row of each page to have the same information. Without making it a header, and having to retype it each time!! You don't see the...

Need to know how to assign colors to different cells when a certain set of initials are typed into a cell. I have 4 crews with 7 individuals and need to keep...

=COUNTIF(B2:B6,"D2") This formula always returns the result "0". The cells are formatted as dates. If I convert the range to numbers, and insert a number as...

Is there a way to find the first occurence in a list of unsorted values that is greater than a specific lookup value? The list is a column of unsorted numbers...

Hello. Has anyone had the problem where an array formula appears blank within the cell? For example, I have the following array formula in cell...

I have a spreadsheet that is shared between 8 people on a network. Is it possible to protect this so that each person only sees the parts of the worksheet...

I want to change the format of a cell when a number in that cell matches any number in a largerrange of cells (50 Cells).

I have 60,000 data files in a folder. I have a list of these file names and thire contents in an Excel spredsheet. I can sort and select the file names I...