Spreadsheet: 759150d1639366798-countif-range-match-x-help-with-countif-book1
Sheet: MatchHelp

N1 | N2 |  | [NAME] | Total
[NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CompanyAddressNation | UNITED STATES |  |  |  |  |  | CompanyAddressNation | UNITED STATES |  |  |  |  |  |  |  | CompanyAddressNation | UNITED STATES |  |  |  |  |  |  |  | CompanyAddressNation | UNITED STATES |  |  |  |  |  |  |  | CompanyAddressNation | UNITED STATES |  |  |  |  |  |  |  | CompanyAddressNation | UNITED STATES |  |  |  |  |  |  |  | CompanyAddressNation | UNITED STATES |  |  |  |  |  |  |  |  |  |  |  | CompanyAddressNation | UNITED STATES |  |  |  |  |  |  |  | CompanyAddressNation | UNITED STATES
[NAME] | Lewis |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Created | (All) |  |  |  |  |  | Created | (All) |  |  |  |  |  |  |  | Created | (All) |  |  |  |  |  |  |  | Created | (All) |  |  |  |  |  |  |  | Created | (All) |  |  |  |  |  |  |  | Created | (All) |  |  |  |  |  |  |  | Created | (All) |  |  |  |  |  |  |  |  |  |  |  | Created | (All) |  |  |  |  |  |  |  | Created | (All)
[NAME] | Leo |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DayOWeek | (All) |  | Today |  |  |  | DayOWeek | (All) |  |  |  |  |  |  |  | DayOWeek | (All) |  |  |  |  |  |  |  | DayOWeek | (All) |  |  |  |  |  |  |  | DayOWeek | (All) |  |  |  |  |  |  |  | DayOWeek | (All) |  |  |  |  |  |  |  | DayOWeek | (All) |  |  |  |  |  |  |  |  |  |  |  | DayOWeek | (All) |  |  |  |  |  |  |  | DayOWeek | (All)
[NAME] | [NAME]
[NAME] | Alfie |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Symbol | Status | TOSWLName | CreatedDate |  |  |  | Symbol | Status | TOSWLName | GrpBy1m | CreatedDate | MarkPercentChange | [NAME] of MarkPercentChange |  |  | Symbol | Status | TOSWLName | GrpBy1m | CreatedDate | MarkPercentChange | [NAME] of MarkPercentChange |  |  | Symbol | Status | TOSWLName | GrpBy1m | CreatedDate | MarkPercentChange | [NAME] of MarkPercentChange |  |  | Symbol | Status | TOSWLName | GrpBy1m | CreatedDate | MarkPercentChange | [NAME] of MarkPercentChange |  |  | Symbol | Status | TOSWLName | GrpBy1m | CreatedDate | MarkPercentChange | [NAME] of MarkPercentChange |  |  | Symbol | Status | TOSWLName | GrpBy1m | CreatedDate | MarkPercentChange | [NAME] of MarkPercentChange |  |  |  |  |  |  | Symbol | GrpBy1m | Status | TOSWLName | CreatedDate | MarkPercentChange | [NAME] of MarkPercentChange |  |  | CreatedDate | GrpBy1m | TOSWLName | Status | Symbol | MarkPercentChange | [NAME] of MarkPercentChange
Lewis | Rory |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CEI | Property Not Set | ESP_PM | 2021-11-22 00:00:00 |  |  |  | CEI | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.1405 | 0.1405 |  |  | CEI | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.1405 | 0.1405 |  |  | CEI | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.1405 | 0.1405 |  |  | CEI | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.1405 | 0.1405 |  |  | CEI | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.1405 | 0.1405 |  |  | CEI | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.1405 | 0.1405 |  |  |  |  |  |  | CEI | 08:52:00 | Property Not Set | ESP_PM | 2021-11-22 00:00:00 | 0.1405 | 0.1405 |  |  | 2021-11-22 00:00:00 | 08:52:00 | ESP_PM | Property Not Set | CEI | 0.1405 | 0.1405
Leo |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WISH | Property Not Set | ESP_PM | 2021-11-22 00:00:00 |  |  |  | WISH | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0212 | 0.0212 |  |  | WISH | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0212 | 0.0212 |  |  | WISH | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0212 | 0.0212 |  |  | WISH | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0212 | 0.0212 |  |  | WISH | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0212 | 0.0212 |  |  | WISH | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0212 | 0.0212 |  |  |  |  |  |  | WISH | 08:52:00 | Property Not Set | ESP_PM | 2021-11-22 00:00:00 | 0.0212 | 0.0212 |  |  | 2021-11-22 00:00:00 | 08:52:00 | ESP_PM | Property Not Set | WISH | 0.0212 | 0.0212
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PROG | Property Not Set | ESP_PM | 2021-11-22 00:00:00 |  |  |  | PROG | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.002 | 0.002 |  |  | PROG | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.002 | 0.002 |  |  | PROG | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.002 | 0.002 |  |  | PROG | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.002 | 0.002 |  |  | PROG | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.002 | 0.002 |  |  | PROG | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.002 | 0.002 |  |  |  |  |  |  | PROG | 08:52:00 | Property Not Set | ESP_PM | 2021-11-22 00:00:00 | 0.002 | 0.002 |  |  | 2021-11-22 00:00:00 | 08:52:00 | ESP_PM | Property Not Set | PROG | 0.002 | 0.002
Alfie |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XELA | Property Not Set | ESP_PM | 2021-11-22 00:00:00 |  |  |  | XELA | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0073 | 0.0073 |  |  | XELA | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0073 | 0.0073 |  |  | XELA | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0073 | 0.0073 |  |  | XELA | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0073 | 0.0073 |  |  | XELA | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0073 | 0.0073 |  |  | XELA | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0073 | 0.0073 |  |  |  |  |  |  | XELA | 08:52:00 | Property Not Set | ESP_PM | 2021-11-22 00:00:00 | 0.0073 | 0.0073 |  |  | 2021-11-22 00:00:00 | 08:52:00 | ESP_PM | Property Not Set | XELA | 0.0073 | 0.0073
Rory |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BBIG | Property Not Set | ESP_PM | 2021-11-22 00:00:00 |  |  |  | BBIG | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0518 | 0.0518 |  |  | BBIG | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0518 | 0.0518 |  |  | BBIG | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0518 | 0.0518 |  |  | BBIG | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0518 | 0.0518 |  |  | BBIG | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0518 | 0.0518 |  |  | BBIG | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0518 | 0.0518 |  |  |  |  |  |  | BBIG | 08:52:00 | Property Not Set | ESP_PM | 2021-11-22 00:00:00 | 0.0518 | 0.0518 |  |  | 2021-11-22 00:00:00 | 08:52:00 | ESP_PM | Property Not Set | BBIG | 0.0518 | 0.0518
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AWH | Property Not Set | ESP_PM | 2021-11-22 00:00:00 |  |  |  | FCEL | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0316 | 0.0316 |  |  | FCEL | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0316 | 0.0316 |  |  | FCEL | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0316 | 0.0316 |  |  | FCEL | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0316 | 0.0316 |  |  | FCEL | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0316 | 0.0316 |  |  | FCEL | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0316 | 0.0316 |  |  |  |  |  |  | FCEL | 08:52:00 | Property Not Set | ESP_PM | 2021-11-22 00:00:00 | 0.0316 | 0.0316 |  |  | 2021-11-22 00:00:00 | 08:52:00 | ESP_PM | Property Not Set | FCEL | 0.0316 | 0.0316
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DPW | Property Not Set | ESP_PM | 2021-11-22 00:00:00 |  |  |  | ISPC | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.8841 | 0.8841 |  |  | ISPC | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.8841 | 0.8841 |  |  | ISPC | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.8841 | 0.8841 |  |  | ISPC | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.8841 | 0.8841 |  |  | ISPC | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.8841 | 0.8841 |  |  | ISPC | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.8841 | 0.8841 |  |  |  |  |  |  | ISPC | 08:52:00 | Property Not Set | ESP_PM | 2021-11-22 00:00:00 | 0.8841 | 0.8841 |  |  | 2021-11-22 00:00:00 | 08:52:00 | ESP_PM | Property Not Set | ISPC | 0.8841 | 0.8841
Logan |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FCEL | Property Not Set | ESP_PM | 2021-11-22 00:00:00 |  |  |  | DCPH | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.06 | 0.06 |  |  | DCPH | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.06 | 0.06 |  |  | DCPH | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.06 | 0.06 |  |  | DCPH | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.06 | 0.06 |  |  | DCPH | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.06 | 0.06 |  |  | DCPH | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.06 | 0.06 |  |  |  |  |  |  | DCPH | 08:52:00 | Property Not Set | ESP_PM | 2021-11-22 00:00:00 | 0.06 | 0.06 |  |  | 2021-11-22 00:00:00 | 08:52:00 | ESP_PM | Property Not Set | DCPH | 0.06 | 0.06
Lucas |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ISPC | Property Not Set | ESP_PM | 2021-11-22 00:00:00 |  |  |  | OCGN | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0389 | 0.0389 |  |  | OCGN | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0389 | 0.0389 |  |  | OCGN | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0389 | 0.0389 |  |  | OCGN | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0389 | 0.0389 |  |  | OCGN | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0389 | 0.0389 |  |  | OCGN | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0389 | 0.0389 |  |  |  |  |  |  | OCGN | 08:52:00 | Property Not Set | ESP_PM | 2021-11-22 00:00:00 | 0.0389 | 0.0389 |  |  | 2021-11-22 00:00:00 | 08:52:00 | ESP_PM | Property Not Set | OCGN | 0.0389 | 0.0389
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DCPH | Property Not Set | ESP_PM | 2021-11-22 00:00:00 |  |  |  | ASTR | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.2823 | 0.2823 |  |  | ASTR | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.2823 | 0.2823 |  |  | ASTR | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.2823 | 0.2823 |  |  | ASTR | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.2823 | 0.2823 |  |  | ASTR | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.2823 | 0.2823 |  |  | ASTR | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.2823 | 0.2823 |  |  |  |  |  |  | ASTR | 08:52:00 | Property Not Set | ESP_PM | 2021-11-22 00:00:00 | 0.2823 | 0.2823 |  |  | 2021-11-22 00:00:00 | 08:52:00 | ESP_PM | Property Not Set | ASTR | 0.2823 | 0.2823
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OCGN | Property Not Set | ESP_PM | 2021-11-22 00:00:00 |  |  |  | RLX | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.06 | 0.06 |  |  | RLX | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.06 | 0.06 |  |  | RLX | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.06 | 0.06 |  |  | RLX | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.06 | 0.06 |  |  | RLX | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.06 | 0.06 |  |  | RLX | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.06 | 0.06 |  |  |  |  |  |  | RLX | 08:52:00 | Property Not Set | ESP_PM | 2021-11-22 00:00:00 | 0.06 | 0.06 |  |  | 2021-11-22 00:00:00 | 08:52:00 | ESP_PM | Property Not Set | RLX | 0.06 | 0.06
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IDEX | Property Not Set | ESP_PM | 2021-11-22 00:00:00 |  |  |  | PRVB | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.1202 | 0.1202 |  |  | PRVB | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.1202 | 0.1202 |  |  | PRVB | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.1202 | 0.1202 |  |  | PRVB | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.1202 | 0.1202 |  |  | PRVB | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.1202 | 0.1202 |  |  | PRVB | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.1202 | 0.1202 |  |  |  |  |  |  | PRVB | 08:52:00 | Property Not Set | ESP_PM | 2021-11-22 00:00:00 | 0.1202 | 0.1202 |  |  | 2021-11-22 00:00:00 | 08:52:00 | ESP_PM | Property Not Set | PRVB | 0.1202 | 0.1202
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ASTR | Property Not Set | ESP_PM | 2021-11-22 00:00:00 |  |  |  | ZY | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.042 | 0.042 |  |  | ZY | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.042 | 0.042 |  |  | ZY | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.042 | 0.042 |  |  | ZY | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.042 | 0.042 |  |  | ZY | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.042 | 0.042 |  |  | ZY | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.042 | 0.042 |  |  |  |  |  |  | ZY | 08:52:00 | Property Not Set | ESP_PM | 2021-11-22 00:00:00 | 0.042 | 0.042 |  |  | 2021-11-22 00:00:00 | 08:52:00 | ESP_PM | Property Not Set | ZY | 0.042 | 0.042
Archie |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RLX | Property Not Set | ESP_PM | 2021-11-22 00:00:00 |  |  |  | SWN | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0042 | 0.0042 |  |  | SWN | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0042 | 0.0042 |  |  | SWN | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0042 | 0.0042 |  |  | SWN | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0042 | 0.0042 |  |  | SWN | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0042 | 0.0042 |  |  | SWN | Property Not Set | ESP_PM | 08:52:00 | 2021-11-22 00:00:00 | 0.0042 | 0.0042 |  |  |  |  |  |  | SWN | 08:52:00 | Property Not Set | ESP_PM | 2021-11-22 00:00:00 | 0.0042 | 0.0042 |  |  | 2021-11-22 00:00:00 | 08:52:00 | ESP_PM | Property Not Set | SWN | 0.0042 | 0.0042
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRVB | Property Not Set | ESP_PM | 2021-11-22 00:00:00
Finlay |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ZY | Property Not Set | ESP_PM | 2021-11-22 00:00:00
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CLOV | Property Not Set | ESP_PM | 2021-11-22 00:00:00
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SWN | Property Not Set | ESP_PM | 2021-11-22 00:00:00
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SLDB | Property Not Set | ESP_PM | 2021-11-22 00:00:00
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DGLY | Property Not Set | ESP_PM | 2021-11-22 00:00:00
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TUSK | Property Not Set | ESP_PM | 2021-11-22 00:00:00
[NAME]
[NAME]
Mason