Hi, I am completely stuck and could really use your help.

Here is some sample data to use as a reference:

A | B | C
1 ITEM | QTY | LOCATION
2 Item 1 | -1 | Location 1
3 Item 2 | 1 | Location 2
4 Item 3 | -1 | Location 3
5 Item 4 | 1 | Location 3
6 Item 5 | -1 | Location 3
7 Item 6 | 1 | Location 3
8 Item 7 | -1 | Location 3
9 Item 8 | 1 | Location 4
10 Item 9 | -1 | Location 2
11 Item 10 | 1 | Location 3

What I need help with, I need range D2:D6, to show a list of all unique location(s) that have a negative QTY, or show blank. In the example above, the list would show:

D
1 LOCATIONS
2 Location 1
3 Location 3
4 Location 2
5 <blank>
6 <blank>


Note: Alphabetical would be preferred, but not required

What is a formula I could use for D2:D6?

Thanks in advance!!