return column header for exam

rawdata89

New Member
Joined
Apr 26, 2022
Messages
6
Office Version
  1. 2021
Platform
  1. Windows
  2. MacOS
  3. Mobile
  4. Web
Hello

I am trying to create the exams taken column with a very large file. What would I need to use to create something like column b (EXAMS TAKEN) where it returns the coulmn header by student who took a given exam?

Student No.EXAMS TAKENART EXAMPE EXAMFREE LUNCH?MATH EXAMSPECIAL ED?
Student 1PE EXAM & MATH EXAMFALSE98TRUE90TRUE
Student 2PE EXAMFALSE100TRUEFALSEFALSE
Student 3ART EXAM & PE EXAM & MATH EXAM8995FALSE75FALSE
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Hi & welcome to MrExcel.
How about
Fluff.xlsm
ABCDEFG
1Student No.EXAMS TAKENART EXAMPE EXAMFREE LUNCH?MATH EXAMSPECIAL ED?
2Student 1PE EXAM & MATH EXAMFALSE98TRUE90TRUE
3Student 2PE EXAMFALSE100TRUEFALSEFALSE
4Student 3ART EXAM & PE EXAM & MATH EXAM8995FALSE75FALSE
Data
Cell Formulas
RangeFormula
B2:B4B2=TEXTJOIN(" & ",,FILTER($C$1:$G$1,(C2:G2<>FALSE)*(ISNUMBER(SEARCH("exam",$C$1:$G$1)))))
 
Upvote 0
Solution
Hi & welcome to MrExcel.
How about
Fluff.xlsm
ABCDEFG
1Student No.EXAMS TAKENART EXAMPE EXAMFREE LUNCH?MATH EXAMSPECIAL ED?
2Student 1PE EXAM & MATH EXAMFALSE98TRUE90TRUE
3Student 2PE EXAMFALSE100TRUEFALSEFALSE
4Student 3ART EXAM & PE EXAM & MATH EXAM8995FALSE75FALSE
Data
Cell Formulas
RangeFormula
B2:B4B2=TEXTJOIN(" & ",,FILTER($C$1:$G$1,(C2:G2<>FALSE)*(ISNUMBER(SEARCH("exam",$C$1:$G$1)))))
You saved me so much time, it works beautifully, thank you so much!!!!!!
 
Upvote 0

Forum statistics

Threads
1,224,820
Messages
6,181,154
Members
453,021
Latest member
Justyna P

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
Back
Top