Result set from SUMPRODUCT function

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

Guest

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.

--
---
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
I'll have a rainbow.

This does work well if I want it for only one or two though.
 
Then you are out of luck. You would have to create such a facility yourself,
and it would be anything but trivial.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
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


--


Regards,


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.
 
Back
Top