Remove multiple Nos. with 1 condition

[RAJESH1960]

Hello guys
Need your help to enter formula - The invoice numbers in some of the rows are a repeat which I want to delete. I am trying to enter a formula to get 1 invoice number in the F column if the invoice number is a repeat then it should show blank. As the data has more than 800 vouchers, manually deleting them takes a lot of time. A formula will reduce the time to get the solution, after which I can sort the data and delete the blank cells. There is one condition to be added to the formula, If the customer name and invoice number are the same, then only one invoice number should show in the F column.

Seperate Multiple Invoice Nos..xlsx
	A	B	C	D	E	F
1			TIN		Invoice number	Get 1 Invoice No.
2	1		Customer 1		2192
3	2		Customer 1		2192
4	3		Customer 3		107
5	4		Customer 4		108
6	5		Customer 4		108
7	6		Customer 4		108
8	7		Customer 7		102
9	8		Customer 8		50
10	9		Customer 8		50
11	10		Customer 10		INC/2050
12	11		Customer 10		INC/2050
13	12		Customer 23		108
14	13		Customer 23		2192
15	14		Customer 25		451891630
16	15		Customer 26		108
17	16		Customer 26		108
18	17		Customer 27		2050
19	18		Customer 28		1
20	19		Customer 28		1
21	20		Customer 28		1
Seperate Multiple Invoice Nos

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E2:E21	Expression	=COUNTIFS(C$2:C$19979,C2,E$2:E$19979,E2)>1	text	NO
E2:E21	Expression	=COUNTIFS(D$2:D$1814,D2,E$2:E$1814,E2)>1	text	NO

 

[RAJESH1960]

I got it right. =IF(COUNTIFS(C$2:C3,C3,E$2:E3,E3)=1,E3,"").