semester

  1. M

    Should I use Index/Match?

    I have a dashboard where col B is academic terms and col D is their total fees. I have a hidden sheet with the breakdown of their fees that I want to load on that multipage. When a user double clicks a term in column B a multipage in a userform pops up. So if Semester 1 is double clicked the...
  2. M

    How many userforms can excel handle?

    Long story short I'm still about one years old using VBA and I'm making a spreadsheet with multiple semesters in column A. In column B is tuition, and in column C is fees. I just started making this so I haven't gotten very far, but I currently have it set up where when you click on cell C1 a...
  3. R

    Index/Match formula for multiple values and columns with uneven length

    Hi, This appeared to be a simple vlookup and match task but I kind of ran into a roadblock. I'm working on a financial report that shows amounts of aid students will receive for the year and semester. In sheet 1, I have a list of students that are coded with a unique ID number and an item type...
  4. M

    Trimester/Semester/Yearly Formula

    Hi, I'm working on a personal file to handle my insurance portfolio and I need to identify which ones have to pay depending on what they bought ( By trimester,semester or yearly). The tricky part is that the start date has to remain the same. i.e. Start date : Nov 1st 2017 Type: Trimester...
  5. apgmin

    drop down multiple

    Please help A1 has the list has specialisation ( From a data validation list ) B1 has the semester no. ( 1 to 6) Now from Cells c1 to j1 the values should change based on the value of cells a1 and b1 like if the specialisation is marketing Management and semester number is 1 cell c1 till cell...
  6. D

    Loop through 2 columns and lookup data based on pairing

    I have some course data that has grade distributions. I would like to extract this data based on the course name and the semester when the course was taught. Is there a way to loop through a list of courses by semester, and lookup the grade data? In other words, start with ACC1013 and lookup...
  7. A

    statement to extract data based on date

    Hi guys. I am a teacher working on a spreadsheet that requires the extraction of data separately for fall & spring semester. My dates are done in columns so that each row is a student. Please see me cheesy example below: 8/17/2017 12/19/2017 1/3/2018...
  8. E

    Using Excel to Validate Grades

    Hi there, I am trying to create a formula in which a passing grade (A, B, or C) in a second semester math class validates a failing score (D or F) from the first semester. I have grades in two separate columns and want to add an additional column that checks to see if the semester 2 grade...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top