Filter Function - Change sign

[pto160]

I am using the filter function to find multiple matches between a bank report and my accounting system. That is the great thing about Excel 365. I am using filter with the entire range, but I am trying to change the sign from negative to positive. Is this possible?

Book1
	A	B	C	D	E
1	Vendor ID	Vendor Name	Amount		ID Match
2	24001	John Smith	-100.00		T100
3	25001	Jane Doe	-200.00		T200
4	26001	Paul Heart	-300.00		T100
5
6	ID MATCH
7	T100	=FILTER(A2:C4,E2:E4=A7)	John Smith	-100.00
8		26001	Paul Heart	-300.00
9
10	WHAT I LIKE
11	T100	24001	John Smith	100.00
12		26001	Paul Heart	300.00
Sheet1

 

[Fluff]

How about

=FILTER(HSTACK(A2:B4,ABS(C2:C4)),E2:E4=A7)

 

[pto160]

Thank you so much. The formula works great.

 

[Fluff]

You're welcome & thanks for the feedback.