Forum Discussion

Copper Contributor

Sep 22, 2024

Formula not working

I have this formula for excel that gives me the most common value in a range. The problem I have is that if a cell in the range is blank it becomes NA. This is the formula =@INDEX(K5:AF5,MODE(MATCH(...

excel

Formulas and Functions

Detlef_Lewin

Silver Contributor

Sep 22, 2024

AHegan

Another option.

=LET(
a,FILTER(K5:AF5,ISTEXT(K5:AF5)),
b,INDEX(a,MODE.MULT(XMATCH(a,a))),
b)