? Produce the =T value of the SUMPRODUCT dataset

[purdiet]

I have a list of web sites and data columns about them that I need t
analyize.

I successfully used the following function to provide a count of ho
many records out of my 2000+ set met a specific set of criteria (e.g.
how many were unique $D, of interest $E, and what category they wer
$K:

=SUMPRODUCT(($D$3:$D$2004="Y")*($E$3:$E$2004="I")*($K$3:$K$2004=2))

Now that I have the count (8) I need help in producing the value hel
in $G$3:$g$2000 so that the function produces the specific names of th
8 sites that meet this criteria.

I KNOW THE =T($G$3) FUNCTION PRODUCES THE WEB SITE NAME AS A FUNCTIO
BUT I DON'T KNOW HOW TO USE IT TO LIST ONLY THE ONES THAT WERE FROM TH
SUMPRODUCT RESULT SET..

Any help is appreciated

 

[Biff]

Hi!

I'm afraid it's a little more complicated than that!

The T() function returns the value of the argument if it
is a text value otherwise it returns a null string.

Try this formula entered as an array - CTRL,SHIFT,ENTER:

=INDEX($G$3:$G$2004,SMALL(IF($D$3:$D$2004="Y",IF
($E$3:$E$2004="I",IF($K$3:$K$2004=2,ROW(A$1:A$2002)))),ROW
(1:1)))

Copy down until you get #NUM! errors.

Biff