How to apply frequency?

G

Guest

Does anyone have any suggestions on how to apply frequency function?

I get two tables and would like to find the frequency from two tables.
=Frequency(table 1 & table 2, table 1 & table 2)

Does anyone have any suggestions whether the function frequency can apply
from two different tables or not?
Thank in advance for any suggestions
Eric
 
T

T. Valko

You can do something like this:

=FREQUENCY((A1:A5,B1:B5),(E1:E3,F1:F3))

But you have to make sure the bins are in the proper sequence or you'll get
incorrect results.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top