Hi everyone,

I am experiencing a problem with my frequency formulae. if anyone
could help that would be great!


Basically, in sheet1 I have this massive data file (row up to
380,000). column B:B has 12 different types, let's just say Type A to
Type L.


When I apply a autofilter on the first row to look at Type A only
because I am only interested in Type A.


And when I try to do a frequency on sheet2 on that Type A auto-
filtered data.
i.e. ' = frequency(DATA, Sheet2!A2:A10)'
instead of performing this formulae on what's filtered, it does for
the whole 380,000 rows.


How do I make it perform frequency function on what's filtered only?


thank you in advance


regards,


James