AnsweredAssumed Answered

Automating a formula on excel using Pi Datalink function?

Question asked by FelixCheah on Jan 25, 2018
Latest reply on Jan 26, 2018 by gristock

On the second set of data, im trying to use a Pi Datalink function to get some data. This data is dependent on the data from the 1st column. Instead of manually keying everything, is there a way for me to get excel to automatically do this.

 

For example i'm using the compressed data function and the starting times for the second set of data is suppose to be the time on each row of the first set of data. I've tried drag it, but excel doesn't want to increment the column number. I hope that make sense.

Outcomes