I am trying to calculate average, minimum and maximum values of a particular tags for a given start and end time in excel.
I am able to do it through PICompDat function which can list all the values for a specific period of time. But that is very ugly process.
I have to eliminate "#N/A" and "No more values:" messages in the column in every single cell for excel to be able to calculate the averages or the maximums which takes time.
Provided I am not missing any tag attribute given in the datalink,
Is there any faster way to get those values?