remove outlier

[davizinhoo]

I need to remove outlier automatically. I have a table with the possible number that will be the outlier (use this table as a reference) then I want to get the name and number in this table. And the table that contains the data to be removed has to know what the name reference is so I know which is the right outlier​

outlier.xlsx
	A	B	C	D	E
1	Date	Home	Away	HG	AG
2	26/12/2017	Bournemouth	West Ham	3	3
3	26/12/2017	Chelsea	Brighton	2	0
4	26/12/2017	Huddersfield	Stoke	1	1
5	26/12/2017	Liverpool	Swansea	5	0
6	26/12/2017	Man United	Burnley	2	2
7	26/12/2017	Tottenham	Southampton	5	2
8	26/12/2017	Watford	Leicester	2	1
9	26/12/2017	West Brom	Everton	0	0
10	27/12/2017	Newcastle	Man City	0	1
11	28/12/2017	Crystal Palace	Arsenal	2	3
12	30/12/2017	Bournemouth	Everton	2	1
13	30/12/2017	Chelsea	Stoke	5	0
14	30/12/2017	Huddersfield	Burnley	0	0
15	30/12/2017	Liverpool	Leicester	2	1
16	30/12/2017	Man United	Southampton	0	0
17	30/12/2017	Newcastle	Brighton	0	0
18	30/12/2017	Watford	Swansea	1	2
19	31/12/2017	Crystal Palace	Man City	0	0
20	31/12/2017	West Brom	Arsenal	1	1
21	01/01/2018	Brighton	Bournemouth	2	2
22	01/01/2018	Burnley	Liverpool	1	2
23	01/01/2018	Everton	Man United	0	2
24	01/01/2018	Leicester	Huddersfield	3	0
25	01/01/2018	Stoke	Newcastle	0	1
26	######	Man City	Watford	3	1
DADOS

outlier.xlsx
	AF	AG	AH	AI	AJ
4		Extremo < H3	Extremo > H4	Extremo < A5	Extremo > A6
5	Arsenal	-4	11	1	1
6	Bournemouth	-2	5	-2	5
7	Brighton	-6	9	-3	4
8	Burnley	-3	5	-6	8
9	Cardiff	#NÚM!	#NÚM!	#NÚM!	#NÚM!
10	Chelsea	-4	7	-6	9
11	Crystal Palace	-4	7	-2	5
12	Everton	-4	7	-4	5
13	Fulham	#NÚM!	#NÚM!	#NÚM!	#NÚM!
14	Huddersfield	-3	4	-3	4
15	Leicester	-6	9	-5	8
16	Liverpool	-5	11	-6	8
17	Man City	-6	12	-5	9
18	Man United	-3	6	-8	10
19	Newcastle	-7	9	-5	6
20	Southampton	-5	7	-6	8
21	Tottenham	-9	14	-4	7
22	Watford	-2	5	0	0
23	West Ham	-4	7	-4	7
24	Wolves	#NÚM!	#NÚM!	#NÚM!	#NÚM!
DADOS

Cell Formulas
Range	Formula
AG4	AG4	='C:\Users\davi\Desktop\inicio\pegar dados - 1pavilhao.xlsm'!Tabela49[[#Headers],[Extremo < H3]]
AH4	AH4	='C:\Users\davi\Desktop\inicio\pegar dados - 1pavilhao.xlsm'!Tabela49[[#Headers],[Extremo > H4]]
AI4	AI4	='C:\Users\davi\Desktop\inicio\pegar dados - 1pavilhao.xlsm'!Tabela49[[#Headers],[Extremo < A5]]
AJ4	AJ4	='C:\Users\davi\Desktop\inicio\pegar dados - 1pavilhao.xlsm'!Tabela49[[#Headers],[Extremo > A6]]
AG5:AJ24	AG5	='C:\Users\davi\Desktop\inicio\[pegar dados - 1pavilhao.xlsm]medidas|posição'!AQ9

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
AG5:AJ24	Other Type	Color scale		NO

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: remove outlier
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.