I suggest posting your worksheet layout and a small subset of the
data. How is market share calculated from the data? How is "trading
area" indicated by the data?

Hth,
Merjet