Dear Friends,
PFA
Is there any formula which can produce the output mentioned in col J, K, L?
There are approx. 35 columns and 100 rows. The issue is sequence of columns keep changing. But output will remain the same.
Please assist.
Dear Friends,
PFA
Is there any formula which can produce the output mentioned in col J, K, L?
There are approx. 35 columns and 100 rows. The issue is sequence of columns keep changing. But output will remain the same.
Please assist.
J3 =IFERROR(INDEX($B$3:$F$3,MATCH(0,COUNTIF($I3:I3,$B$3:$F$3),0)),"") Ctrl Shift Enter
Drag to the right
J4=SUMPRODUCT(($B$4:$F$7)*($A$4:$A$7=$I4)*($B$3:$F$3=J$3))
Drag to the right and down
See attachment.
Wow.... thanks a lot.
You made my day.
God bless you.
You're welcome. Happy to help.
Thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks