Hello everybody. The following is my data NO Sec English maths Science Social 1A1 1A 25 25 25 25 1A10 1A 25 25 24 25 1A11 1A 24 22 24 25 1A12 1A 25 25 23...

Hello everybody We maintain school marks database in excel. Students belongs to different calsses from 1 to 10th and different sections (say 1a, 1b, 2a, 2b...

I have an User Defined Function sent by EXCEL group. Where shall i place this to use it as a normal worksheet function in any excel file i open. eg like...

This may be simple, but I am an Excel novice. I want to be able to copy cells on a worksheet having the absolute reference adjusted. Reason. I have a custom...

I have a spreadsheet that I am trying to get 8 cells to conditional format based on the "highest" condition of one cell. I got 2 of the three conditions to...

I have a formula that I want to write that the cells meet the conditional format for times of day. I struggle to figure the "correct" language in an excel...

I want to use the IF function to automatic run my macro when the condition is true or false. Currently the macro need to run by mouse click or...

I want to copy the formula below down the sheet so that the week increases. i.e. week 12 week 13 etc. (The week represents a different named...

I have a work sheet with a column of numbers, that are always being added to. I want use a different worksheet to lookup the last number in the column in...

I have a worksheet that has several columns of numbers, when I opened it today all of the numbers were changed to dates. I had to reformat them back to...

Have a list of 8 names in 6 columns across a sheet they are the same names but in different alpha order. the column before each name has a number 1 through 8...

A B Range Average 200.0 46.0 500.0 120.0 3900.0 1733.0 950.0 485.0 3000 3317.0 4.8 4.0 2.0...

I was given this formula {PMT(D412,E4,-C4)} to describe what it will do, but I don't think this will do anything because it's missing a multiplication or...

Hi everyone ,i got a problem here. I want to get a portion of a string ,so i use mid() fucntion,but after i entered =mid(m2,2,2) , the function doesn't...

I have a table that is created by copying and pasting text from a pdf file. The problem isthat when the text is pasted into excell it does not recoginzed...

I have been using MSNStockQuotes on a few computers without any problems for months. Now (in the last day or so) , when I press "update Quotes" on any of the...

I'm trying to generate a little spreadsheet that will determine the winning results for the lottery for a list of tickets. I have a winnings rule...

I have a large column of numbers that needs the decimal inserted. Please help

Currently I have a sheet where I enter my data and then another sheet within the same workbook that makes various calculations based on this data. But every...

I know that you can create a list (i.e. Produce - Fruits, Vegetables, etc.) and then a dependent list (i.e. Fruits -Apples, Oranges, etc.). But you have to...