Most Improved

[rubixcube88]

Alright, so 3 problems I need yall's help with please... I posted pictures to give a better idea. I'm hitting a wall... and i'm not an expert with vlookups or array formulas

1. I'm trying to get the top 5 Most improved sales associates. I want names & %Increase
2. And the 5 with the biggest decrease week over week. I want names & % Increase
3. I ran an this (=COUNTA(I2:I97)) to calculate the # of associates that worked... but it's including #N/A since some associates didn't show up the 2 weeks. How can I avoid counting the #N/As?

So this is is what the source is....

And this is pretty much what I want....

 

[MARK858]

3. I ran an this (=COUNTA(I2:I97)) to calculate the # of associates that worked... but it's including #N/A since some associates didn't show up the 2 weeks. How can I avoid counting the #N/As?

You can use either Aggregate or Countifs.

Book1
	A	B	C	D	E	F	G	H	I
2	1	55.26%		5	5			1	55.26%
3	2	#N/A						3	53.90%
4	3	53.90%						5	27.79%
5	4	46.70%						4	46.70%
6	5	27.79%						7	5.97%
7	6	#N/A
8	7	5.97%
9	8	#N/A
Sheet1

Cell Formulas
Range	Formula
D2	D2	=AGGREGATE(3,6,B2:B8)
E2	E2	=COUNTIFS($B$2:$B$8, "<>#N/A",$B$2:$B$8, "<>")
B2:B9	B2	=VLOOKUP(A2,H$2:$I$6,2,0)