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

 

[tinkode]

can you poste the old replay its was working

 

[tinkode]

its working for all numbers
but the probleme with the first one 261544-205150 = 55878

its should be 56394

 

[jtakw]

Re: formula for Subtraction for filtered list

Very similar post by OP:

https://www.mrexcel.com/forum/excel-questions/1087719-subtraction-filtered-list.html

 

[jtakw]

Re: formula for Subtraction for filtered list

And here:

https://www.mrexcel.com/forum/excel-questions/1087727-formula-subtraction-filtered-list.html

 

[Fluff]

Re: formula for Subtraction for filtered list

@tinkode
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. (rule 12 here: Forum Rules).
I have merged both threads

 

[Bo_Ry]

Data start at M12

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


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