Forum Discussion
Help with Excel formula please
Hi all, I have a dataset that looks like the following and I'm trying to eliminate the blanks and consolidate the staff name into Column PM1 and PM2. For PM 1 I use this formula: =IF(A2<>""...
As variant for
PM1
=INDEX($A$1:$D$1,LARGE(($A2:$D2="Y")*COLUMN($A$2:$D$2),IF(COUNTIFS($A2:$D2,"Y")>1,2,1)))PM2
=IF(COUNTIFS($A2:$D2,"Y")=1,"", INDEX($A$1:$D$1,LARGE(($A2:$D2="Y")*COLUMN($A$2:$D$2),1)))
