Products

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nearest Month 5
Specify a column by the month to calculate it's data 5
days calculation between dates 10
adding more data to pivot table. 3
find a value in a table based on 2 different criteria 17
use month in cell date to sum all relevant cells 2
Excel Help with dates 2
Calculated Fields and Pivot Tables 1

Back
Top