 |
 | 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 / Worksheet Functions / October 2007Result set from SUMPRODUCT function
I want to view the set of records that were counted by the SUMPRODUCT function. =SUMPRODUCT((ReturnToAsset="")*(((DaysAfterExpy<30)*(CEAName<>"")))) The answer was 14. How am I able to see which 14? conditionally format them using the same condition tests.  Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) >I want to view the set of records that were counted by the SUMPRODUCT >function. > > =SUMPRODUCT((ReturnToAsset="")*(((DaysAfterExpy<30)*(CEAName<>"")))) > > The answer was 14. How am I able to see which 14? That'll work, but I was hoping for a drill-down or something. I've got several of these type functions. If I conditionally format them all, then I'll have a rainbow. This does work well if I want it for only one or two though. > conditionally format them using the same condition tests. > [quoted text clipped - 4 lines] > > > > The answer was 14. How am I able to see which 14? Then you are out of luck. You would have to create such a facility yourself, and it would be anything but trivial. Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > That'll work, but I was hoping for a drill-down or something. I've got > several of these type functions. If I conditionally format them all, then [quoted text clipped - 10 lines] >> > >> > The answer was 14. How am I able to see which 14? You could use an advanced filter with the same criteria and have the filter copy the filtered data to another sheet in one fell swoop SignatureRegards, Peo Sjoblom > That'll work, but I was hoping for a drill-down or something. I've got > several of these type functions. If I conditionally format them all, then [quoted text clipped - 10 lines] >> > >> > The answer was 14. How am I able to see which 14? That sounds great. I have done some of the advanced filter and copying. I'll check it out again. I may have forgotten what I know. Thank you. > You could use an advanced filter with the same criteria and have the filter > copy the filtered data to another sheet in one fell swoop [quoted text clipped - 13 lines] > >> > > >> > The answer was 14. How am I able to see which 14? If you start the advanced filter from the sheet where you want the data copied it will work http://www.contextures.com/xladvfilter01.html#ExtractWs SignatureRegards, Peo Sjoblom > That sounds great. I have done some of the advanced filter and copying. > I'll check it out again. I may have forgotten what I know. Thank you. [quoted text clipped - 18 lines] >> >> > >> >> > The answer was 14. How am I able to see which 14? |
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.