excluding from filter function certain cells/value

[excelNewbie22]

hi,
i have this function

=SORT(FILTER(INDIRECT("N2:N"&P1+1),(NOT(ISNUMBER(XMATCH(INDIRECT("N2:N"&P1+1),SORT(FILTER(C3:C5640,(A3:A5640>=EOMONTH(B440,-1)+1)*(A3:A5640<=EOMONTH(B440,0)))))))*(INDIRECT("N2:N"&P1+1)<>""))))

and in want to update it by adding excluding certain names from the c column, how can i do it?

 

[excelNewbie22]

anyone?

 

[excelNewbie22]

 

[excelNewbie22]

solution:

=SORT(FILTER(INDIRECT("N2:N"&P1+1),(NOT(ISNUMBER(XMATCH(INDIRECT("N2:N"&P1+1),SORT(FILTER(C3:C5640,(A3:A5640>=EOMONTH(B440,-1)+1)*(A3:A5640<=EOMONTH(B440,0)))))))*(INDIRECT("N2:N"&P1+1)<>"")[B]*(INDIRECT("N2:N"&P1+1)<>N1328)[/B])))

adding: *(INDIRECT("N2:N"&P1+1)<>N1328)

 

[Peter_SSs]

Glad you found a solution but for the future, it wasn't much wonder nobody here could help since we didn't know what any of your data looks like, what is in P1 etc and cell N1328 was not even mentioned, let alone what is in it.

 

[excelNewbie22]

you right peter, will try next time to give more details, thank you for your comment