	AllExperts > Excel
	Search

About Philip Buckley
Expertise
In Excel 2003 I can handle all basic questions such as how to copy and paste, all medium type questions such as pivot tables, and also am proficient in basic macros. I am also quickly learning 2007 where everything is pretty much the same but all in different places. Please be as detailed in writing your question as possible as that goes a long way in my ability to give the best answer possible.

Experience
I have 20 years of business experience, mostly in the area of finance and business consulting. Currently I am a Senior Business Consultant with a small business consulting firm. As part of my daily activities, I regularly use Excel to help make small businesses more efficient.

Education/Credentials
MBA from the Crummer Graduate School of Business at Rollins College.

You are here: Experts > Computing/Technology > Microsoft Software > Excel > extraxt specified data from a sheet

Excel - extraxt specified data from a sheet

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.

Add to this Answer Ask a Question

About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here