Hi,
I have data arranged as shown in columns A and B in the attached file.
I would like to create a formula in D2, which will be copied down the column, that will report the product names shown in column A, if they are listed as Grade1 in column B, in alphabetical order.
Can someone please suggest a formula that will accomplish this? (I would prefer to use a formula rather than a pivot table or filtering).
Thanks
Bookmarks