Result set from SUMPRODUCT function

B

Bruce

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?
 
B

Bob Phillips

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)
 
B

Bruce

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.
 
B

Bob Phillips

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)
 
P

Peo Sjoblom

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
 
B

Bruce

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