Hi Mangesh,

thank you for the answer.
Tha frequency function "only" counts the data array and allow to test
several possible ditributions of this variable.
Given the example:

Data Bins
Array Var B Array Frequency
1 High 3 3
5 Medium 5 2
10 Medium 8 2
8 High 10 4
9 High
10 Medium
2 Low
3 High
5 Low
8 Low
9 Medium

The FREQUENCY function counts the number of items of the data array
into the bins array. I need something more...I would like to associate
every single item with the class, in order to make a cross analysis of
the Data array and Variable B, within a pivot table.

In the example the function I need should insert a column Class:

Data Bins
Array Class Var E Array Frequency
1 3 High 3 3
5 5 Medium 5 2
10 10 Medium 8 2
8 8 High 10 4
9 10 High
10 10 Medium
2 3 Low
3 3 High
5 5 Low
8 8 Low
9 10 Medium

And the pivot table would be as follows:

Count of
Data Array

Var E
Class High Medium Low Grand
Total
3 2 1 3
5 1 1 2
8 1 1 2
10 1 3 4
Grand
Total 4 4 3 11


Thank you.
Bye.

Massimo