duplicate an array and filter the list based on a grouping
Here is my unque item array function:
{=IF(ROWS($1:3)<=SUMPRODUCT((Listing!$H$4:$H$1261< "")/COUNTIF(Listing!
$H$4:$H$1261,Listing!$H$4:$H$1261&"")),INDEX(Listi ng!$H$4:$H
$1261,SMALL(IF(Listing!$H$4:$H$1261<"",IF(MATCH(L isting!$H$4:$H
$1261,Listing!$H$4:$H$1261,0)=ROW(Listing!$H$4:$H$ 1261)-ROW(Listing!$H
$4)+1,ROW(Listing!$H$4:$H$1261)-ROW(Listing!$H
$4)+1)),ROWS($1:3))),"")}
I was hoping that I could modify this function to then list the groups
of different items within an array. However, I am not familar with
all the different functions and trying to breakup the function into
parts is not working for me.
Thanks,
Jeff
|