Hi,
I have the below requirement.
For eg: I have the values in the Input Queue(1st column) and output values should be in the (2nd column) as shown below
10 - 10
10 - 20
04 - 10
04 - 20
04 - 30
10 - 30
04 - 40
04 - 50
i.e the values should be incremented by 10... and and it shd increment for the same value
for the 1st two occurances of 10... value was 10, 20, and 10 has occurred again, it was incremented by 10 as 30
when a new value 40 has come... incremented started by 10... same as above ... incremented by 10 wherever 40 occurs
So I need a UDF to achieve the same... I tried using graphical. using Index function but did not work
Thanks,
Varun