ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Interleaving arrays (https://www.excelbanter.com/charts-charting-excel/202411-interleaving-arrays.html)

Vince

Interleaving arrays
 
I have two sets of arrays.

Array one contains a column of time values with a fixed interval.

Array two contains a column of time values with random interval.

I need to correlate the data related to each time value to a common
time-base array so that, for example, it can be plotted.

The problem is that the arrays are long (10k samples), so I need an
automated way to do this. I use the term 'interleave' to mean how do I get
the two arrays of time values merged into one array that runs sequentially,
while still maintaining some relationship to the data values associated with
each initial array.

Hope this makes some sense to someone!

Thanks,
vince


All times are GMT +1. The time now is 02:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com