Products

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" <[email protected]> wrote in message
news:[email protected]...
> 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