How do I delete positive and negative entries

[ghrek]

Hi

First of all posted on here too How do I delete matching entries on 2 sheets.


In the attached workbook I have a difference of £30.35 of which im trying to find out what makes it up.
I think what I need to do is look in column B first and then in column G . If there is a matching positive and negative value in column G and the number in column B is the same for both entries then I need the lines deleting.

If you look at lines 3 &4 there is a negative and a positive £1410.00 and the digits in column B are the same so need them lines deleting. I need this to look all over the workbook and delete matching as required

tuesday .xlsb
	A	B	C	D	E	F	G	H	I
1	Recreated Data	Issuing Location Code	Issuing TOC / Third Party Code	Date of Issue	Sundry Code	RSP Period Number	Gross Receipt
2	Data Recreated	2464	EK	16/09/2021 00:00	91594	6	£0.00
3	Data Recreated	2464	EK	16/09/2021 00:00	95055	6	-£1,410.00
4	Data Recreated	2464	EK	16/09/2021 00:00	95140	6	£1,410.00
5	Data Recreated	2466	EK	06/09/2021 00:00	91594	6	£0.00
6	Data Recreated	2466	EK	06/09/2021 00:00	95055	6	-£139.60
7	Data Recreated	2466	EK	06/09/2021 00:00	95140	6	£139.60
8	Data Recreated	2466	EK	16/09/2021 00:00	0	6	-£16.70
9	Data Recreated	2466	EK	16/09/2021 00:00	91594	6	£0.00
10	Data Recreated	2466	EK	16/09/2021 00:00	95140	6	£16.70
11	Data Recreated	2466	EK	16/09/2021 00:00	95162	6	£0.00
12	Data Recreated	2472	EK	16/09/2021 00:00	0	6	-£135.00
13	Data Recreated	2472	EK	16/09/2021 00:00	91594	6	£0.00
14	Data Recreated	2472	EK	16/09/2021 00:00	95140	6	£135.00
15
16
17
Sheet_1_data (1)

 

[Joe4]

How is this different than what you asked here last week?

How do I delete matching positive and negative entries in a column

Hi In column G of my workbook I have lots of positive and negative values. Im trying to get it to look all the way down column G and if there is a matching positive and negative entry of the same value I need the rows they are on completely deleting. Any Ideas? Thanks

www.mrexcel.com