Function - Frequency

[James8309]

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

 

[D8.Consultor]

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

What Excel version are you using?

 

[James8309]

What Excel version are you using?- Hide quoted text -

- Show quoted text -

I am using excel 2007