 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / May 2008Compressing sparse data
I have a bunch of rows that yield results in the last column that in many cases are blank or zero. I would like to be able to view the results of only those cells that are non-blank, and show them on another worksheet page. Copying the whole column would of course keep the data spread out over lots of rown. Is there a way to somehow remove the blanks? I've tried thinking about a VLOOKUP for non-blank data, but that still is row by row. Thanks for any help. - Pete data>filter>autofilter>>>  SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com >I have a bunch of rows that yield results in the last column that in > many cases are blank or zero. I would like to be able to view the [quoted text clipped - 7 lines] > > - Pete Thanks. The problems with AutoFilter is it ends up sorting the whole page. I would like to be able to group the results in a single column on any page, without it affecting the other columns of that page. I'm thinking that I may need to operate on this as an array somehow, does that make sense? - Pete > data>filter>autofilter>>> > [quoted text clipped - 19 lines] > > - Show quoted text - You did say copy to another. Just copy the visible cells. and show them on > > another worksheet page. Copying the whole column would of course SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com Thanks. The problems with AutoFilter is it ends up sorting the whole page. I would like to be able to group the results in a single column on any page, without it affecting the other columns of that page. I'm thinking that I may need to operate on this as an array somehow, does that make sense? - Pete On May 1, 9:42 am, "Don Guillett" <dguille...@austin.rr.com> wrote: > data>filter>autofilter>>> > [quoted text clipped - 19 lines] > > - Show quoted text - >Thanks. The problems with AutoFilter is it ends up sorting the whole >page. I would like to be able to group the results in a single column >on any page, without it affecting the other columns of that page. I'm >thinking that I may need to operate on this as an array somehow, does >that make sense? Have you looked at "Lists" I have just read that and it may do what you want. I have not used the feature yet http://office.microsoft.com/training/training.aspx?AssetID=RC010801391033 >- Pete > [quoted text clipped - 21 lines] >> >> - Show quoted text - SignatureDave Mills There are 10 type of people, those that understand binary and those that don't. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.