Hi guys i have the following formula in CELL AO2, manually it works so i recorded the macro, i selected cell AO2 put the formula in and it works
Code
=LET(a,AH2,b,Y:Y,c,AA:AA,d,AF:AF,e,TRANSPOSE(UNIQUE(FILTER(c,b=a))),f,SUMIFS(d,b,a,c,e),TEXTJOIN(", ",,FILTER(f,f<>0)&" "&e))
macro formula, i select ao2 cell and run the macro again , it gives an error, any help is appreciated