Hi All,
I have a spreadsheet laid out like below (headers as columns):
<tbody>
Class
Start
End
Category
Mod01
01-May-2019 10:00
01-May-2019 12:00
Sem
Mod02
01-May-2019 11:00
01-May-2019 13:00
Tut
Mod02
02-May-2019 09:00
02-May-2019 10:00
Lab
Mod03
03-May-2019 10:00
03-May-2019 11:00...
Hello All,
Can any one please help me with this.
Column J has the list of all students names
In Column B we have to select the students name as it is data validation, list of J1 to J1000
Column C ( course name ) is the V look up so it gets auto populated
column D we mention the semester number...
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.