Blessy Clara
Board Regular
- Joined
- Mar 28, 2010
- Messages
- 201
Hi All,
I have a AC_ID in column A, which contains multiple records for a given AC_ID, I need help to count the number of records per ID
Example
<tbody>
</tbody>
I require a table calculated as this
<tbody>
</tbody>
To calculate Number of records per ID Number
Thank you
I have a AC_ID in column A, which contains multiple records for a given AC_ID, I need help to count the number of records per ID
Example
AC_ID | Records |
256 | Record1 |
256 | Record2 |
256 | Record3 |
40435 | Record4 |
40435 | Record5 |
40435 | Record6 |
5208 | Record7 |
362 | Record8 |
362 | Record9 |
<tbody>
</tbody>
I require a table calculated as this
AC_ID | Count |
40435 | 3 |
5208 | 1 |
362 | 2 |
1487 | 8 |
5489 | 85 |
256 | 3 |
<tbody>
</tbody>
To calculate Number of records per ID Number
Thank you
Last edited: