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

Result set from SUMPRODUCT function
 

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)



"Bruce" wrote in message
...
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?

Result set from SUMPRODUCT function
 

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.

"Bob Phillips" wrote:

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)



"Bruce" wrote in message
...
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?

Result set from SUMPRODUCT function
 

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)



"Bruce" wrote in message
...
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.

"Bob Phillips" wrote:

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)



"Bruce" wrote in message
...
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?

Result set from SUMPRODUCT function
 

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


"Bruce" wrote in message
...
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.

"Bob Phillips" wrote:

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)



"Bruce" wrote in message
...
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?

Result set from SUMPRODUCT function
 

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.

"Peo Sjoblom" wrote:

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


"Bruce" wrote in message
...
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.

"Bob Phillips" wrote:

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)



"Bruce" wrote in message
...
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?

Result set from SUMPRODUCT function
 

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

--


Regards,


Peo Sjoblom



"Bruce" wrote in message
...
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.

"Peo Sjoblom" wrote:

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


"Bruce" wrote in message
...
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.

"Bob Phillips" wrote:

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)



"Bruce" wrote in message
...
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?