Forum Discussion
Looking for an Excel Formula
Hello Everyone, I have 2 Colomns Supplier and Code . i need a formula that can change the position of a cell in colomn B if there is a duplication in colomn A. The output of the formula shoul...
Perhaps with REDUCE:
'Organize
=LAMBDA(a,v,LET(filtered, FILTER(Code, Supplier = v), IFERROR(VSTACK(a, HSTACK(v, TOROW(filtered))), "")))
=REDUCE({"Supplier","Code"},UNIQUE(Supplier),Organize)