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?
Bookmarks