Create ID base with column

[EvansM]

Hello 

I need help to create a ID column base on data grouping  in put. Below is an example of what I looking

This is an example 

ACCOUNT_NUMBER	TYPE	ID
100001	4
100001	11
100001	5
100005	11
100010	11
100010	4
100012	11

This is what is excepting results

ACCOUNT_NUMBER	TYPE	ID
100001	4	1
100001	11	2
100001	5	3
100005	11	1
100010	11	1
100010	4	2
100012	11	1

[OllieClarke · Accepted solution]

Hi @EvansM 

You can use the multi-row formula tool to do this.
Make a new field called ID which is numeric,
Group By your Account_Number field,
with the formula

[row-1:ID]+1

Hope that helps,

Ollie

[EvansM]

Thanks it works like champ!