Forum Discussion

mm_mmmm_mm's avatar
mm_mmmm_mm
Copper Contributor
Dec 06, 2023

Excel changes array formulas when creating new worksheets

Dear forum,   I have a strange problem. I have the following formula:   =FILTER(SAPDATA_ScannerVKP; WENN(COUNTA(L2#)=1;SAPDATA_ScannerVKP[Kunde]=INDEX(L2#;1)))     (contains references to t...
excel
Formulas and Functions
office 365
Rodrigo_'s avatar
Rodrigo_
Steel Contributor
Dec 15, 2023

Himm_mmmm_mm 
you may try to change/revise your formula into absolute reference ( $A$1 ), instead of using structured reference ( TableName[ColumName] ).

Example:

=FILTER(SAPDATA_ScannerVKP, 
IF(COUNTA($L$2:$L$100)=1, SAPDATA_ScannerVKP[$A$2:$A$100]=INDEX($L$2:$L$100,1)))