I have about 15,000 products listed by month. I need to find what was the
top selling product for Jan, Feb, Mar and April. The months are across the
top in columns and the product number is in the rows with the applicable
dollars. I now know I can use Data-Filer to see the top one item, for that
month. However, I need to know with one selection, what are the top items
for all months that I am using.

Thanks,

Gene

=MAX(B2:B1500) for March etc.

copy across for other months

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gene" wrote in message
...
I have about 15,000 products listed by month. I need to find what was the
top selling product for Jan, Feb, Mar and April. The months are across
the
top in columns and the product number is in the rows with the applicable
dollars. I now know I can use Data-Filer to see the top one item, for
that
month. However, I need to know with one selection, what are the top items
for all months that I am using.

Thanks,

Gene