I have a master list of information on one sheet with each row being one set of information. I want to divide the rows into different sheets in the same...

Hiya, I didn't get a response earlier so I'm hoping if I post again with a bit more detail, some kindly soul might take pity on my extreme lack of knowledge...

I try to input data into a template my fried sent me. however it states..The cell or chart is protected and is read only! To modify a protected cell I must...

Hi, I,m John. I have on time format "h,mm" next trying to add cells: "=SUMIF(H34:H38,LEFT("se",2),K34:K38) "up to this point returns Ok, but when...

I am using the folloing formula to calculate workhours on the columns below. On most of the calculation the formula works 100% but in some cases, when column...

I am making a calendar, and need a cell that shows the first letter of the weekday. i.e. M, T, W, T, F, S, S I have formatted with "d", but of course that...

I have a file that is updated many times during a month. It is possible to include a Rev X in the file name so that X is automatically incremented each time...

I need to know how to perform this analysis using Excel 2007.

Hi, I am trying to devise a formula that looks down a set of data, and look in columns A and B for Year/Quarter and for each returns a count of whether...

A Pivot Table report has many entries that are blank and will be filled in as info. becomes available. The problem is the Pivot Table displays the word...

Hi, I have two columns Defect Type & Status in an excel sheet. I need to arrive at a summary based on the various values that are avaialble inthese columns....

I have two options to select from and only one of the options can be selected, lets call it A1 and A2. If a person selects A1, I would like to view only...

How i can separate Text from Cell into other cell by space for example Columne A Column B Column C Column D Mr. Muhammad Mr. ...

Hello, I'm really new to this so bear with me. I have got a worksheet with a drop down list for fees (drop down list options below) and check boxes for each...

Hi Is it possible to get a warning message appear when a cell value hits a certain value using standard Excel functions rather than VBA. Basically looking...

I would like to be able to enter numbers in a cell and have the number of significant figures automatically corrected defined by the following table Number ...

Is this formula a valid one. Is there another way of doing this? If(c6=201,copy c7,"")

Okay, I am still not getting it. So let me rephrase my issue. I have a large spreadsheet of student test data. Each student record is identical except to...

I have an old lotus 123 spreadsheet (a budget) that used the @nsum function. It allowed me to sum every third or forth column. The text below shows the...