| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to assign "" for any error on frequency analysis?
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to assign "" for any error on frequency analysis?
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 "Eric" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to assign "" for any error on frequency analysis?
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 "T. Valko" wrote in message ... 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 "Eric" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to assign "" for any error on frequency analysis?
Thank you very much for your suggestions
Eric "T. Valko" wrote: 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 "T. Valko" wrote in message ... 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 "Eric" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to assign "" for any error on frequency analysis?
You're welcome!
Biff "Eric" wrote in message ... Thank you very much for your suggestions Eric "T. Valko" wrote: 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 "T. Valko" wrote in message ... 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 "Eric" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shortcut key for "Paste Options" and "Error Checking" buttons? | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| "assign macro" not an option from short menu | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| unable to load "Excel" analysis toolpak tried the tools and brows | Excel Discussion (Misc queries) | |||
Linear Mode
