I have an Excel with value from Tag1 with Time Stamp and I am using PIArcVal Previous and Next (with the time stamp) to see what was the value of the TagB during the time stamp of Tag1 (Don't want to use interpolated).
I am able to add it to one row, but when I tried to change
=PIArcVal(Verification!$B$1;Verification!$A$8;1;"";"next") to remove the $ from $8 (to be able to applied this to all my rows)
I got the error "You cannot change part of an array"
PS : I dont want to change manualy all the date for every row.
Please help me.