Sheet1
<tbody>
</tbody>
Column A B E is user input
Column C remove duplicated and list single Name List
How the code to list out for Column F G H
Thanks
Excel tables to the web >> Excel Jeanie HTML 4
* | A | B | C | D | E | F | G | H |
1 | Name List | Shop | List | * | Except shop | Shop | Name List | Qty |
2 | Banana | Smith | Banana | * | John | Smith | Banana | 3 |
3 | Apple | John | Apple | * | Alex | Smith | Apple | 1 |
4 | Banana | Ellen | Berry | * | * | Ellen | Banana | 2 |
5 | Apple | Smith | Cerry | * | * | Ellen | Apple | 1 |
6 | Banana | Smith | * | * | * | Ellen | Berry | 2 |
7 | Apple | John | * | * | * | Koko | Cerry | 1 |
8 | Banana | Ellen | * | * | * | * | * | * |
9 | Banana | Smith | * | * | * | * | * | * |
10 | Berry | Alex | * | * | * | * | * | * |
11 | Apple | John | * | * | * | * | * | * |
12 | Berry | Alex | * | * | * | * | * | * |
13 | Apple | Ellen | * | * | * | * | * | * |
14 | Apple | Alex | * | * | * | * | * | * |
15 | Berry | Ellen | * | * | * | * | * | * |
16 | Berry | Ellen | * | * | * | * | * | * |
17 | Cerry | Koko | * | * | * | * | * | * |
<tbody>
</tbody>
Column A B E is user input
Column C remove duplicated and list single Name List
Code:
{=IFERROR(INDEX($A:$A,SMALL(IF(FREQUENCY(IF($A$2:$A$114<>"",MATCH($A$2:$A$114,$A$2:$A$114,0)),ROW($A$2:$A$114)-ROW($A$2)+1)>=1,ROW($A$2:$A$114)),ROWS(B$2:B2))),"")}
How the code to list out for Column F G H
Thanks
Excel tables to the web >> Excel Jeanie HTML 4