How to assign "" for any error on frequency analysis?

[Guest]

Does anyone have any suggestion on how to assign "" for any error on
frequency analysis? such as
{=frequency(A:A,B:B)}
in case any error within column A or B, then it will display error on
frequency analysis.
I try following statement to avoid error, but it does not work.
{=IF(ISERROR(frequency(A:A,B:B)),"",frequency(A:A,B:B))}
Does anyone have any suggestions?
Thank you in advance
Eric

 

[T. Valko]

If you have logical errors in your data_array you can account for them like
this:

rng1 = data_array
rng2 = bins_array

Array entered:

=FREQUENCY(IF(ISNUMBER(rng1),rng1),rng2)

Note that you can't use entire columns as range references.

If you have logical errors in both the data_array *and* the bins_array you
can't "trap" those errors because they are not really errors being generated
by FREQUENCY. The bins are still being calculated properly and any errors
are ignored but since the formula is entered as an array the error values
are appended to the end of the histogram.

You would need to use conditional formatting to "hide" them.

Biff

 

[T. Valko]

If you have logical errors in both the data_array *and* the bins_array you

can't "trap" those errors because they are not really errors being
generated by FREQUENCY. The bins are still being calculated properly and
any errors are ignored but since the formula is entered as an array the
error values are appended to the end of the histogram.

You would need to use conditional formatting to "hide" them.

*OR*

When you enter the formula, only enter it in an array of cells equal to the
size of the count of your bins_array +1.

Biff

 

[Guest]

Thank you very much for your suggestions
Eric

*OR*

When you enter the formula, only enter it in an array of cells equal to the
size of the count of your bins_array +1.

Biff

 

[T. Valko]

You're welcome!

Biff

Thank you very much for your suggestions
Eric