using mode.sngl there are some cells contains N/A values, it is wrong or correct used formula =mode.sngl(if(a:a=j1,b:b))