I have a "Planning" column which is causing duplicates, I need to prioritize the contents of this column which contains A , B and C such that A is stronger then B then C.
For exemple : if Planning contains A, B and C, then Planning take A , if B and C then Planning must take B...
I tried this but it didn't work :
if ( match(Planning,'A') and match ( Planning,'B'),'A', if ( match(Planning,'A') and match ( Planning,'C'),'A', if ( match(Planning,'B') and match ( Planning,'C'),'B'))) as Plan
