dimanche 27 juin 2021

Use Table Header as Content In a Cell

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