Histogram (Analysis Toolpak) - can I make it ignore non-numerical or logical values?

Hi,

basically, the title says all

I have some data, that, in-between, has some non-numeric (logical) data: FALSE;


I.e. the data is like


10
20
10
30
10
FALSE
10
20
30



etc etc.


When I use the histogram maker in the Data Analysis Toolpak and select as "input range" the data above, it says that "the data contains non-numeric data."

Is it possible to somehow do this directly, ignoring the non-numeric AND/OR logical data? or will I have to use another column, and copy the values over, leaving out the logical values with some IF clause.

Thanks!!

If I HAVE to () I would also probably be open to using VBA, but, if I can, I would like to stay in "native" excel

Yep, I did something like that. Thanks again, Shorty!