Try this:
F2: =SUBSTITUTE(TRIM(IF(A2=E2,A$1&" ","")&IF(B2=E2,B$1&" ","")&IF(C2=E2,C$1&" ","")&IF(D2=E2,D$1,""))," ",", ")
Try this:
F2: =SUBSTITUTE(TRIM(IF(A2=E2,A$1&" ","")&IF(B2=E2,B$1&" ","")&IF(C2=E2,C$1&" ","")&IF(D2=E2,D$1,""))," ",", ")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks