Find cell values >0 and return column header label

[camilleso]

Hi, I'm looking for help in creating a formula that can return column header names if the value in the cell is greater than 0. If Id 1 has a cell values >0, I want tag (header 2) and API (header 3) to be returned on a separate list.

Example of data:

Pixel(header1) Tag (header 2) API (header 3)
ID 1 0 5000 100000
ID 2 1000 0 0
ID 3 10000 100000 1000000

 

[Joe4]

Perfect! I think the online version haves TEXTJOIN. Easy way to find out is to try.
Does this test function work without errors?

=TEXTJOIN("+",TRUE,"a","b")

If so, then apply it to your current formula.