Q

#### QTE

Visible Filtered cells using the Frequency function. My code returns

the values for the whole list, instead of just the Filtered Visible

cells of the Frequency Results(Freq_Results).

Freq_Results=Named Range of All Unfiltered Frequency Results, then

filtered in_place

Frequencies=Named Range Number of Times

Bins=Named Range of Intervals

Range("Freq_Results").SpecialCells(xlVisible).Select

Range("Frequencies").Select

Selection.FormulaArray = ("=Frequency(Freq_Results,Bins)")

Excel Help: -

Frequency Function Overview:

Returns a frequency distribution as a vertical array. For a given set

of values and a given set of bins (or intervals), a frequency

distribution counts how many of the values occur in each interval.

Syntax:

FREQUENCY(data_array, bins_array)

Data_array is an array of or reference to a set of values for which you

want to count frequencies. If data_array contains no values, FREQUENCY

returns an array of zeros.

Bins_array is an array of or reference to intervals into which you want

to group the values in data_array. If bins_array contains no values,

FREQUENCY returns the number of elements in data_array.

Remarks

FREQUENCY is entered as an array formula after selecting a range of

adjacent cells into which you want the returned distribution to

appear.

The number of elements in the returned array is one more than the

number of elements in bins_array.

FREQUENCY ignores blank cells and text.

Formulas that return arrays must be entered as array formulas

Suggestions, Please.