1681 Views
Hi everyone,
I keep having this error related to data reading from excel. My data is organized according to year and week slices on the excel file. The first column is for years, the second columns is for weeks, and the third one is for the data. If I do the data order according to years, the system is disregarding time slices (i.e., weeks) and considering all 1981, 1982, 1983, etc. attached to weeks as duplication, except Year-Week 1. I tried to change the order according to time slices, but this time the error is "Year 1981 not in ascending chronological order at cell Asomething". So, it expects years to continue even though week groups change.
Has anyone had this error before? How do you organize your year and time-sliced data on excel?