Smurfit-Stone
Active Member
- Joined
- Dec 1, 2004
- Messages
- 485
Hello Board,
I have a file that each month sales data is entered, there is a summary sheet in the same file that I display the top 20 customers, as well as another that list the top 10 based on sales $. Of course this top 20 list changes every month. What I was wondering is....is there a way or formula that would look at the hundreds of rows of data on the sales sheet and place only the top 20 on the summary sheet. I've tried the auto filter, but I have lots of columns of data on the sales sheet, and I only want certain columns to appear on the summary sheet. My thinking may be off, but I thought excel might be able to do this automatically. Thanks in advance
I have a file that each month sales data is entered, there is a summary sheet in the same file that I display the top 20 customers, as well as another that list the top 10 based on sales $. Of course this top 20 list changes every month. What I was wondering is....is there a way or formula that would look at the hundreds of rows of data on the sales sheet and place only the top 20 on the summary sheet. I've tried the auto filter, but I have lots of columns of data on the sales sheet, and I only want certain columns to appear on the summary sheet. My thinking may be off, but I thought excel might be able to do this automatically. Thanks in advance