HELP : formula or macro to set a particular code different number of customers

Would you explain that what logic is behind the new codes shown in Col. G? Because G4:G15 seems to have same logic but G16:G19 seems to have different one.

Agree with sktneer that the logic for the last few seems different?

On the assumption that you made a mistake with the last few, try this, copied down...
=MID(D4,FIND("-",D4,1)+1,FIND(" ",D4,1)-1-FIND("-",D4,1))

Hi,


Thanks for reply.

Logic is same for all three cases.

In first case(D4:D9) code is different like DAB126, DHR 134 for same customer 'AB Mart' so I have selected AB as new code same as in second case. But in third case system generated customer code is common so I have selected ADB129 as new code.

My first preference is system generated code if it matches then code is selected as new code if not then I have to compare first two words of customer name and then first word of customer name is selected as new code.

On the basis of new code I have to arrange them as one customer instead of many. Like in first case (D4:D9) new code is AB for the whole group.

Why not be consistent and use the first two letters after the "-" as the basis for the code.

Formula:

Please Login or Register  to view this content.

The result would be:
AB
AB
AB
AB
AB
AB
AR
AR
AR
AR
AR
AR
RA
RA
RA
RA