I am using a reference for the start and end times of a sampled data range.
When I fill across the columns of the start and end time dont increment because of the fixed $ reference.
When I delete the $ symbol, it gets added again.
Try entering your formula and getting the results using datalink. Then highlight the results you got and edit the formula from the formula bar at the top to remove the $ from the timestamps, and press ctrl+shift+enter to fill the array with the edited formula. This should then be able to be copied to the right without the fixed reference on the first column.
Jessica.....you are a genius.
Thanks, worked a treat
Thanks Brad! I'm glad I could help!
Retrieving data ...