I want to take to sets of ID numbers with different associated data and combine them on one sheet. How do I do this?

Excel 2000 SR-1 I am trying to write a VB code using a For - Next statement to calcualate cells. The basic satement is: For X = 1 to 7 = {Calcualtion} '...

We are entering data on questionnaires completed by parents and drawing graphs from these. However, where data is missing X-cel gives a value of 0 which is...

i need to know how to use solver function inexcel to fix in to the experimental value in to a exponential graph

I've seen a previous post, but could not apply it to my case. A macro which works well in Excel 2000 is not working in 2003, which follows; Sub...

Hello, Not being an excel wizard I need some help on this one. I have a summary sheet of a number of differnt teams at work, then in four different...

Excel 2000 SR-1 I am trying to write a VB code using a For - Next statement to calcualate cells. The basic satement is: For X = 1 to 7 = {Calcualtion} '...

Excel News group, I would like to display "03/04/1997" instead of just the type listed "03/04/97", I hope there is a option to do this. I do have XP & excel...

i need help opening an excel file

I am trying to find a solution for the following formula but cannt seem to get anything. Could somebody please help. In Cells S7 to S26 I have various...

Total Total Low Adjusted Final Pt Test #1 Pt Test #2 Pt Test #3 Midterm Points Pt Test #4 Pt Final Points grade points Average Students #1 #2 ...

This is one option: ColB: =LEFT(A5,SEARCH(",",A5)-1) ColC: =RIGHT(A5,LEN(A5)-SEARCH(",",A5)) This is the...

We have been updating some of the old company forms and one of the old forms requires a voucher number for each record. The voucher numbers are created by the...

I am new to WindowsXP and Excel and struggling. When preparing a document from the .xlt file it prints 2 pages. When I do a Print Preview on the .xlt I can see...

How do I preserve a reference to data when the data's cell is moved by a sort? Example: F5 refers to M10 (either =M10 or =$M$10) and M10 contains...

I want to make a chart/graph that will have 3 columns where I can enter my bills and have them automatically calculated. !st column the name of company, Second...

I want to make a chart/graph that will have 3 columns where I can enter my bills and have them automatically calculated. !st column the name of company, Second...

I have a workbook which a colleague uses to enter data. The data is then manipulated on the same worksheet, but if these columns arehidden they can easily be...