<div>
As per Excel Help on the MODE() function. &nbsp;MODE returns #N/A if no duplicates are found.<br />
<br />
If you want to return a blank instead of the error, then try:<br />
<br />
=IFERROR(MODE(D3:D9),&quot;&quot;)
</div>


As per Excel Help on the MODE() function.  MODE returns #N/A if no duplicates are found.

If you want to return a blank instead of the error, then try:

=IFERROR(MODE(D3:D9),"")

<div>
V,<br />
OP has 2003, so you'd need ISERROR or ISNA.
</div>


V,
OP has 2003, so you'd need ISERROR or ISNA.

<div>
Thanks R,<br />
<br />
then it would be:<br />
<br />
=IF(ISNA(MODE(D3:D9)),&quot;&quot;,M<wbr />ODE(D3:D9)<wbr />)
</div>


Thanks R,

then it would be:

=IF(ISNA(MODE(D3:D9)),"",MODE(D3:D9))

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have a user with an Excel spreadsheet who wants to use the mode function but it returns #N/A. I have tried it and I get #N/A, I am not sure if it he can use mode in this way? &nbsp;He also claims that he knows someone that says it works in Excel 2010 but I don't have it to test.<br />
<br />
Here is what he is trying to do.<br />
<br />
=MODE(D3:D9)<br />
<br />
DR %<br />
<br />
50.22<br />
67.49<br />
52.30<br />
27.33<br />
25.15<br />
39.45<br />
0.00<br />
<br />
#N/A<br />
<br />
Any help would be appreciated<br />
<br />
Thanks
</div>
</div>


Hi,

I have a user with an Excel spreadsheet who wants to use the mode function but it returns #N/A. I have tried it and I get #N/A, I am not sure if it he can use mode in this way?  He also claims that he knows someone that says it works in Excel 2010 but I don't have it to test.

Here is what he is trying to do.

=MODE(D3:D9)

DR %

50.22
67.49
52.30
27.33
25.15
39.45
0.00

#N/A

Any help would be appreciated

Thanks

Excel 2003 MODE function returns #N/A

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.