Spreadsheet: 768332d1644929314-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 |  | 9
2 | [NAME] | This text is here just for filler. |  | Grape; PO10004 |  | 3
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 |  | 6
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. |  |  |  | blank
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 |  | 17
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 |  | 22
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. |  |  |  | blank
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 |  | 7
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 |  | 5
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
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. |  |  |  | blank
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.