Comments
-
@GrantSmith At the beginning, there was a syntax mistake. I attempted the suggestion provided by @ST_-Superman-_ which resolved the syntax error and the formula is working. Thanks!
-
@colemenwilson I appreciate the suggestion of utilizing ETL, but it isn't suitable for this particular situation. The primary objective is to analyze and compare the Skill Levels of technicians or groups of technicians across various regions, company branches, and countries, considering different products and product…
-
Hi @MichelleH , I found the problem. The "empty" cells were not exactly empty. There was " " in them. But now I'm facing another problem :) In cases like this one: I got:
-
Hi @MichelleH , Actually, I think I was able to do it your way, but I still, have some issues. Here is the result for one Order: I used the LAG function to create the "Previous Service Order" based on the "Service Order" and then used the LAG function again to generate the "Work Type Temp" from "WG Combi". Then, I used the…
-
Hi @MichelleH Thank you for your input, however, I have some concerns. Firstly, I think I require the LAG function instead of LEAD since I want to compare the Order of the previous row, correct? The second problem is that the Work Type column doesn't exist. The formula with the logic I shared in Excel is creating the Work…
