View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] jedale@gmail.com is offline
external usenet poster
 
Posts: 16
Default 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