what would the formula be for...

Hi guys I am trying to create attendance sheets for my school students, who are taking various subjects. Right now, I have a sheet called "subjects" where in...

Hi guys this is my situation. I have 2 sheets now, Sheet1 and Sheet2. In both sheets, my headers for the data are exactly the same. Only thing is, in sheet1,...

Hi guys this is the problem I'm having right now. On sheet 1, I have the headings as follows: student name NRIC number block number street name ...

Hi guys I need to know how I can format cell such that when I enter a 6 digit number such as "035891", it will be displayed as "S(035891)" instead. So...

Hi guys this is my problem. I have serial numbers in my entire A column and dates in my entire B column. On a separate workskeet, I want to create a command...

Hi guys here is the issue. Under column A, which is titled serial number, I have listed the formula =IF(ISNUMBER(B28)=TRUE,A27+1,""). What this does is that...

Hi guys I recently decided to put in my students' attendance into a worksheet. A sample of one of the student's sheets can be seen at...

How do I check if the content in a cell, when divided by 4, returns an integer? It should give me 150 if it is an integer and display "NA" if it is not an...

Hi there I am trying to create a workbook that can monitor the progress of students' results. As of now I have managed to create worksheets using the "list"...

Hello All, Can anybody tell me how can i take take printout only of Odd pages or Even Pages or selected page like page number 1,5,11,20 ect. in Excel...

In Excel 2003, when I copy cells, I receive an error message that says "Cannot Empty the Clipboard" and am unable to paste the cells into any other application...

i have a policy in bajaj allianz life insurance i all ready send a mail reagarding the full details but i dont know the meaning of policy terms.so please...

can excel reorder lines of text from a txt file? example would be.... joe john jim james

I am having trouble generating a parts list from multiple sheets in a workbook. I am calculating sell price for entire projects. I have many different...

I want to create a group sales agreement template in Excel like I can with Word. I know it involves databases and workbooks. I just can't remember how to do...

how do i turn on the dit functions in Name Manager?

Wanted to know the shortcut keys for Left, Centre and Right Aligning text in a cell in in MSExcel2003.

On the rectangular box along with the figure there is a green triangle ypside down. What does it means.

I have a list of computers....I want to count the total number of computers in my list. I'm going nuts...it should be simple, but I can't figure it out!!!