Prev Previous Post   Next Post Next
  #1   Report Post  
David French
 
Posts: n/a
Default Top 25

I have a user that has a LARGE amount of raw data.
What I see as a roundabout way of getting the top 25 was:
Apply subtotals
Viewed subtotals (level 2)
Copied Visible cells to another sheet

Doing this cuts the ties to the address information in the original sheet.
How can this be done against the original information?

Dave French


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"