PDA

View Full Version : Excel formula to combine



shan
08-25-2015, 03:23 AM
Hello Everyone,

Need your assistance for below..

I have below data. The data is huge.

I need a excel formula which will give me output in "Route" column as per the logic mentioned in G and H column in attached file.

shan
08-25-2015, 08:06 PM
If no excel formula can be set ... then can anybody assist me with a macro code...