VBA Code for Average and count

[OVSD_DS]

I have a spreadsheet that I would like to use as VBA Code to look at the worksheet and below every person count give me an Average, sometime the person will have 6 line items and sometimes it will have 3 or 2 also on the bottom of the average I will like to have how many time the count is higher than the Average. is this possible with a VBA code

name	08/21 Count
Alvarez	30
Alvarez	32
Alvarez	33
Alvarez	32
Alvarez	32
Alvarez	33
Average--->
count of how many times >
Armstrong	27
Armstrong	28
Armstrong	26
Armstrong	28
Armstrong	25
Average--->
Arredondo	6
Arredondo	6
Average--->

 

[Jeffrey Mahoney]

I like VBA and use it all the time. In this case though, why don't you create a separate table that summarizes those values. I would do it like this

Book2
	A	B	C	D	E	F	G
1						8/21/2024
2	Name	Count	Date			Average	Count over Avg
3	Alvarez	30	8/21/2024		Alvarez	32	2
4	Alvarez	32	8/21/2024		Armstrong	26.8	3
5	Alvarez	33	8/21/2024		Arredondo	6	0
6	Alvarez	32	8/21/2024
7	Alvarez	32	8/21/2024
8	Alvarez	33	8/21/2024
9	Armstrong	27	8/21/2024
10	Armstrong	28	8/21/2024
11	Armstrong	26	8/21/2024
12	Armstrong	28	8/21/2024
13	Armstrong	25	8/21/2024
14	Arredondo	6	8/21/2024
15	Arredondo	6	8/21/2024
Sheet1

Cell Formulas
Range	Formula
E3:E5	E3	=UNIQUE(A3:A15)
F3:F5	F3	=AVERAGEIFS($B$3:$B$15,$A$3:$A$15,$E3,$C$3:$C$15,F$1)
G3:G5	G3	=COUNTIFS($A$3:$A$15,$E3,$C$3:$C$15,F$1,$B$3:$B$15,">"&F3)
Dynamic array formulas.