Return column headers for all true values in Google Sheets

**tim34** · 03-29-2021, 12:47 PM

Hi everyone,

I have a large data sheet with a list of suppliers and one column for each supplier with a TRUE or FALSE value (this is a text field).
I'd like to consolidate all true suppliers in one cell.

In the image below I'd like column G to summarise all suppliers with the value TRUE (i.e. "Supplier 2, Supplier 3" for row 3.

Screenshot 2021-03-29 at 13.29.25.png
Can anyone help me with the right formula?

Many thanks

Tim

**Bernie Deitrick** · 03-29-2021, 02:16 PM

If you can live without the commas:

=trim(ARRAYFORMULA(join(" ",if(B2:F2,$B$1:$F$1,""))))

or, if your Supplier names don't have any spaces:

=substitute(trim(ARRAYFORMULA(join(" ",if(B2:F2,$B$1:$F$1,""))))," ",", ")

**rorya** · 03-29-2021, 05:00 PM

You could use:

=join(",",filter($B$1:$F$1,B2:F2=TRUE))

**tim34** · 03-30-2021, 02:57 AM

Thank you both! I really appreciate your help. They both worked well - Rorya’s just that bit better as I could have commas.

Return column headers for all true values in Google Sheets

LinkBack

Thread Tools

Rate This Thread

Display

Return column headers for all true values in Google Sheets

Re: Return column headers for all true values in Google Sheets

Re: Return column headers for all true values in Google Sheets

Re: Return column headers for all true values in Google Sheets

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Google Sheets: Add filter symbol to column headers

Return YES only for last instance of value in a column (Google Sheets)

How to return column headers for where certain values appear in each row

[SOLVED] Return Column Headers based on row rank with duplicate values in row

Excel 2008 : Rank Array Values and return with Column Headers and Row Headers

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions