Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Automating Data Analasys
I am working on a project for my department that involves looking at
student rosters, checking what classes each student is registered for and then recording how many classes they are registered for during: M-F during the day (D) M-Th during the evening (E) Friday evening (F) Saturday (S) Sunday (U) And then how many credits they are taking in each of those periods. I now have 3 spread sheets I am working with One will contain all of my final information One contains the student's classes they are registered for (via our code for the class) The third is a list of all of the info on each class (sorted by codes) In the third sheet (the Class list) I have created a formula that has given me what time period each class falls under (D, E, F, S, U). What I now need is a formula for my student spread sheet. What I want it to do is: Look at the Cell to the left of it (this will either be blank or contain a code) Identify that code on the sheet that has my class list (for ease of refference I have just made a second worksheet named CLASS, so refferencing it is done via CLASS! I know). Pull out the letter code (sitting in the cell to the Right) and that would be result of the formula. My main problems a 1) I don't know how to have a formula seach through a list for something specific. 2) Refference something that is one column over (B-1 = A? A+1 = B?) Once I understand these things I should be able to automate what aparently was done by hand before :) Thank you for your time and help. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Automating Data Analasys
Well, I have found out how to use VLOOKUP, and that made things much
easier :D I figgured out a simple IF statment lets me check to see if I actualy need to run the conversion.... Things are looking up :D Thansal wrote: I am working on a project for my department that involves looking at student rosters, checking what classes each student is registered for and then recording how many classes they are registered for during: M-F during the day (D) M-Th during the evening (E) Friday evening (F) Saturday (S) Sunday (U) And then how many credits they are taking in each of those periods. I now have 3 spread sheets I am working with One will contain all of my final information One contains the student's classes they are registered for (via our code for the class) The third is a list of all of the info on each class (sorted by codes) In the third sheet (the Class list) I have created a formula that has given me what time period each class falls under (D, E, F, S, U). What I now need is a formula for my student spread sheet. What I want it to do is: Look at the Cell to the left of it (this will either be blank or contain a code) Identify that code on the sheet that has my class list (for ease of refference I have just made a second worksheet named CLASS, so refferencing it is done via CLASS! I know). Pull out the letter code (sitting in the cell to the Right) and that would be result of the formula. My main problems a 1) I don't know how to have a formula seach through a list for something specific. 2) Refference something that is one column over (B-1 = A? A+1 = B?) Once I understand these things I should be able to automate what aparently was done by hand before :) Thank you for your time and help. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Automating Data Analasys
Do you need any more help with this, or are you at a good place right now and
just looking forward to your next brick wall? If so, reply to this and I'll get back to the thread as soon as I get the email. "Thansal" wrote: Well, I have found out how to use VLOOKUP, and that made things much easier :D I figgured out a simple IF statment lets me check to see if I actualy need to run the conversion.... Things are looking up :D Thansal wrote: I am working on a project for my department that involves looking at student rosters, checking what classes each student is registered for and then recording how many classes they are registered for during: M-F during the day (D) M-Th during the evening (E) Friday evening (F) Saturday (S) Sunday (U) And then how many credits they are taking in each of those periods. I now have 3 spread sheets I am working with One will contain all of my final information One contains the student's classes they are registered for (via our code for the class) The third is a list of all of the info on each class (sorted by codes) In the third sheet (the Class list) I have created a formula that has given me what time period each class falls under (D, E, F, S, U). What I now need is a formula for my student spread sheet. What I want it to do is: Look at the Cell to the left of it (this will either be blank or contain a code) Identify that code on the sheet that has my class list (for ease of refference I have just made a second worksheet named CLASS, so refferencing it is done via CLASS! I know). Pull out the letter code (sitting in the cell to the Right) and that would be result of the formula. My main problems a 1) I don't know how to have a formula seach through a list for something specific. 2) Refference something that is one column over (B-1 = A? A+1 = B?) Once I understand these things I should be able to automate what aparently was done by hand before :) Thank you for your time and help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
automating get external data (from web) | Excel Worksheet Functions | |||
Line Graph Data Recognition | Charts and Charting in Excel |