Dear friends:
I have a MAP within a LET which changes values from old ones to new ones when conditions are met:
Problem, I may end up with duplicates values in this MAP. Strangely, when I type:=LET( Cell;A4; Label;B$3; Array;FRACTIONNER.TEXTE(Cell;",";;1); ArrayMap;MAP(Array;LAMBDA(x;RECHERCHEX(Label&x;E$4:E$5&F$4:F$5;G$4:G$5;x;0;1))); ArrayMapUnique;UNIQUE(ArrayMap); Condition;""; Result;SI(ET(Cell<>"";Condition="");JOINDRE.TEXTE(",";1;ArrayMapUnique);Condition); Result)
It does not remove the duplicates. Where did I make a mistake in this code?ArrayMapUnique;UNIQUE(ArrayMap);
Any ideas here?
Please see pic + workbook. Thank you.
remove_duplicates_after_map.jpg
Bookmarks