Hello,
I am struggling trying to get a count formula to count a number of transactions (with duplicate numbers) only once within a date range in a table containing over 60 months. In the example below, I need to count the number of transactions (which has duplicates and I need them to be counted as one) by the period/yr. i.e. how many transactions for 201107?
I cant do a pivot table or the remove duplicates function, I need a formula. Thank you.
Example Table:
Transactions Period/Yr
<tbody>
</tbody><colgroup><col><col></colgroup>
I am struggling trying to get a count formula to count a number of transactions (with duplicate numbers) only once within a date range in a table containing over 60 months. In the example below, I need to count the number of transactions (which has duplicates and I need them to be counted as one) by the period/yr. i.e. how many transactions for 201107?
I cant do a pivot table or the remove duplicates function, I need a formula. Thank you.
Example Table:
Transactions Period/Yr
4964542948 | 201109 |
4966894994 | 201107 |
4930321980 | 201107 |
4973587935 | 201101 |
4934688031 | 201107 |
4964542948 | 201109 |
4964542948 | 201109 |
4970536953 | 201107 |
4966894993 | 201107 |
4966894993 | 201107 |
4964542948 | 201109 |
4973587935 | 201101 |
4964542948 | 201109 |
4925479054 | 201107 |
4978588949 | 201112 |
4966894993 | 201107 |
4966894993 | 201107 |
<tbody>
</tbody><colgroup><col><col></colgroup>