I want to creat table which contents Four subjects examinations and 100 student appears for it in five languages in seven cities. I want report and totals of each category like How many students appear in which subject examination, which language in one city.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
This requires you to create a table. Look for a Table menu or menu item in the Format menu. You'll need to tell it you want two columns and five rows in the table. After you've inserted the items you can then highlight everything in the table and right click to choose bullets from bullets and numbering from the format option.
You need to create subtotals so that it looks like something like this:
Prod/units Amt. Level Total
xxxx 10.00 1 yyyy 20.00 1 30.00
dddd 40.00 2 ffff 30.00 2 70.00
To do this I would suggest using the Pivot Table feature of Excel. It is not too hard to use but you do have to know what you want and also have to be sure you are getting results as expected. Like any tool, it has to be used right. You can also use sub-total functions supplied in VBA as well in your cells.
If you want to avoid using VBA functions in cell and deal with ranges, etc., use the Pivot Table Wizard.
Some reading: http://www.ehow.com/how_13020_pivot-table-wizard.html http://www.microsoft.com/dynamics/using/excel_pivot_tables_collins.mspx http://www.ozgrid.com/Excel/excel-pivot-tables.htm
Also Google "Excel pivot table wizard" to get more.
Highlight the entire pivot table and name it as a range. Then in the formula, replace the reference to the table addresses with the range name. Then wherever you move the table (move, not cut and paste) it will automatically gather the right data. Thanks for rating FixYa!