R
Rich Mogy
I have a table with Department, Practice and various amounts
For each department, practice combination I want to count the number of
amounts between 500-1000, 1001-1500, 1501-2000, etc.
I tried FREQUENCY, but found it fine when all I had to do was count for one
departments, but now that I need department/practice combinations, it seems
to be too cumbersome.
Thanks in advance.
Sample of data where column 1 is department, column 3 is practice and column
2 is amount
01
$3,000.00
17
01
$818.90
17
01
$1,098.20
17
01
$500.00
999
01
$500.00
999
01
$500.00
999
01
$540.00
999
01
$593.80
999
01
$628.52
999
01
$797.34
999
01
$797.34
999
01
$797.34
999
01
$1,157.35
999
01
$750.00
999
01
$1,343.25
999
01
$1,000.00
999
01
$3,355.80
999
01
$616.50
999
02
$540.00
4
02
$516.95
4
02
$538.89
4
02
$1,240.32
5
For each department, practice combination I want to count the number of
amounts between 500-1000, 1001-1500, 1501-2000, etc.
I tried FREQUENCY, but found it fine when all I had to do was count for one
departments, but now that I need department/practice combinations, it seems
to be too cumbersome.
Thanks in advance.
Sample of data where column 1 is department, column 3 is practice and column
2 is amount
01
$3,000.00
17
01
$818.90
17
01
$1,098.20
17
01
$500.00
999
01
$500.00
999
01
$500.00
999
01
$540.00
999
01
$593.80
999
01
$628.52
999
01
$797.34
999
01
$797.34
999
01
$797.34
999
01
$1,157.35
999
01
$750.00
999
01
$1,343.25
999
01
$1,000.00
999
01
$3,355.80
999
01
$616.50
999
02
$540.00
4
02
$516.95
4
02
$538.89
4
02
$1,240.32
5