Need to calc diversity of products

[kovercash]

I want to calculate the diversity of product sales. See attached file that contains two fictious lists of 21 products and the dollars sold of each (followed by total sales). In one list, only one product out of 21 had any sales (in this case $1,000). This list represents zero diversity of product sales. The opposite is true in the second list where all product sales were exactly the same - 100% product diversity has been reached. Can one or more formulas be applied that returns a value that represents the diversity of any combination of products and product sales amounts?

[ravishankar]

Hi
the formula depends on the criteria you set for diversification. Some of my thoughts are put in the attahced excel file
Ravi