How to aggregate data?

Hi all,

I have seven columns of mutually exclusive data. I just want one column to pick the data that is true and return that category

A B C D E F Not Listed Category
FALSE FALSE FALSE FALSE FALSE FALSE Not Listed Not Listed
FALSE FALSE FALSE FALSE FALSE FALSE Not Listed Not Listed
FALSE FALSE FALSE FALSE E FALSE FALSE E
A FALSE FALSE FALSE FALSE FALSE FALSE A
FALSE FALSE FALSE FALSE FALSE F FALSE F
FALSE FALSE FALSE D FALSE FALSE FALSE D
FALSE FALSE FALSE FALSE E FALSE FALSE E
FALSE FALSE FALSE D FALSE FALSE FALSE D

I'm trying to get the data in the "Category" Column to populate (what's in there now is just manual for illustration purposes).

=IF(AK5="A"),"A",IF(AL5="B"),"B",IF(AM5="C"),"C",IF(AN5="D"),"D",IF(AO5="E"),"E",IF(AP5="F"),"F","Not Listed") This formula is not working, any suggestions?

Thx

Hi and welcome to the board

Try =IF(AK5="A","A",IF(AL5="B","B",IF(AM5="C","C",IF(AN5="D","D",IF(AO5="E","E",IF(AP5="F","F","Not Listed"))))))

Also perhaps:

=IFERROR(LOOKUP(2,1/(AK5:AP5<>FALSE),AK5:AP5),"Not Listed")