Show unique string from one column only if related unique sum from another column is > 0

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Administrative Note:

Is your forum profile showing the Excel PRODUCT that you need this to work for?

Members will tailor the solutions they offer to the Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your product is for Mac, please also state this.

The three most recent Excel products are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the version number in your profile (e.g. MS365 Version 2306). This is in the About Excel section further down the Account page.

Thanks.

You are not understanding the second parameter of the unique function.

Try this:

=LET(u,UNIQUE(A1:A11),FILTER(u,SUMIF(A1:A11,u,B1:B11)>0))

or this:

=LET(u,UNIQUE(A1:A11),s,SUMIF(A1:A11,u,B1:B11),FILTER(HSTACK(u,s),s<>0))

where column A contains the stock names and column B the transactions.

You will need to adapt this to your own workbook. If it doesn't work, then attach a sample book.

If you want to return the amounts and not the stock names, then