CODEWITHSUNDEEP
excel-formula
K. Fowler
K. Fowler

Reputation: 11

Mode formula not working

I'm struggling with MODE I have some surveys I am analysing.

Currently using =MODE(IF(AJ15:AJ24<>0,AJ15:AJ24))
One Question's answers are: 

0
0
0
0
0
0
0
1
2
3

the formula is giving #VALUE error as there are no repeated numbers. Can anyone suggest how to get round this so it doesn't show an error.

Upvotes: 1

Views: 50

Answers (1)

Forward Ed
Forward Ed

Reputation: 9874

=iferror(MODE(IF(AJ15:AJ24<>0,AJ15:AJ24)),"")

If your formula does not result in an error then the result of your formula is displayed. When your formula generates an error, "" or nothing is displayed.

Upvotes: 1

Related Questions