Extract the duplicate number for different values

[sofas]

Hello. Please help me in calculating the number of repetitions based on column D. I have several different values in column D, with the names of the tests in column F being duplicates. I want to extract the result as in the picture. The number of repetitions for the different values.

Dropbox

www.dropbox.com

 

[Eric W]

Try:

Book1
	D	E	F
1
2	test1	4
3	test2	2
4
5	5		test1
6	5		test1
7	7		test1
8	7		test1
9	8		test1
10	8		test1
11	8		test1
12	8		test1
13	9		test1
14	11		test2
15	11		test2
16	15		test2
17	11		test2
18	11		test2
Sheet4

Cell Formulas
Range	Formula
E2:E3	E2	=SUM(IFERROR(1/COUNTIFS($D$5:$D$18,$D$5:$D$18,$F$5:$F$18,D2),0))
Press CTRL+SHIFT+ENTER to enter array formulas.