Hi all, I have an excel with numerous diagnostics that are being tested for a phone (either fail/successful). I then have a Hardware summary column that tells you if the phone was successful or has failed, for all the failed phones i want to have a formula that will allow me to see all the column headings that have failed for that specific phone.
See below for the excel to get a better understanding. The formula I have tried to use currently only returns 1 column heading/failure, even if there are numerous diagnostics the phone has failed.
The formula i've used is: =IF(H21="failed",INDEX($M$1:$AZ$1,SUMPRODUCT(MAX((M21:AZ21=H21)*(COLUMN(M21:AZ21))))-COLUMN($M$34)+1),"-")
Any help would be appreciated! Let me know if anything is unclear, thank you!!
See below for the excel to get a better understanding. The formula I have tried to use currently only returns 1 column heading/failure, even if there are numerous diagnostics the phone has failed.
The formula i've used is: =IF(H21="failed",INDEX($M$1:$AZ$1,SUMPRODUCT(MAX((M21:AZ21=H21)*(COLUMN(M21:AZ21))))-COLUMN($M$34)+1),"-")
Any help would be appreciated! Let me know if anything is unclear, thank you!!