Excel

FILTER An xlookup will produce a single result based on a criteria. A Filter can do the same but produce multiple results. Below I produce all results for vendor code "coosto" Then, I used the sort function to order it from smallest to largest.

SORT  &  UNIQUE Usually, I am use to using a pivot table to remove duplicates or use the remove duplicate option.  An alternative way and more simple way is to use the super helpful function UNIQUE() function & add on the SORT() function to have it in alphabetical order.