Forum Discussion
extract single value
Hi, in the attached sheet, C4 extracts the unique values from C3 with conditions C1-A && C2-P1in C4 - 500, If C2 is duplicated single value should consider in C4. Hence the reuired Column is...
It returns the following table in Power Query:
It does it by inserting an Index column first, then getting the previous row by referencing the index value - 1.
Could you please share the file