Cannot be hard
Posted by Jason on October 25, 2001 4:23 PM
I have a list of data on one worksheet. ex.school, first name, last name, etc. On another worksheet, I need a formula that will test the entire sheet of data and return on the worksheet the students first name in one cell and last name in a seperated cell. Basically every sheet will be a school listing the name of the student dependent on the first worksheet with data.
Thank you
Posted by Richard S on October 25, 2001 5:35 PM
Clarrification Please
Do you want a separate sheet for each school, listing all the students at that school? Don't quite understand your question
Richard
Posted by Don C on October 26, 2001 5:02 AM
Assuming that School, Last Name, and First Name are in different fields you can get a list grouped by school in several ways.
1 - use a filter to select a school
2 - sort by school, then use data/subtotals to group the records, including printing each school on a separate page.
3 - If you really need each school on a separate page, and there are not too many schools, filter, copy, and paste can be a fast way to go.
4 - if, as Richard has suggested you can clarify exactly what you are trying to accomplish, the VBA experts can probably provide a more complex solution.
Posted by More instruction on October 26, 2001 1:22 PM
More Detail
Basically it is one workbook with a number of worksheets. Worksheet 1 is the roster of students which includes the school, first name, last name etc. Worksheet 2 is labeled the name of one of the shools in the roster. On sheet two I want all the students names that attend the same school as the worksheet name to automatically appear. I tried the this formula placed on worksheet 2, =IF(MATCH($A$2,'Student Roster 10-25'!$H:$H,0)=1,"",INDIRECT(ADDRESS(MATCH($A$2,'Student Roster 10-25'!$H:$H,0),3,,,"Student Roster 10-25"))), in cell A2 is the name of the school which is the name of the sheet. What is happening is that I can only retrieve the name of the first student in the list that is validated true by the above function. How can I make it skip name alredy displayed and move on to the others.
Thank for your help
