Combining Excel Data
I want to combine 2 sets of Excel data for the same time period and one was collected every second and the second one every minute. How can I combine/merge the second set of data into the first fir...
Forum Discussion
Assuming you want to align these to chart them together... a simple Vlookup function formula as a new column alongside the solar controller data should do it. Fetch the USNO value where the USNO time = solar controller time.
That's *IF* what you have is real time values (a number). If it's text... same answer but you need the text formats to match.
That's *IF* what you have is real time values (a number). If it's text... same answer but you need the text formats to match.
