Help required to solve a pain of an issue (and save what little hair I have
left)

I have a very large worksheet containing monthly sales data for 600+
products sorted by product group. I want to create a series of "top 10's"
for the data.

The data is set out a bit like this:

Item code Name Price Unit Sales(1 column per month)

There are columns in between some of these but they aren't really relevant
to what I want to achieve.

I need to create a conditional formula that will examine the sales figures
by month and product group and pull out the highest sellers for each
group/month (complete with all the indentifying data). I also need to look
at sales figures over the entire range and pull out overall top sellers.

All the functions I have looked at will give me the overall position of a
sales figure but won't tie it to the name or item code and they will not
break the data down by group.

Any suggestions gratefully received......the boss is starting to get
impatient!!!!

---

Dave