Need Multiple Formulas for one Macro

[PaigeWarner]

Hello I need formulas for the following parameters (in the below order) to create one Macro:

1. Delete rows that do not start with a 47 in Purchasing Document (column D).
2. Delete rows that do not have an ME730 Status message (column P).
3. Delete rows that have ZSPC under Material Type (column F).
4. Look at two columns together: Material Number (column J) and New Price (column N) and delete extra duplicate rows.

Here is a screen shot of how the file starts out:

And here is a screen shot of how it should end up (the rows that should be left after all the parameters used):

Here is a copy and paste of the rows and columns:

IDoc number	Partner number	Vendor Name	Purchasing Document	Item	Material Type	Gen. item cat. grp	Mtrl Stock Status	Material Category	Material Number	MIC Number	Material Description	Old Price	New Price	% PriceVariance	Status message
799889375	11121	GHI Incorporated	4703996627	11	HAWA	ZNOR	Stock	02	110104	D567H2	Grill Cleaner	25.70	26.46	2.96	ME730
799889371	11121	GHI Incorporated	4703996626	5	HAWA	ZNOR	Stock	02	110104	D567H3	Grill Cleaner	25.70	27.46	2.96	ME730
799888572	11121	GHI Incorporated	4703996624	1	HAWA	ZNOR	Stock	02	110104	D567H4	Grill Cleaner	25.70	26.46	2.96	ME728
799889377	11121	GHI Incorporated	5103996622	2	HAWA	ZNOR	Stock	02	110104	D567H5	Grill Cleaner	25.70	26.46	2.96	ME730
799925395	31415	JKL Incorporated	4703996431	21	HAWA	ZNOR	Stock	14	119219	J1313RN	Ice Bucket	8.83	9.06	2.60	ME730
799922758	31415	JKL Incorporated	4703996430	22	HAWA	ZNOR	Stock	14	119219	J1313RN	Ice Bucket	8.83	9.06	2.60	ME730
799679315	31415	JKL Incorporated	4703996427	8	HAWA	ZNOR	Stock	14	119219	J1313RN	Ice Bucket	8.83	9.06	2.60	ME730
799752589	31415	JKL Incorporated	4703996424	22	HAWA	ZNOR	Stock	14	119219	J1313RN	Ice Bucket	8.83	9.06	2.60	ME728
799925399	31415	JKL Incorporated	5103996421	8	HAWA	ZNOR	Stock	14	119219	J1313RN	Ice Bucket	8.83	9.06	2.60	ME730
799648832	16171	MNO Incorporated	4703996046	3	HAWA	ZNOR	Stock	14	137148	27YH3R	Landry Detergent	117.64	135.70	15.35	ME730
799648832	16171	MNO Incorporated	4703996046	5	ZSPC	ZNOR	Stock	14	137153	28YH3R	Water Tank	180.83	207.44	14.72	ME730
799648832	16171	MNO Incorporated	3003996046	11	ZSPC	ZNOR	Stock	14	137165	29YH3R	Floor Cleaner	113.88	141.34	24.11	ME730
799648832	16171	MNO Incorporated	4703996046	12	HAWA	ZNOR	Stock	14	137168	30YH3R	Blender	208.01	222.20	6.82	ME730
799648832	16171	MNO Incorporated	4703996046	2	HAWA	ZNOR	Stock	14	137177	26YH3R	Dish Soap	101.84	109.48	7.50	ME790
800018928	67891	DEF Incorporated	4703996590	1	ZSPC	ZBN3	Non Stock	24	443217	H2312P	Faucet Handle	38.34	40.25	4.98	ME730

I know this is a lot at once so thank you so much in advance for any assistance you can provide!

 

[Zot]

I wonder why the data row #2 was excluded. I think the row satisfy all conditions and the duplicate for it is in row #4
The first row should have no duplicate