Hi
I have an array formula to search using two criteria and returning the resulting list of company names. my problem is is that is bringing back duplicate values where i only want a unique list. the search criteria change as the search fields are drop down lists. The formula i have is :
=INDEX(CustName, SMALL(IF(ISERROR(SEARCH($A$4,TerritoryMain)*SEARCH($B$4,TerrMgrMain)), "", ROW(TerritoryMain)-MIN(ROW(TerritoryMain))+1), ROW('Quote Data'!A1)), COLUMN('Quote Data'!A1))
I was thinking i needed to insert a Countif function sumwhere, but im not sure.
Any help would be greatfully received.
Thanks
Bookmarks