Finding the number of duplicate points in the plane

[francorbusetti]

I have 2 columns representing points P in the x-y plane, e.g.

Pn xn yn
P1 2 3
P2 1 2
P3 9 6
P4 2 5
P5 1 2
P6 2 5

How can I find the number of duplicate points (e.g. 2 here)?
Needs to be via formula, not manually or code.

 

[Eric W]

Possibly:

Book1
	A	B	C	D	E
1	Pn	xn	yn		# of Duplicates
2	P1	2	3		2
3	P2	1	2
4	P3	9	6
5	P4	2	5
6	P5	1	2
7	P6	2	5
Sheet8

Cell Formulas
Range	Formula
E2	=SUMPRODUCT(IFERROR(EXP(LN(FREQUENCY(MATCH(B2:B7&"|"&C2:C7,B2:B7&"|"&C2:C7,0),ROW(B2:B7)-ROW(B2)+1)-1)),0))

 

[francorbusetti]

Thanks, that's great

 

[Eric W]

You're welcome.