AHeganCopper ContributorSep 22, 2024Formula 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(...Show More
Harun24HRSilver ContributorSep 22, 2024AHegan Use a TOROW() function before lookup_value. =@INDEX(K5:AF5,MODE(MATCH(TOROW(K5:AF5,1),K5:AF5,0))) Alternatively you can use XLOOKUP() like. =LET(x,K5:AF5,y,COUNTIFS(x,x),XLOOKUP(MAX(y),y,x))
