Hi All,
I'm a teacher and want if an excel says a certain class in a cell (Class 2B) for another cell to produce a list of all the pupils in the class (20 pupils) in individual cells.
I've got all the background data populated, just not sure how to write the formula. Can anyone help? Or would I need to put them all into one cell and then format them into individual?
Thanks!
Before I help again, please go and acknowledge the assistance I gave you last time and mark the thread as solved: https://www.excelforum.com/excel-gen...t-columns.html
Then provide a sample workbook, please.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Apologies Ali, I have done this now.
I've also popped a link here to an excel....unfortunately it doesn't let me post links but the link is the usual bitly start with excelhelp1 at the end.
Thanks again!
No - attach the workbook, please. Instructions in the yellow banner at the top of this page. I shan't be following any links.
No, you have not marked the previous thread as solved, nor have you even replied to it!
Last edited by AliGW; 04-24-2024 at 06:56 AM.
Once you attach a workbook here, I shall help you.
Still waiting for you to attach a workbook - please do so. Make sure it's desensitised.
Book2.xlsx
Thank you
I don't understand. Your workbook says: IF responses sheet cell says 1A then list all pupils in 1A and the tasks they have completed.
Are you saying that whatever is listed in that sheet needs to be replicated on the results sheet?
Not quite - I have an ongoing spreadsheet where teachers for example say
All of "Class A" have completed "Maths Test 1" for example. In the background we know that Test 1 in Maths covers trigonometry, algebra and arithmetic for example.
All of "Class B" may have completed "Maths Test 2" and in the background we know that this might cover trigonometry, pythagorus and theory.
My final sheet would then have a list of the pupils in Class 1A having completed trigonometry, algebra and arithmetic and a list of all pupils from Class 1B having completed trigonometry, pythagorus and theory.
For the end-user it should be simple, full class have completed this test.
Summary should be individual pupils with the areas covered.
I hope that makes sense?
Try this:
=LET(pc,'Pupil and class info'!A2:B16,r,Responses!B2:D4,HSTACK(INDEX(pc,,2),DROP(REDUCE(0,INDEX(pc,,1),LAMBDA(x,y,VSTACK(x,FILTER(r,Responses!A2:A4=y)))),1)))
I'm trying to think of an every day example of it...
In terms of tests and areas covered it would be like going on to "HelloFresh" or equivalent and ordering menu items 2, 4 and 6 and in the background that means HelloFresh will know for packing Item 1 needs an onion, a pepper and chicken packed whilst item 4 needs pasta, eggs and tomatoes.
I'm not sure if that's a good example or not
See post #10.
I was a teacher for 31 years before I retired and a HoD for the final nine of them. I was also the school timetabler.
Your forum profile still needs updating to 365 - I asked you to do that back in January.
Thank you, that looks good. I'll put it into our spreadsheet and adapt it to the tables we have.
To be clear, there was no malice with the previous posts - I do have a history of coming back and saying thank you in other forums so although I forgot it in this instance there was no intention there.
Thank you again,
Much appreciated!
You're welocme, but you still need to update your forum profile, please.
I cannot be aware of your behaviour on other forums, only your behaviour here. I am sure you don't accept bad manners from your pupils (I never did).
Glad to have helped.
If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.
Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.
Thanks for updating your profile.
It's not quite doing what I'd like it to on Excel365 but it's certainly gave me a good template to adapt. Thank you!
In what way is it not quite doing what you want? I have 365 - it will be doing the same for you as it is for me. It produces the results that you showed that you wanted - provide a more detailed workbook with expected results mocked up and I'll take another look. I can't produce solutions for problems that I cannot see.
Hello,
I have attached as close to the final sheet as I have below.
https://glowscotland-my.sharepoint.c...64eKw?e=rfIDxf
There's a small explanation under the sheet "Introduction" and a perfect picture of outcome under "Final sheet"
Thank you!
Please attach the workbook HERE, please.
Sorry I will get the hang of this eventually!
There's no pupil and class info, so I cannot link pupils to the correct tasks completed!
Could you add that and attach again?
Sorry - found it!
Right - try this:
Please Login or Register to view this content.
Last edited by AliGW; 04-24-2024 at 11:46 AM. Reason: Workbook added.
Seen, but no reply ... Hopefully it's OK?
Glad to have helped.
If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.
Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks