Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to apply frequency?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to apply frequency?
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. -- Biff Microsoft Excel MVP "Eric" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Frequency | Excel Discussion (Misc queries) | |||
Frequency ( ) | New Users to Excel | |||
Frequency | Excel Discussion (Misc queries) | |||
frequency | Excel Discussion (Misc queries) | |||
histograms - frequency and relative frequency? | Excel Discussion (Misc queries) |