Retrieve members of a cohort

The DCCOHORTMEMBERS formula returns the members of each cohort provided. Here a cohort is a general term for a group of entities, like the CDC’s list of the United States’ 500 largest cities.

Formula

=DCCOHORTMEMBERS(dcids)

Required arguments

  • dcids - A single node or range of cells representing nodes, identified by their DCIDs, whose members are sought.

Returns

The DCIDs of the cohort members. For a single DCID, the result is a column of members of the cohort represented by that DCID. For a row of DCIDs, the result is a matrix with each column the members of the cohort whose DCID serves as the column’s index. For a column of DCIDs, the result is a matrix with each row the members of the cohort whose DCID serves as the row’s index.

Example: Retrieve the list of cities that are members of the CDC 500 cohort

Note: Be sure to follow the instructions for for enabling the Sheets add-on before trying this example.

To retrieve the members of the CDC 500 cities cohort:

  1. Place your cursor in any cell, say A1, and enter CDC500_City.

  2. In cell B1, enter =DCCOHORTMEMBERS(A1).

    DCCOHORTMEMBERS example

    The list of member DCIDs populates column B.

    DCCOHORTMEMBERS example

  3. (Optional) To get the names of the members, in cell C1, enter DCGETNAME(B1:B500).

Page last updated: December 17, 2024 • Send feedback about this page