Forum Discussion
Creating a Distinct Column Count of a Column Based on Another Column Data
KT,
Thank you for the reply. When I input this in and adjust it to my sheet I am not quite getting the right result.
For me this reported the row count for each individual "Unique Identifier" in it's respecitve row. In other words it reported the following:
| Unique Identifier | Date | Week of Month | Distinct Count Week 1 | Distinct Count Week 2 | Distinct Count Week 3 | Distinct Count Week 4 |
1XY100000 | 1/3 | 1 | 2 | Null | Null | Null |
| 1XY100000 | 1/5 | 1 | 2 | Null | Null | Null |
| 1XY100001 | 1/7 | 1 | 3 | Null | Null | Null |
| 1XY100001 | 1/7 | 1 | 3 | Null | Null | Null |
| 1XY100001 | 1/7 | 1 | 3 | Null | Null | Null |
| 1XY100002 | 1/10 | 2 | Null | 1 | Null | Null |
| 1XY100003 | 1/11 | 2 | Null | 2 | Null | Null |
| 1XY100003 | 1/11 | 2 | Null | 2 | Null | Null |
| 1XY100004 | 1/17 | 3 | Null | Null | 2 | Null |
| 1XY100004 | 1/18 | 3 | Null | Null | 2 | Null |
| 1XY100005 | 1/25 | 4 | Null | Null | Null | 1 |
| 1XY100006 | 1/25 | 4 | Null | Null | Null | 1 |
What I was looking for was it to search in "Week of Month" column and if Week of Month=1 report back the distinct number of Unique identifer numbers in the Unique Identifier column into the created column. So for Week 1 there are two unique identifiers in column 1 (1XY100000 & 1XY100001). So I would want the output in the created column to be "2" for all rows being that distinctly 2 unique identifiers were found in rows where Week of Month=1.
Thank you in advance for anything else you may suggest.