As the title says, can the list of uniques extracted based on 2 criteria be sorted A to Z as well within the formula?
Currently I use this formula:
=IFERROR(INDEX('Data'!$A$2:$A$350,AGGREGATE(15,6,ROW(' Data'!$A$2:$A$350)/('Data'!$D$2:$D$350=A$1)/('Data'!$H$2:$H$350="Buy"),ROW(1:1))),"")
Bookmarks