Skip to Content
0
Former Member
Jan 11, 2011 at 12:08 PM

UDF to Increment values by 10

351 Views

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