dakobbie03
New Member
- Joined
- Sep 16, 2014
- Messages
- 4
I can't wrap my head around what I need to do in order to count the number of distinct "Calculated Rates" with a certain "Account Number"? so with the data below, 10008-06785-5-00001</SPAN> would be 3 because there are 3 distinct rates under this account number. so how can i do this with a formula for my whole list?
<TBODY>
</TBODY>
ACCOUNTNUMBER</SPAN> | CALCULDATED_RATE</SPAN> |
10008-06785-5-00001</SPAN> | 0.549</SPAN> |
10008-06785-5-00001</SPAN> | 0.549</SPAN> |
10008-06785-5-00001</SPAN> | 0.549</SPAN> |
10008-06785-5-00001</SPAN> | 0.549</SPAN> |
10008-06785-5-00001</SPAN> | 0.579</SPAN> |
10008-06785-5-00001</SPAN> | 0.579</SPAN> |
10008-06785-5-00001</SPAN> | 0.579</SPAN> |
10008-06785-5-00001</SPAN> | 0.579</SPAN> |
10008-06785-5-00001</SPAN> | 0.58</SPAN> |
10116-26330-7-00001</SPAN> | 0.689</SPAN> |
10116-26330-7-00001</SPAN> | 0.689</SPAN> |
10116-26330-7-00001</SPAN> | 0.689</SPAN> |
10116-26330-7-00001</SPAN> | 0.689</SPAN> |
10116-26330-7-00001</SPAN> | 0.579</SPAN> |
10116-26330-7-00001</SPAN> | 0.579</SPAN> |
10116-26330-7-00001</SPAN> | 0.579</SPAN> |
10434-68820-4-00001</SPAN> | 0.599</SPAN> |
10434-68820-4-00001</SPAN> | 0.599</SPAN> |
10434-68820-4-00001</SPAN> | 0.599</SPAN> |
10434-68820-4-00001</SPAN> | 0.599</SPAN> |
10434-68820-4-00001</SPAN> | 0.579</SPAN> |
10434-68820-4-00001</SPAN> | 0.579</SPAN> |
10434-68820-4-00001</SPAN> | 0.579</SPAN> |
10434-68820-4-00001</SPAN> | 0.579</SPAN> |
10434-68820-4-00001</SPAN> | 0.579</SPAN> |
10434-68820-4-00001</SPAN> | 0.579</SPAN> |
<TBODY>
</TBODY>