Improvement functions

[bines]

Hello,

I have Three old functions, can with Excel 2010, build more convenience functions and speed
Or with Morefunc .

1) MAX(MMULT(ISNUMBER(MATCH($A$411:$F$464,A4:F4,0))+0,TRANSPOSE(COLUMN(A4:F4)^0)))

2) -1+SUM(--(MMULT(--($K$14:$N$40=$K14:$N14),--(TRANSPOSE(COLUMN($K14:$N14))>0))>=$Q$15))

3) MAX(FREQUENCY(IF(A513:P513=3,COLUMN(A513:P513)),IF(A513:P513<>3,COLUMN(A513:P513))))

array functions .

Thanks,