Duplicate Issue

[Citrusandsage]

I have a commission Plan that pays a Rep a Flat fee per Opportunity "Based on Deal size" that is sourced from a meeting. The Rep however can book multiple meetings on one Opportunity and sales opps can not find a way to filter out duplicates from the report. My formula from last year would count the number of Opps, and then assign points for duplicates so if there is 2 opps then we just needed to divide the amount by 0.50. This will not work for 2025 since now we are paying a flat fee opposed to a % based on target.
I need to be able to only bring back a 1 on the first instance and ignore the rest of the duplicates so I do not double pay them and do not have to filter these out manually.

Solve for >> H4 - H13, put a 1 only in the first instance of the ID in column B and put a 0 for the rest of the duplicates.

 

[Asbestos_Jen]

I made some assumption, since your picture didn't show column ids. Try this:

Book1
	A	B	C	D	E	F	G	H
1
2			=COUNTIF(A:A,A4)	=IFERROR(1/C4,0)	=C4/D4
3	ID	Amount	Dup indicator	Points	Amount		Points	Amount
4	1001	$ 80,000.00	2	0.5	$ 160,000.00		1	$ 80,000.00
5	1001	$ 80,000.00	2	0.5	$ 160,000.00		0	-
6	1002	$ 10,000.00	1	1	$ 10,000.00		1	$ 10,000.00
7	1003	$ 20,000.00	1	1	$ 20,000.00		1	$ 20,000.00
8	1004	$ 15,000.00	2	0.5	$ 30,000.00		1	$ 15,000.00
9	1004	$ 15,000.00	2	0.5	$ 30,000.00		0	-
10	1005	$ 60,000.00	3	0.333333333	$ 180,000.00		1	$ 60,000.00
11	1005	$ 60,000.00	3	0.333333333	$ 180,000.00		0	-
12	1005	$ 60,000.00	3	0.333333333	$ 180,000.00		0	-
13	1006	$ 25,000.00	1	1	$ 25,000.00		1	$ 25,000.00
Sheet1

Cell Formulas
Range	Formula
C4:C13	C4	=COUNTIF(A:A,A4)
D4:D13	D4	=IFERROR(1/C4,0)
E4:E13	E4	=B4/D4
G4:G13	G4	=IF(COUNTIF($A$4:$A4,$A4)=1,1,0)
H4:H13	H4	=IF(G4=1,B4," - ")