On a machine that provides measurements at 4 data points, over any range of intervals, say hourly or daily, what are the most common 4 data points in that period.
In my example spreadsheet by visual observation, the result is shown as the most common data points.In this example of data points over 12 days I can see visually and
calculate the most common data points were 1 -13-11-10
How do I create a formula for four machine data points?
And a formula for a 2nd machine with 6 data points?
I'm not sure how to create the array formula to calculate this.
In my example spreadsheet by visual observation, the result is shown as the most common data points.In this example of data points over 12 days I can see visually and
calculate the most common data points were 1 -13-11-10
How do I create a formula for four machine data points?
And a formula for a 2nd machine with 6 data points?
I'm not sure how to create the array formula to calculate this.