Hi all,again! And especially to RaulSerg who helped me at https://www.excelforum.com/excel-for...-a-matrix.html

Everything is OK,but when I wish to change dynamically 1st range ( I define it with Name manager and I save the workbook).But when I reopen that 1st range is dynamically changed by output source and that formula

=LET(x,NewRange,FILTER(FILTER(x,BYROW(x,LAMBDA(a,COUNTIF(a,)<>COLUMNS(x)))),BYCOL(x,LAMBDA(a,COUNTIF(a,)<>ROWS(x)))))

is saved ex-data(and gives a VALUE! error) when 1st saving workbook and not changing anything as 1st range is changing dynamically at the same time.

How could I solve that?