Hello all,
I have set of data runing from A-C. A and B have dups and C does not, but C
has a differect dollar amount for the dup. I need to high-li the large of the
two (or 3 or 5) amounts. For the first part I have the folling:
=IF(OR(A3=A2,A3=A4),"Duplicate","") and that works. Thank
Data
ATLAKLExpress AKL 5.01
ATLBHXExpress BHX 3.47
ATLBKKExpress BKK 10.20
ATLBRUExpress Duplicate BRU 3.47< -- High-li
ATLBRUExpress Duplicate BRU 1.55
ATLCPHExpress CPH 3.78
ATLDUBExpress DUB 4.20
ATLHAJExpress HAJ 1.54
ATLHKGExpress HKG 1.26
ATLHYDExpress HYD 1.55
ATLICNExpress ICN 1.52
ATLJNBExpress JNB 2.90
ATLLHRExpress LHR 1.92
ATLPLHExpress Duplicate PLH 1.92
ATLPLHExpress Duplicate PLH 3.38<-high-li
ATLPVGExpress Duplicate PVG 2.41
ATLPVGExpress Duplicate PVG 2.41< not sure here