I have a Task Name , Task Number , Region , State.
where Task Name is not Unique for example :-
Task name would be same for 3 to 4 rows
like
Task Name :- ABC123
Task Number :- 1
Region :- XYZ
State: - PQRS
Task Name :- ABC123
Task Number :- 2
Region :- XYZ
State: - PQRS
Task Name :- ABC123
Task Number :- 3
Region :- XYZ
State: - PQRS
Now as you can see the only Task Number is changing not all the column. some time Region or state must be different but Task Number is change when Task Name is added again n again.
I have a form where i have to form formula on Task number How would i do that.
