All,
I have the following array formula and would like to add something so it only returns a unique value (no duplicates). I can create this array then use a COUNTIF array to relist, however the reference value i'm using to determine the number of cells to perform this action with only counts unique values so the resultant "reference" value is lower than the number of cells this forumla would need to run in to capture all values.
Array:
=IFERROR(IF(ROWS(C$20:C20)<='INFO Sheet'!E$9,INDEX('UNI Delivery Report 6-6'!B2:P10000,SMALL(IF('UNI Delivery Report 6-6'!B2:B10000=C$15,ROW('UNI Delivery Report 6-6'!B2:B10000)-ROW('UNI Delivery Report 6-6'!B2)+1,""),ROWS(C$20:C20)),15),""),"")
Problem:
INFO Sheet e9=2
Column 15 has my returned value, but contains duplicates and only the first 2 occurences that meet the critera are returned eliminating additional entries. The "INFO Sheet E9" cell counts the number of unique values so I need the list to also only contain unique values.
Any ideas??? Thanks in advance.
Bookmarks