boss of mine decided to start a new monthly excel challenge and while I have one way of solving the problem, it is not the more "elegant, simplified" way he does it. it's absolutely killing me and he won't share until someone figures it out...problem is, google and this site are generally how I solve these problems and I can't find exactly what Im looking for...so here I am

its a simple data set (table below showing small example), and the idea is to write a formula in column j that will identify the 4 digit project numbers (B1-G1) that each employee spent >= 50% of their time on. Column I has the answers. Before anyone suggests it, I've already determined that I can CONCATENATE multiple IF statements, but he insists there is an easier way.

let er rip

employee | 1234 | 1235 | 1288 | 1646 | 1586 | 1975 | answers | formula | |

a | 50% | 50% | 1235,1288 | ||||||

b | 100% | 1235 | |||||||

c | 100% | 1646 | |||||||

d | 70% | 30% | 1235 | ||||||

e | 100% | 1975 | |||||||

f | 40% | 60% | 1288 | ||||||

g | 50% | 50% | 1646,1586 |

<tbody>

</tbody>

forgive me for not attaching the file, work computer restrictions...