Delete rows based on match criteria in two excel files, 1 might be .csv file .Opened in Excel=Fail Chaos

[DocAElstein]

_____ Workbook: 1.xls ( Using Excel 2007 32 bit )

Row\Col	D	H	I	J	K	L	M	N	O	P	Q	R
1	Open	LTP				If column J of 1.xls has buy & column H of 1.xls is not greater than column D of 1.xls			If column J of 1.xls has short & column H of 1.xls is Greater than than column D of 1.xls			If column J of 1.xls has a blank cell
2	1183.72	1227.1	22	BUY		FALSE			FALSE			FALSE
3	139.38	140	25	BUY		FALSE			FALSE			FALSE
4	311.85	312	15083	SHORT		FALSE			15083			FALSE
5	33.165	33.2	17388	SHORT		FALSE			17388			FALSE
6	594	594	100			FALSE			FALSE			100
7	1584.488	1617.9	236	BUY		FALSE			FALSE			FALSE

Worksheet: 1-Sheet1 29May excelforum

_____ Workbook: 1.xls ( Using Excel 2007 32 bit )

Row\Col	D	H	I	J	K	L	M	N	O	P	Q	R
1	Open	LTP				If column J of 1.xls has buy & column H of 1.xls is not greater than column D of 1.xls			If column J of 1.xls has short & column H of 1.xls is Greater than than column D of 1.xls			If column J of 1.xls has a blank cell
2	1183.72	1227.1	22	BUY		=IF((J2:J7="buy")*(H2:H7),I2:I7)			=IF((J2:J7="short")*(H2:H7>D2:D7),I2:I7)			=IF(J2:J7="",I2:I7)
3	139.38	140	25	BUY		=IF((J2:J7="buy")*(H2:H7),I2:I7)			=IF((J2:J7="short")*(H2:H7>D2:D7),I2:I7)			=IF(J2:J7="",I2:I7)
4	311.85	312	15083	SHORT		=IF((J2:J7="buy")*(H2:H7),I2:I7)			=IF((J2:J7="short")*(H2:H7>D2:D7),I2:I7)			=IF(J2:J7="",I2:I7)
5	33.165	33.2	17388	SHORT		=IF((J2:J7="buy")*(H2:H7),I2:I7)			=IF((J2:J7="short")*(H2:H7>D2:D7),I2:I7)			=IF(J2:J7="",I2:I7)
6	594	594	100			=IF((J2:J7="buy")*(H2:H7),I2:I7)			=IF((J2:J7="short")*(H2:H7>D2:D7),I2:I7)			=IF(J2:J7="",I2:I7)
7	1584.488	1617.9	236	BUY		=IF((J2:J7="buy")*(H2:H7),I2:I7)			=IF((J2:J7="short")*(H2:H7>D2:D7),I2:I7)			=IF(J2:J7="",I2:I7)

Worksheet: 1-Sheet1 29May excelforum

If column J of 1.xls has buy & column H of 1.xls is not greater than column D of 1.xls then match column I data of 1.xls with column B of alert.csv and if it matches then delete that entire row of alert.csv

If column J of 1.xls has buy & column H of 1.xls is not greater than column D of 1.xls

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

Filter to match to not false = Empty

If column J of 1.xls has a blank cell then match column I data of 1.xls with column B of alert.csv and if it matches then delete that entire row of alert.csv

If column J of 1.xls has a blank cell

FALSE

FALSE

FALSE

FALSE

100

FALSE

Filter to match to not false = {100}

If column J of 1.xls has short & column H of 1.xls is Greater than than column D of 1.xls then match column I data of 1.xls with column B of alert.csv and if it matches then delete that entire row of alert.csv

If column J of 1.xls has short & column H of 1.xls is Greater than than column D of 1.xls

FALSE

FALSE

15083

17388

FALSE

FALSE

Filter to match to not false = {15083, 17388}

final txt , after running Sub jindonsTesties() , is And (Not F2 = 15083) And (Not F2 = 17388) And (Not F2 = 100)

If column J of 1.xls has buy & column H of 1.xls is not greater than column D of 1.xls then match column I data of 1.xls with column B of alert.csv and if it matches then delete that entire row of alert.csv

If column J of 1.xls has buy & column H of 1.xls is not greater than column D of 1.xls

=TRANSPOSE(IF((J2:J7="buy")*(H2:H7),I2:I7))

=TRANSPOSE(IF((J2:J7="buy")*(H2:H7),I2:I7))

=TRANSPOSE(IF((J2:J7="buy")*(H2:H7),I2:I7))

=TRANSPOSE(IF((J2:J7="buy")*(H2:H7),I2:I7))

=TRANSPOSE(IF((J2:J7="buy")*(H2:H7),I2:I7))

=TRANSPOSE(IF((J2:J7="buy")*(H2:H7),I2:I7))

Filter to match to not false = Empty

If column J of 1.xls has a blank cell then match column I data of 1.xls with column B of alert.csv and if it matches then delete that entire row of alert.csv

If column J of 1.xls has a blank cell

=TRANSPOSE(IF(J2:J7="",I2:I7))

=TRANSPOSE(IF(J2:J7="",I2:I7))

=TRANSPOSE(IF(J2:J7="",I2:I7))

=TRANSPOSE(IF(J2:J7="",I2:I7))

=TRANSPOSE(IF(J2:J7="",I2:I7))

=TRANSPOSE(IF(J2:J7="",I2:I7))

Filter to match to not false = {100}

If column J of 1.xls has short & column H of 1.xls is Greater than than column D of 1.xls then match column I data of 1.xls with column B of alert.csv and if it matches then delete that entire row of alert.csv

If column J of 1.xls has short & column H of 1.xls is Greater than than column D of 1.xls

=TRANSPOSE(IF((J2:J7="short")*(H2:H7>D2:D7),I2:I7))

=TRANSPOSE(IF((J2:J7="short")*(H2:H7>D2:D7),I2:I7))

=TRANSPOSE(IF((J2:J7="short")*(H2:H7>D2:D7),I2:I7))

=TRANSPOSE(IF((J2:J7="short")*(H2:H7>D2:D7),I2:I7))

=TRANSPOSE(IF((J2:J7="short")*(H2:H7>D2:D7),I2:I7))

=TRANSPOSE(IF((J2:J7="short")*(H2:H7>D2:D7),I2:I7))

Filter to match to not false = {15083, 17388}

final txt , after running Sub jindonsTesties() , is And (Not F2 = 15083) And (Not F2 = 17388) And (Not F2 = 100)

final txt , after running Sub jindonsTesties() , Part 1== , is
And (Not F2 = 15083) And (Not F2 = 17388) And (Not F2 = 100)