Formula to sort lowest value of doublets

In A I determine if the customer is returning.
They could be in the data 100's of times with a different price, or sometimes 2 of the same ie. "750" in the sample.

I need to remove the lowest value/or one of 2 identical prices from every customer, so the ones that marked "this" in F would return Single in A - I only need 1 "Returning" pr customer.

https://www.excelforum.com/attachmen...1&d=1652941718

Try this, copied down:

Formula:

Please Login or Register  to view this content.

D2 copied down:

Formula:

Please Login or Register  to view this content.

Try this:

=IF(AND(COUNTIF($C$2:$C2,C2)>1,E2<>MINIFS($E$2:$E$20,$C$2:$C$20,C2),COUNTIFS($C$2:$C2,C2,$A$1:$A1,"Returning")=0),"YES","")

That almost get's me there, but look at customer 541561 (C12 and C20) A12 should be returning

Not according to your sample workbook. Look:

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	A	B	C	D	E	F
12	Single		541561		5000.00
13	Returning		6468	YES	750.00	This should return single in A13, because it's 2 equal prices(750) and I only want 1 showing
14	Single		6468		750.00	As long as just one is "Returning", this should work for you.
15	Single		879		81.00
16	Single		7545451		351.00
17	Single		4664		651.00
18	Single		8944		651.00
19	Single		84968964		1561.00
20	Single		541561		3000.00	This should return single in A20, because it's the lowest price of the 2 on that customer

Sheet: Ark1

Try this:

=IF(OR(COUNTIFS(C$2:C2,C2,E$2:E2,E2)>1,AND(COUNTIF($C$2:$C$20,C2)>1,E2<>MINIFS($E$2:$E$20,$C$2:$C$20,C2),COUNTIFS($C$2:$C2,C2,$A$1:$A1,"Returning")=0)),"YES","")

Actually, I think you need this:

=IF(OR(AND(COUNTIFS(C$2:C2,C2,E$2:E2,E2)>1,E2<>MINIFS($E$2:$E$20,$C$2:$C$20,C2)),AND(COUNTIF($C$2:$C$20,C2)>1,E2<>MINIFS($E$2:$E$20,$C$2:$C$20,C2),COUNTIFS($C$2:$C2,C2,$A$1:$A1,"Returning")=0)),"YES","")

Thanks for the rep - I hope you saw post #13, because if not, I think you are going to hit snags.