I have a spreadsheet that has various grades fro students. I would like to retrieve the up to four grades from each row and place them in the cells at the end of the row. I don't mind the column that they come from.
I have no idea where to start with this. The grades can exist in columns E to AC but are always in different columns. I have done this manually to demonstrate the problem.
Capture.JPG
I have also attached the spreadsheet.
Many thanks to anyone who can provide a solution.
Hi,
in AD2 to be copied across
Please Login or Register to view this content.
Please refer to the attachment: I'm translating formulas from another language.
Regards
Last edited by canapone; 03-29-2017 at 09:19 AM.
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks