Sort the values depends upon first three segment

Dear expertise

I have data which is splited as minus and plus values along with MICR Code. on both side

i want sort the values both side from largest to smallest on both side, but same values repeat values are there but same MICR code.

i want match TE008-145788-109-E1207-008R-USD-INR & TE008-145788-109-E1307-008R-USD-INR first three segment value

if atleast two segment match then sort value to exact MICR code
TE014-145794-125-E1213-008R-USD-INR = 720995
TE014-145794-115-E1313-008R-USD-INR = -720995

Find the attachment

if you sort largest to smallest values it not come not exact plus minus segment.

for e.g 1058375 it reflect 5 line in both side but as per comparsion of micr code it not same in comparison of code
first three segment is not match TE016-252202-301 & TE016-252202-303 then check first two segment TE016-252202 & TE016-252202 but value should match

i want first three segment match with opposit segment code then cost should match, same cost but different Code is duplicate

yes i want to match data in column A and B against E and F

i couldnt get exact result what i looking for can u add working sheet ?

See Attachment!! Create New NameManager of PWC of Range E:E This is UDF Formula J2 =FUZZYFIND(A2,PWC) fill down. for cost DO=VLOOKUP(J2,$E$2:$F$23,2,0)
Here

Please Login or Register  to view this content.

Code credits to Robert solution

Thank alot Sir It's work for me Solved