I have to excel Files. This is my first excel file:
And this is my second excel file:
I want to load the second excel file, but in the load I want to calculate a value.
The formula, is in words:
If the supplier from the first excel file is the same as in the second excel file, then count how often the duration is smaller then the first time and how often the duration is between time1 and time2. If the supplier from the first excel file is not the same as in the second, check the other supplier
I don't know how can I create a loop. My script looks like: