Expert: Philip Buckley - 10/8/2009

Question
i have a sheet in excel contain two column and several rows. column 1 mark as student name and column 2 as score. each student may have data in several rows that unsorted and i don't want sort data. for example, "A" is one of student.
i want extract all rows of student "A" in second sheet by entering his name.

please help me.
I'm sorry for bad English

Answer
Nima,

Take the following steps:

1. Add a column labeled "Counter" next to the two other columns you have already
2. Give each row of data a unique number in this new column starting with "1" and increasing by one for each row of data
3. Click somewhere on the data
4. Select "Data" from the main menu
5. Select "PivotTable and PivotReport..."

This will open up the PivotTable and PivotReport Wizard.

6. Follow the three steps in the wizard and put "Student Name" and "Counter" in the "Rows" section and the "Score" in the "Total section.  Make sure it is the "Sum of Score" and not "Count of Score."
7. On the "Student Name" click on the drop down arrow and select the name of the student you want to see the scores for
8. Select "OK"

This will give you the scores for the individual student.