Welcome to Geeks to Go - Register now for FREE

Need help with your computer or device? Want to learn new tech skills? You're in the right place!
Geeks to Go is a friendly community of tech experts who can solve any problem you have. Just create a free account and post your question. Our volunteers will reply quickly and guide you through the steps. Don't let tech troubles stop you. Join Geeks to Go now and get the support you need!

How it Works Create Account

Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

Excel 2007 Challenge

Started by s.r.2303 , Jul 10 2008 01:41 AM

This topic is locked

#1
s.r.2303

Posted 10 July 2008 - 01:41 AM

New Member

Member
1 posts

Hi all!

I was given this challenge and I was hoping someone could help me out.
It's an Excel 2007 file with 2 sheets; one is a table listing ID numbers, the courses that were taken by those specific IDs and the grades that were given for each course in 3 consecutive columns. The other sheet is like a "report card". What I need to do is create a formula that will allow a user to enter an ID number in a box at the top and then have all the grades that were awarded to that ID number fill in automatically next to the course name. Any courses that are not listed that the ID number took should then be listed under extra courses in a table on the side.

Any help? The sooner the better.

Thanks,
S

#2
frantique

Posted 10 July 2008 - 05:40 AM

Member 2k

Member
2,700 posts

s.r.2303 this sounds very suspiciously like homework .... and we do not help with homework!

I am closing this thread and if you feel my judgement about it being homework is incorrect, please PM me.