Hi everyone,
I'm trying to copy hourly meteorological data from every 24th cell in a column to a new column, then repeat this going down eg. for 12:00:00 copy data in cells B3, B27,..., B8763 to E3,E4,...,E364, and then for 01:00:00 copy data in cells B4, B28,...,B8764 to F3,F4,...,F364 and so on.
I have tried using the OFFSET function (as shown on image) to no avail. I'm guessing this is probably a VLOOKUP formula, but couldn't get it to work.
Would prefer not to use VBA code (I have several spreadsheets and there is a lot more data than this).
EDIT: Column A contains the Julian date and time (probably why VLOOKUP is not working?)
Part of the spreadsheet is at this link:
http://imagizer.imageshack.us/a/img538/7222/vcHpbp.jpg
Kind regards
I'm trying to copy hourly meteorological data from every 24th cell in a column to a new column, then repeat this going down eg. for 12:00:00 copy data in cells B3, B27,..., B8763 to E3,E4,...,E364, and then for 01:00:00 copy data in cells B4, B28,...,B8764 to F3,F4,...,F364 and so on.
I have tried using the OFFSET function (as shown on image) to no avail. I'm guessing this is probably a VLOOKUP formula, but couldn't get it to work.
Would prefer not to use VBA code (I have several spreadsheets and there is a lot more data than this).
EDIT: Column A contains the Julian date and time (probably why VLOOKUP is not working?)
Part of the spreadsheet is at this link:
http://imagizer.imageshack.us/a/img538/7222/vcHpbp.jpg
Kind regards
Last edited: