Can someone please help me with using the column header titles as the comma separated content in another cell. I am using Excel 2016. I have a table named StudentCourse and for a better illustration please see the below example layout:
[Name] [Math] [Geo] [Bio] [Fees] [Fixes] Ram Very Bad Neutral Bad Yes Urgent: Math, Geo, Bio, Fees Dam Neutral Good Neutral No Urgent: Math, Bio Rik Good Good Good No OK: Not Urgent Nik Good Good Good Partial Urgent: Fees
The values for the subject columns are from a drop down menu which has the options Good, Neutral, Bad and Very Bad and if the values Neutral, Bad or Very Bad are selected then the Fixes column will be updated with the prefix Urgent: and the column header name (Math, Geo or Fees) depending on what needs to be fixed. If, no fixes are needed then the Fixes column's value will be Ok: Not Urgent. The Fees column also follows the same concept and if No or Partial is selected from the Fees column dropdown options then likewise that will be added to the fixes column.
I would greatly appreciate any assistance at all.
I should also mention that I am new to Excel.
Aucun commentaire:
Enregistrer un commentaire