Spreadsheet: 859527d1707903029-formula-help-for-isolating-two-columns-based-on-no-match-test-excel-aligw
Sheet: DATA ENTRY 

NO HISTORY MATCH FORMULA | Custom SIM List | [NAME] | Pulled Sales History SIM List | SIM Description | Sell Contract | SPA Cost | SPA Name | 2610 Standard Cost | 2610 WTT Cost | [NAME] | Loaded Margin | [NAME] Months | QTY Sold - Revenue | [NAME] Cost | [NAME] |  | AliGW |  | [NAME]
 | [PHONE] | g | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v |  |  | f |  | f
 | [PHONE] | g | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v |  | [PHONE] | g | [PHONE] | g
 | [PHONE] | g | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
 | [PHONE] | g | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
 | [PHONE] | g | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
 | [PHONE] | g | 78621054506 | a | f | f | s | x | s | s | s | g | h | v | v
 | [PHONE] | g | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
 | [PHONE] | f | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
 | [PHONE] | g | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
 |  |  | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
 |  |  | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
 |  |  | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
 |  |  | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
 |  |  | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
 |  |  | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
 |  |  | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
 |  |  | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
 |  |  | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
 |  |  | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
 |  |  | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
 |  |  | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
 |  |  | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
 |  |  | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
 |  |  | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
 |  |  | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
 |  |  | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
 |  |  | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
 |  |  | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
 |  |  | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
 |  |  | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
 |  |  | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
 |  |  | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
 |  |  | [PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
 |  |  | 78621054112 | a | f | f | s | x | s | s | s | g | h | v | v
 |  |  | 78621005266 | a | f | f | s | x | s | s | s | g | h | v | v
 |  |  | 78621005262 | a | f | f | s | x | s | s | s | g | h | v | v
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0