Surely, if these are prices, then revenues will depend on how many of
each product are sold - where is this information? Do you envisage
another range of up to 6 columns which would contain projected number
of sales? And does that mean you want the minimum and the maximum of
price times number, i.e. two columns showing the range of revenues for
each product?

Do you know how many possible combinations you could get from 100
products, each of which could have up to 6 values?

Pete