remove names across the sheet after adjusting the link on sheet 1

Question

Level 1

12 points

remove names across the sheet after adjusting the link on sheet 1

I'm a teacher and analysing the summer results for the whole cohort, but then also individual teacher classes. I have several sheets with data on coursework, exam 1, exam 1, questions etc for all the students, but then need data broken down by getting class-specific details.

eg 100 students and 3 teachers

I have analysed 100 students, but now need to remove class B and C students to focus on class A students.

The only way I know how to do this seems very long: delete the names on the linked sheet (I have all the sheets populate with the names entered in the coursework sheet), but when I do this I get the error cone icon and so still have to go in and manually delete all those to get the results.

Is there a way to delete the names on that linked sheet that then also removes all the error cones across the other linked sheets?

Hoping that makes sense!

eg here is a screenshot snapshot of what it looks like on the second sheet when I have deleted the names of all but one class on the coursework sheet.

many thanks!

Greg

MacBook Pro 13″, macOS 13.0

Posted on Sep 8, 2024 3:22 AM

Reply

Answer 1

SGIII

Level 8

36,134 points

Sep 8, 2024 4:09 AM in response to KippMajors78

What is the formula in Column A?

Rather than deleting data have you considered using one of these methods to analyze subsets of the data?

Filter data in Numbers on Mac - Apple Support

Intro to pivot tables in Numbers on Mac - Apple Support

Intro to categories in Numbers on Mac - Apple Support

These require little or no formulas, just a few clicks and drags. Pivot tables (Table > Create Pivot Table > On Current Sheet) leave your original table intact whereas the categories feature rearranges it within the original table.

You can also uses formulas to extract summary data in various ways.

SUMIFS - Apple Support

The templates in the 'Education' section at File > New in your menu have a 'Grade Book" and 'GPA' calculator that may give you ideas as well.

In general it pays off to put all like data in one table (one-time copy-paste can do that) and use the above methods to analyze it and break out subsets.

SG

Reply

Answer 2

KippMajors78 Author

Level 1

12 points

Sep 8, 2024 4:10 AM in response to SGIII

Thank you for the swift resoonse, I will look at those links you have kindly posted.

The formula is just NEA::DATA::D3 (in that cell I just added "=" and then clicked the 1st name in the NEA sheet and then copied the formula down

Reply

Answer 3

SGIII

Level 8

36,134 points

Sep 8, 2024 4:41 AM in response to KippMajors78

Ah, I see, you are just pulling in data from another table.

That can work in some situations but I usually try to avoid it because of the very problem you illustrate: if you delete data from the source you end up with error warnings.

If possible it usually works out better to avoid duplicating the same data in different places like that.

Pivot tables are easy to try. They will quickly give you summary statistics. Well worth looking into. Their results may end up not being formatted the way you want (say you need to show them to other people) but it is easy to copy-paste their results into an ordinary table and format that the way you want.

If you need to list the students together with summary statistics then categories may be better for you, but then your original data may lose its original order, which may or may not matter depending on what you are doing.

SG

Reply