Spreadsheet: 768347d1644933807-formula-to-return-unique-values-for-duplicate-values-in-range-book2
Sheet: Sheet1

Source Data |  |  |  | Data List |  | desired result for NBR
[NAME] | [NAME] | [NAME] |  | LIST | NBR
1 | Apples | This text is here in order to have the formula in the NBR column to do a wildcard search for 'PO10001' in this column. |  | Orange; PO10003
2 | [NAME] | This text is here just for filler. |  | Grape; PO10004
3 | Grape | This text is here in order to have the formula in the NBR column to do a wildcard search for 'PO10004' in the LOG_NOTE column. |  | Orange; PO10006
4 | Apples | This text is here in order to have the formula in the NBR column to do a wildcard search for 'PO10005' in the LOG_NOTE column.
5 | [NAME] | This text is here in order to have the formula in the NBR column to do a wildcard search for 'PO10011' in the LOG_NOTE column. |  | Orange; PO10006
6 | Orange | This text is here in order to have the formula in the NBR column to do a wildcard search for 'PO10006' in the LOG_NOTE column. |  | Orange; PO10006
7 | Apples | This text is here in order to have the formula in the NBR column to do a wildcard search for 'PO10007' in the LOG_NOTE column.
8 | Apples | This text is here in order to have the formula in the NBR column to do a wildcard search for 'PO10008' in the LOG_NOTE column. |  | Apples; PO10007
9 | Orange | This text is here in order to have the formula in the NBR column to do a wildcard search for 'PO10003' in the LOG_NOTE column. |  | [NAME]; PO10011
10 | Apples | This text is here in order to have the formula in the NBR column to do a wildcard search for 'PO10008' in the LOG_NOTE column. |  | [NAME]; PO10011
11 | [NAME] | This text is here in order to have the formula in the NBR column to do a wildcard search for 'PO10011' in the LOG_NOTE column.
12 | [NAME] | This text is here just for filler.
13 | Grape | This text is here in order to have the formula in the NBR column to do a wildcard search for 'PO10010' in the LOG_NOTE column.
14 | Apples | This text is here in order to have the formula in the NBR column to do a wildcard search for 'PO10012' in the LOG_NOTE column.
15 | Apples | This text is here just for filler.
16 | Orange | This text is here in order to have the formula in the NBR column to do a wildcard search for 'PO10013' in the LOG_NOTE column.
17 | Orange | This text is here in order to have the formula in the NBR column to do a wildcard search for 'PO10006' in the LOG_NOTE column.
18 | Grape | This text is here in order to have the formula in the NBR column to do a wildcard search for 'PO10014' in the LOG_NOTE column.
19 | Apples | This text is here just for filler.
20 | Apples | This text is here in order to have the formula in the NBR column to do a wildcard search for 'PO10016' in the LOG_NOTE column.
21 | Orange | This text is here in order to have the formula in the NBR column to do a wildcard search for 'PO10017' in the LOG_NOTE column.
22 | Orange | This text is here in order to have the formula in the NBR column to do a wildcard search for 'PO10006' in the LOG_NOTE column.
23 | Grape | This text is here in order to have the formula in the NBR column to do a wildcard search for 'PO10018' in the LOG_NOTE column.