Exclude Blank Cells from Mode Array

Hello, I need to edit the following function to exclude blank values:

=MODE(IF(ISNA(MATCH(C10:C259,C3:C3,0)),C10:C259))

array formula

=MODE(IF($C$10:$C$259<>0,$C$10:$C$259))

I tried adding that, but get a REF error... I'm trying to get the 2nd most frequent value, excluding blanks...

=MODE(IF(C10:C259<>0,C10:C259(ISNA(MATCH(C10:C259,C3:C3,0)),C10:C259,"")))

Originally Posted by dosydos

array formula

=MODE(IF($C$10:$C$259<>0,$C$10:$C$259))

I tried adding that, but get a REF error... I'm trying to get the 2nd most frequent value, excluding blanks...

=MODE(IF(C10:C259<>0,C10:C259(ISNA(MATCH(C10:C259,C3:C3,0)),C10:C259,"")))

Originally Posted by MSWAL

I tried adding that, but get a REF error... I'm trying to get the 2nd most frequent value, excluding blanks...

=MODE(IF(C10:C259<>0,C10:C259(ISNA(MATCH(C10:C259,C3:C3,0)),C10:C259,"")))

I just figured it out. Here's my code:

=MODE(IF(C10:C259<>"",IF(ISNA(MATCH(C10:C259,C3:C3,0)),C10:C259,"")))

Thanks for the help!