Spreadsheet: 710243d1608807079-count-or-extract-the-unique-columns-counting-unique-with-two-criteria-in-two-columns-3
Sheet: Sheet1

Column A | Column B | Column C | Column D | Column E | Column F | Column G | Column H | Column I | Column J | Column K | Column L | Column M | Column N | Column O | Column P | Column Q | Column R | Column S
528-1924 |  | 936BAD6B1A58 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 259-5497 | 139A3BDBA817 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 683-9053 | D771BD7BB583 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
804-7450 |  | 3A596A513169 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |  | Count |  | If the Column B cells is blank and the Column C cells is [NAME] then Count. Also blank Column C cells should be Blank.
 | 889-3854 | 88BDB89818BA | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 827-3241 | 56BD9867A9A5 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 773-9822 | 73173933161D | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |  | Extract |  |  | If the Column B cells is blank and the Column C cells is [NAME] then Count. Also blank Column C cells should be Blank.
 | 633-2430 | 11356B979661 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 529-2697 | 1D7718198781 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 765-2413 | 5897ABB85DDA | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 442-1886 | 6D5D9197DD71 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 196-7639 | 15A73893BBD7 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
164-4129 |  | 3A596A513169 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 508-9057 | 1DD7BD1BA77A | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 186-6475 | 311BA566886B | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 506-6175 | 65533975A398 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 629-4685 | 98836D1798AA | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 832-7019 | B16B91B57BA5 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 493-2386 | 5793A7AADDAA | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 472-4895 | 1AA3311637B6 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 256-7659 | D583533711D1 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 658-4011 | 9A65557AD8B3 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
294-6647 |  | 39818511D6A8 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 569-3558 | B8D1AA7AA591 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 907-5790 | 8B8D5553A819 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 779-9161 | D1BD535A9B1D | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 637-5305 | 15763A6A7513 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 928-7111 | 311863A55859 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 981-7901 | 8379B168B7B5 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
670-6277 |  | [NAME] | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 450-9580 | 6733D58955AD | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 757-4699 | 663B875979AD | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 679-1448 | 97919BB873AD | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 436-5040 | D8A5A95B7663 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 662-4588 | 1BA79B89D6D3 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
662-4588 |  | [NAME] | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 637-5305 | 15763A6A7513 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 928-7111 | 311863A55859 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
450-9580 |  | [NAME] | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 679-1448 | 97919BB873AD | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | 436-5040 | D8A5A95B7663 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X