Mode IF for text data

[silkpantsman]

Hi All,

I am trying to use a mode if for text data. It is a variation of this array formula i am looking for {=mode(if(Table1[x] = C2, Table1[y]))} but having problems. Any help would be much appreciated. Thanks

 

[Rick Rothstein]

Hi All,

I am trying to use a mode if for text data. It is a variation of this array formula i am looking for {=mode(if(Table1[x] = C2, Table1[y]))} but having problems. Any help would be much appreciated. Thanks

The MODE function only works on numbers as far as I am aware.

 

[Domenic]

Try...

=INDEX(Table1[Y],MODE(IF(Table1[X]=C2,IF(LEN(Table1[Y])>0,MATCH(Table1[Y],Table1[Y],0)))))

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

 

[silkpantsman]

Try...

=INDEX(Table1[Y],MODE(IF(Table1[X]=C2,IF(LEN(Table1[Y])>0,MATCH(Table1[Y],Table1[Y],0)))))

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

Thanks this work perfectly.