Auto-populate a table based on status

[Ric F]

I have a table that had a provider name and Status with various rates per quarter. I am trying to get a table that will give me only the Active "A" providers on a different tab. Know I've done this in college years ago and cannot remember the way to do it. thanks for your help! Ric

Provider Name	Status	7/1/2014​	10/1/2014​	1/1/2015​	4/1/2015​	7/1/2015​	10/1/2015​
ABC	A	165​	168.14​	176.4​	171.54​	172.61​	172.68​
BCD	A	132.08​	128.1​	130.76​	129.27​	137.91​	130.7​
CDE	A	153.29​	150.52​	153.76​	156.47​	145.97​	148.99​
DEF	I	177.86​	179.21​	179.39​	180.64​	158.97​	158.11​
EFG	A	158.77​	150.63​	153.22​	146.87​	136.19​	148.65​
FGH	A	176.55​	182.66​	179.87​	178.91​	190.72​	189.17​
GHI	I	148.41​	150.42​	150.79​	151.03​	155.89​	152.97​
HIJ	A	144.46​	142.81​	143.54​	143.72​	152.68​	155.75​
IJK	A	133.88​	129.2​	133.47​	129.98​	147.08​	150.36​
JKL	I	160.39​	161.96​	163.93​	163.69​	181.4​	180.29​
KLM	A	126.78​	127.21​	125.73​	123.22​	136.04​	137.96​
LMN	A	159.67​	158.63​	159.16​	154.36​	156.07​	154.03​

 

[Fluff]

What version of Excel are you using?

It would be helpful if you updated your profile to show it, as formulae are version dependant.

 

[Ric F]

Excel365

 

[Fluff]

In that case, how about

+Fluff.xlsm
	A	B	C	D	E	F	G	H
1	Provider Name	Status	7/1/2014	10/1/2014	1/1/2015	4/1/2015	7/1/2015	10/1/2015
2	ABC	A	165	168.14	176.4	171.54	172.61	172.68
3	BCD	A	132.08	128.1	130.76	129.27	137.91	130.7
4	CDE	A	153.29	150.52	153.76	156.47	145.97	148.99
5	EFG	A	158.77	150.63	153.22	146.87	136.19	148.65
6	FGH	A	176.55	182.66	179.87	178.91	190.72	189.17
7	HIJ	A	144.46	142.81	143.54	143.72	152.68	155.75
8	IJK	A	133.88	129.2	133.47	129.98	147.08	150.36
9	KLM	A	126.78	127.21	125.73	123.22	136.04	137.96
10	LMN	A	159.67	158.63	159.16	154.36	156.07	154.03
Sheet2

Cell Formulas
Range	Formula
A2:H10	A2	=FILTER(Sheet1!A2:H13,Sheet1!B2:B13="A")
Dynamic array formulas.

 

[Ric F]

I get "That function isn't valid."
I copied my headers (A1:H1) to Sheet2 and in Sheet2 A2 entered the above formula.

 

[Fluff]

Do you have the new Dynamic Array Functions?

 

[Ric F]

I'm actually trying to find where they are at this moment.

 

[Fluff]

What channel are you on & what is the build number?
If you select File > Account it will show you

 

[Ric F]

It appears I do not, but I will see if I can get it loaded.

 

[Ric F]

Thanks for your help!