Subtraction a filtered list

[tinkode]

hello kings of excel i want Subtraction filtered list
the first number - the last number

i have many filtered list so i can't use =sum(X1-X2) it will take many times

 

[Bo_Ry]

Please try

=INDEX(L14:L260,MATCH(1,INDEX(SUBTOTAL(2,OFFSET(L13,ROW(L1:L260),)),),))-L260

 

[tinkode]

not working its show 132880-131710 = -34710

 

[tinkode]

formula for Subtraction for filtered list

 

[CyrusTheVirus]

Re: formula for Subtraction for filtered list

is your filtered list a table or no?

 

[tinkode]

Re: formula for Subtraction for filtered list

yes

 

[CyrusTheVirus]

Re: formula for Subtraction for filtered list

are your numbers always in sequence order like they are in the example? Because if so you could probably use the below formula?

=SUBTOTAL(4,Table1[Numero])-SUBTOTAL(5,Table1[Numero])

 

[Bo_Ry]

Please try again, note the Offset OFFSET(M13,ROW(M1:M260),))

Data start at M14

=INDEX(M14:M260,MATCH(1,INDEX(SUBTOTAL(2,OFFSET(M13,ROW(M1:M260),)),),))-INDEX(M14:M260,MATCH(1,INDEX(1/SUBTOTAL(2,OFFSET(M13,ROW(M1:M260),)),)))


=INDEX(M14:M260;EQUIV(1;INDEX(SOUS.TOTAL(2;DECALER(M13;LIGNE(M1:M260); )); ); ))-INDEX(M14:M260;EQUIV(1;INDEX(1/SOUS.TOTAL(2;DECALER(M13;LIGNE(M1:M260); )); )))

 

[tinkode]

you are the king thanks you <3

 

[Bo_Ry]

Happy to help