Replace values

[nvijay5757]

Hi,

my data looks like,

in this Modes 8.0AB and 35.0AB showing KD column as KD and nKD will replace these values to KD. like KDnew column as my output. i am trying if condition not working help me thanks.

[Mark_Little]

hi @nvijay5757 

I don't fully understand the condition which you replace the KD Field. So hard to say exactly.

I think if you are comparing rows you will need to look at the Peek and previous functions.